Forms 6i gives FRM-40734 Internal PL/SQL Error after Hourglass for 30 Min
331237Aug 16 2005 — edited Aug 21 2005Hi,
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