问ORACLE ERP 二次开发一个FORM的挂接问题

hua

是用 BIN 方式上传FORM文件吗?

oracleerp0606

还是不行啊? 有人知道吗?

schuacn

最初由 oracleerp0606 发布
[B]原来的PROD.env中FORMS60_PATH路径是这样的:

FORMS60_PATH="$AU_TOP/resource"
export FORMS60_PATH


我改了以后是这样的
FORMS60_PATH="$AU_TOP/resource:$INV_TOP/forms"
export FORMS60_PATH


改完后执行PROD.env,  

请问这样设置路径对吗? [/B]

================================
改成：
FORMS60_PATH="$AU_TOP/resource:$INV_TOP/forms/ZHS"
export FORMS60_PATH

arsenefang

最初由 oracleerp0606 发布
[B]我在ERP 服务器的ORACLE APPLICATIONS  11i的/AU/11.5.0/FORMS/US目录下载了TEMPLATE.FMB到我本地, 然后用我本地的ORACLE 10G FORMS BUILDER改变其MODULE名称,另存为TEST.fmb, 再将 此表单上传到ERP服务器的/INV/11.5.0/FORMS/ZHS目录, 由于服务器的ORACLE ERP是装在SOLARIS系统下的,所以要重新编译TEST.fmb为TEST.fmx, 才能在ERP菜单中注册后重新挂接. 可是我在SOLARIS下(/INV/11.5.0/FORMS/ZHS目录下)编译总是错误, 错误如下:

$ f60gen  module=TEST.fmb  userid=APPS/APPS@PROD
Forms 6.0 (Form Compiler) Version 6.0.8.19.1 (Production)

Forms 6.0 (Form Compiler): Release  - Production

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
     With the Partitioning option
     JServer Release 8.1.7.4.0 - Production
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.17.0 Build #0 - Production
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Multimedia Version 6.0.5.33.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 - Production
FRM-18108: Failed to load the following objects.

Source Module:TEMPLATE.fmb
  Source Object: FRAME_HORZ_LINE
Source Module:TEMPLATE.fmb
  Source Object: FRAME_RECT
Source Module:APPSTAND
  Source Object: STANDARD_PC_AND_VA
Source Module:APPSTAND
  Source Object: STANDARD_TOOLBAR
Source Module:APPSTAND
  Source Object: STANDARD_CALENDAR
Form: TEST

FRM-30085: Unable to adjust form for output.


Form not created
哪位知道是什么原因啊? 谢谢! [/B]

這個問題是因為在編譯TEST.fmb時，編譯器需要參考到APPSTAND.fmb(TEMPLATE.fmb裡已經內建此關係)，所以需要讓編譯器找得到 APPSTAND.fmb即可。
方法一：
把$AU_TOP/forms/US/APPSTAND.fmb複製一份到目前編譯的路徑，例如$INV_TOP/forms/ZHS
方法二：(建議)
把forms60_path增加指到$AU_TOP/forms/US，例如：
原来的PROD.env中FORMS60_PATH修改如下：
FORMS60_PATH="$AU_TOP/resource:$AU_TOP/forms/US"
export FORMS60_PATH
改完后执行PROD.env, 並設定每次登入後都會執行PROD.env。

以上.

leon_dy

Note:1035497.6
Subject:  How to Troubleshoot FRM-30085 Unable to Adjust Form for Output
PROBLEM DESCRIPTION:
====================

You are receiving the following error when running a form:

  FRM-30085 - Unable To adjust form for output.

The form has compiled without errors.

You have looked at the form in the Form Builder under the Layout Editor
and everything looks fine.  You cannot identify any object that is not
on the canvas view.


SOLUTION DESCRIPTION:
=====================

This error may occur, and the user may not see an object off the screen.  There
are two ways that this can be resolved.

1.  Create a new form, and drag items from the old form into the new form,
    incrementally compiling the new form.

2.  Copy the .fmb to a new file, and delete items from the new form, until you
    find the item causing the problem.  You can then go to the original .fmb
    file, and fix the output.


EXPLANATION:
============

This error is often caused by an object in the data block that is not placed
within the borders of a canvas.

Removing or moving the object, so that it physically appears on the associated
canvas, resolves the issue.


.
好象没有修改好form吧

oracleerp0606

最初由 arsenefang 发布
[B]

這個問題是因為在編譯TEST.fmb時，編譯器需要參考到APPSTAND.fmb(TEMPLATE.fmb裡已經內建此關係)，所以需要讓編譯器找得到 APPSTAND.fmb即可。
方法一：
把$AU_TOP/forms/US/APPSTAND.fmb複製一份到目前編譯的路徑，例如$INV_TOP/forms/ZHS
方法二：(建議)
把forms60_path增加指到$AU_TOP/forms/US，例如：
原来的PROD.env中FORMS60_PATH修改如下：
FORMS60_PATH="$AU_TOP/resource:$AU_TOP/forms/US"
export FORMS60_PATH
改完后执行PROD.env, 並設定每次登入後都會執行PROD.env。

以上. [/B]

您好! 我按您的方法又设了一下路径, 又出现下列错误:
$ f60gen module=TEST123.fmb userid=APPS/APPS@PROD
Forms 6.0 (Form Compiler) Version 6.0.8.19.1 (Production)

Forms 6.0 (Form Compiler): Release  - Production

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
     With the Partitioning option
     JServer Release 8.1.7.4.0 - Production
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.17.0 Build #0 - Production
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Multimedia Version 6.0.5.33.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 - Production
ROS ERROR: -200
Segmentation Fault - core dumped

这是怎么回事啊??

oracleerp0606

按新方法重设路径后,编译出现
ROS ERROR: -200
Segmentation Fault - core dumped

这是什么错误啊?

另外我的FORM 是用WINDOWS下的FORMS BUILDER(ORACLE  DEVELOPER SUITE 10G)做的,是不是版本太高,拿到SOLARIS下用FORMS 6.0 编译器不能编译啊??

谢谢了!

Harry_shan

最初由 oracleerp0606 发布
[B]按新方法重设路径后,编译出现
ROS ERROR: -200
Segmentation Fault - core dumped

这是什么错误啊?

另外我的FORM 是用WINDOWS下的FORMS BUILDER(ORACLE  DEVELOPER SUITE 10G)做的,是不是版本太高,拿到SOLARIS下用FORMS 6.0 编译器不能编译啊??

谢谢了! [/B]

很有可能，用6i做一个试试

oracleerp0606

最初由 Harry_shan 发布
[B]

很有可能，用6i做一个试试 [/B]

可是我的6I自带的ORACLE客户端有问题啊,用6i 数据库都连不上,
能不能在SOLARIS上装 FORM 9.O 以上版本的编译器呢??
我现在SOLARIS上不能用 f90gen命令, 只能用 f60gen命令. 请问如何才能在SOLARIS上使用f90gen命令呢?

oracleerp0606

我又试了一下, 这次没用下载的TEMPLATE.FMB 做模版,  自己用FORMS BUILDER 10G 做了一个FORM, 上传后反而在SOLARIS下成功编译了, 而且也能挂接到ORACLE ERP 系统下,  那二次开发为什么非要用基于TEMPLATE.FMB的模板啊, 自己做的不也可以吗?

谁能告诉我二次开发用基于TEMPLATE.FMB的模板有什么好处吗?

请教大家.