Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms 6i gives FRM-40734 Internal PL/SQL Error after Hourglass for 30 Min

331237Aug 16 2005 — edited Aug 21 2005
Hi,

I am developing a New custom Form using a copy of Oracle Apps. TEMPLATE.FMB
(Out of two custom forms , I am getting the below issue in only one form and the other is working fine)

Everything works fine but I observed one unique issue during my testing.

I executed the form and entered a value in one column of the master record
(now the record in CHANGED status).

Now I pressed the F11 Key (for Enter-Query in Apps) for doing the
Query by ignoring the entered record values.
Instead of giving a message "Do you want to Save the changes you have made (or)
A Required Field must be entered"

But the Form shows the Hourglass(Busy) for 30 Minutes then gives the error :
FRM-40734 Internal PL/SQL Error


May I know in the above situation, what are the triggers the form will fire and in which sequence (forms 6i)

In summary what form triggers will be fired :
When a NEW record status is CHANGED and when the user invokes Enter-Query
(F11 on Apps and F8 on standalone) , before form changes to Enter-Query mode.


Any pointers to my issue resolution.

Below is my form canvas/block layout and I am getting the issue Only in Master Block and not in any of the detail blocks

MASTER BLOCK
DETAIL1 BLOCK
DETAIL2 BLOCK DETAIL2 BLOCK DETAIL2 BLOCK

thanks,
Shashi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2005
Added on Aug 16 2005
2 comments
603 views