FRM-40735 and ORA-06508 error displaying forms - EBS R12.1.3
I have a several custom forms for EBS that we have used in many instances all around the world. These forms compile and deploy on EBS 11i thru R12 on all operating systems. We have several customers that have deployed these forms in R 12.1.3 without incident. We have one particular customer that the forms compile fine on, but when displayed in EBS, they display an error:
ORA-1403: No Data found
When you click the details button:
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised an unhandled exception ORA-06508.
The only code in the WHEN-NEW-FORM-INSTANCE trigger is:
APP_STANDARD.EVENT('WHEN-NEW-FORM-INSTANCE');
Further more, the template.fmb file that we used as our basis for our forms is from an 11i instance. I took it unmodified and duplicated the error with that template.fmb file. If I take the template.fmb file from an R 12.1.3 system it does NOT have this issue. Again, remember we have these forms working on other in house and customer R 12.1.3 systems just fine.