ITPub博客

打开EBS，系统报：FRM-92095: Oracle JInitiator 版本太旧。 请安装版本1.1.8.2或更高版本（英文的错误信息是：FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher）解决方法1：因为今天升级了JRE到Version 7，但实际上现阶段EBS还不能跑在JRE7上。解决方法就是卸载JRE7，重装JRE6.Reference Note:    FRM-92095 Error When Running Forms Using JRE 7 (JRE 1.7) (Doc ID 1348436.1)如何卸载JRE7

使用loadjava命令load class到oracle数据库，这个时候报java.lang.UnsupportedClassVersionError错。 解决方法： UnsupportedClassVersionError错误是因为javac的版本问题，jvm默认为1.6，然而EBS的class的版本是1.5，所以直接javac编译的话，产生的class文件时1.6版本的class，这和EBS系统的版本不匹配，所以报错。 解决方法就是，在javac后边指定编译的版本为1.5. 命令：javac *.java -target 1.5

编译Form时报bad bind variable \'parameter.G_query_find\'样的错误 PL/SQL ERROR 49 at line 1, column 1 bad bind variable \'parameter.G_query_find\' PL/SQL ERROR 49 at line 1, column 1 bad bind variable \'parameter.G_query_find\' PL/SQL ERROR 49 at line 3, column 1 bad bind variable \'parameter.G_query_find\' .... 解决方法： 出现这个错误的原因是因为环境变量FORMS_PATH(11i为FORMS60_PATH)没有设置正确导致的。 使用下边命令重新设置FORMS_PATH,

1. 打开Template.fmb，并另存为一个名字(QUERYFIND.fmb) 2.从Window,Canvas,Data Block中删除BLOCKNAME，从Data Block中删除DETAILBLOCK 3.创建一个Window（DEPT_WINDOW），subclass选择WINDOW 4.Pre-Form trigger中，把DEPT_WINDOW设置为第一个显示的窗口 Program Unit:APP_CUSTOM中，设置关闭窗口的行为 5.定义一个Canvas(DEPT_CANVAS),subclass设置为CANVAS 6.通过Wizard创建Data block:DEPT，在Table中使用DEP

Perform an action after fetching a record, such as looking up values in other tables based on a value in the current record.  Fires once for each record fetched into the block. Description When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block.  The trigger fires once for each record placed on the block\'s list of records. Definition Level  form or block Legal Commands SELECT statements, unrestricted built

Validate the current query criteria or provide additional query criteria programmatically, just before sending the SELECT statement to the database. Description Fires during Execute Query or Count Query processing, just before Form Builder constructs and issues the SELECT statement to identify rows that match the query criteria. Definition Level  form or block Legal Commands SELECT statements, unrestricted built-ins Enter Query Mode  no Usage Notes Use a Pr

客户遇到一问题，于是让客户收集INV的日志再分析原因，但不管怎么搞，日志都是收集不到(客户的设置没有问题)。 最后发现，原来客户的DB Server和Apps Server在不同的机器上，而日志是打到DB Server上的，而之前客户一直在Apps Server上找，所以没找到。 小问题，有时反倒让人容易忽略。

Introduction This document lists the order in which triggers fire in Oracle Forms 4.5: o The first column, Action, describes the function to be performed (e.g. deleting a record). o The second column, Trigger Firing Order, describes the order in which triggers fire after a function is performed. o The third column, Level, describes the level (form, block, item) at which the trigger fires. This was accomplished by creating a form with all the triggers invoked. If a tr

F11查询过程： 1)WHEN-CLEAR-BLOCK 2)WHEN-NEW-RECORD-INSTANCE 3)WHEN-NEW-ITEM-INSTANCE 在输入查询条件后点CTRL+F11： 4)PRE-QUERY Provide additional query criteria programmatically, just before sending the SELECT statement to the database. Sample Code: If :parameter.G_query_find = \'TRUE\' then   :trans_reasons.reason_id := :parameter.trans_reasons_qf;   :parameter.G_query_find := \'FALSE\'; end if; 5)WHEN-CLEAR-BLOCK 6)POST-QUERY Perform an

触发器执行顺序：1．  当打开FORM时：（1）       PRE-FORM（2）       PRE-BLOCK（BLOCK级）（3）       WHEN-NEW-FORM-INSTANCE（4）       WHEN-NEW-BLOCK-INSTANCE（5）       WHEN-NEW-RECORD-INSTANCE（6）       WHEN-NEW-ITEM-INSTANCE2．  当填

Function Shortcut KeyShow Shortcut KeysCtrl + KEnter QueryF11Execute QueryCtrl + F11Count QueryF12Clear BlockF7Clear FieldF5Clear FormF8Clear RecordF6EditCtrl + EUpdate RecordCtrl + UInsert RecordCtrl + DownDelete RecordCtrl + UpCommitCtrl + SDuplicate FieldShift + F5Duplicate RecordShift + F6List of valuesCtrl + LList Tab PagesF2Next FieldTabNext RecordDown Arrow KeyNext PrimaryKey Shift + F7Next Set of RecordsShift + F8Previous FieldShift + TabPrevious RecordUp Arrow KeyPrevious BlockShift+P

1. Source org and destination org both are non-onhand status tracking organizations (Item is lot controlled) 1.1 If Lot is NEW one for Receiving org. Allow Different material Status = Y Intransit/Direct: Default Status from the organization item setup. See Bug 10257769 & 11688000 Allow Different material Status = No Intransit: Copy lot status from source org to destination org. Direct: Copy lot status from source org to destination org. See Bug 14404578 forms/US/INVTTELT

甲骨文的第一位员工叫Bruce Scott（employee number #4）加盟，用过ORACLE数据库软件的人都知道有个Scott用户的吧？没错，就是这个Scott，至于Scott用户的密码Tiger，那是Scott养的猫的名字。 Bruce Scott was one of the first employees (number 4) at Oracle Corporation (then Software Development Laboratories). He was co-author and co-architect of Oracle V1, V2 and V3. The SCOTT schema (EMP and DEPT tables), with password TIGER, was created

站点数据统计(2013-9-6)    访问：501636次    积分：11973分    排名：第205名    原创：650篇    转载：61篇    译文：5篇    评论：147条---------------------------------------------------------------------------------------------------------------------站点数据统计(2013-6-5)访问：400084次积分：10452分排名：第237名原创：604篇转载：60篇

Apps Server上运行 sh -c "`awk -F= \'$1 ~ /^JSERVJAVA.*$/ {print $2}\' $ADMIN_SCRIPTS_HOME/java.sh` -version;" Example: [oracle@PROD ~]$ sh -c "`awk -F= \'$1 ~ /^JSERVJAVA.*$/ {print $2}\' $ADMIN_SCRIPTS_HOME/java.sh` -version;" java version "1.6.0_10" Java(TM) SE Runtime Environment (build 1.6.0_10-b33) Java HotSpot(TM) Server VM (build 11.0-b15, mixed mode) [oracle@bej301441 ~]$

RCD(Release Content Documents) & Products Covered RCD(Release Content Documents) Products Covered Applications Technology Oracle Application Object LibraryOracle Application FrameworkOracle Applications ManagerOracle Diagnostics FrameworkOracle E-Business Suite Applications DBAOracle E-Business Suite Integrated SOA GatewayOracle E-Business Suite Secure Enterprise SearchOracle iSetupOracle Report Manager Oracle User ManagementOracle Web Applicati

-bash-3.2$ ./mwactl.sh start 10999 MWA Telnet Server Release: 1.0.8.4 [December 12th 2002] mwactl: Unable to determine MWA_TOP. mwactl: Please make sure that MWA_TOP is defined. 解决方法： 切换到$APPL_TOP下，运行一个env文件 -bash-3.2$ cd /u01/R122_EBS/fs1/EBSapps/appl -bash-3.2$ . ./APPSml4yd220_rws3210047.env env文件会初始化环境变量

发现Receiving Transaction Manager为No Manager状态，其他几个主要的Manager（Internal Manager,Standard Manager）都没有问题.重启Receiving Transaction Manager也没有效果。 解决方法： 使用下边SQL查，发现几个关键的RCV Package为Invalid SELECT * FROM dba_objects WHERE status = \'INVALID\' AND object_name LIKE \'RCV%\' 重新编译这些RCV Package之后，在重启Receiving Transaction Manager,问题就解决了。 补充：需要重新接收，原

SELECT * FROM FND_FOLDERS WHERE object = \'INVTVTXN_RESULTS\';SELECT *FROM FND_FOLDER_COLUMNSWHERE folder_id in(SELECT folder_idFROM FND_FOLDERSWHERE object = \'INVTVTXN_RESULTS\');TablesFND_FOLDERS stores information about customized folders. Each row includes the folder identifier, the name of the folder, the object (which uniquely identifies the set of fields in the form), the screen width in inches, and the flag that determines whether the folder can be opened by users other than the folde

遇到了一个 enq: TX - row lock contention的问题，从tkprof看，update真正执行的时间(cpu)很快，但elapsed时间非常长，在最后发现 enq: TX - row lock contention时间很长。 UPDATE MTL_ITEM_LOCATIONS SET STATUS_ID = :b1   WHERE  INVENTORY_LOCATION_ID =  :b2   call     count       cpu    elapsed       disk      qu