ORA-01403: no data found
FRM-40735 WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-06502
I compiled below items using adadmin. But the problem is still there.
Forms PL/SQL library (.pll)
Forms menu
Generate message files
Generate product JAR files
Forms executable
I also tried "Help > Diagnostics > Trace > Trace with Binds and Waits" to enable forms trace, but did not find any ORA- error in the trace log.
The problem was that one file CUSTOM.pll in $AU_TOP/resource was not owned by appl_mgr, but was owned by a developer who copied it to the server. Because of that, adpatch did not compile it during patching and later adadmin refused to compile it also when I ran adadmin to compile all library files.
After I manually compile it, the popup window does not show up on any forms!
$ export FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US:$AU_TOP/resource
$ cd $AU_TOP/resource
$ frmcmp_batch.sh module=CUSTOM.pll userid=apps/appsPWD module_type=library compile_all=special
CUSTOM.pll timestamp will change and its file size may increase after compilation. Use command to check and compare file contents:
$ adident Header $AU_TOP/resource/CUSTOM.pll
No comments:
Post a Comment