ATP Inquiry Form Shows : ORA-01403: No Data Found And Form Does Not Open

(Doc ID 1437126.1)

Last updated on FEBRUARY 19, 2016

Applies to:

Oracle Global Order Promising - Version 12.1.3 and later
Information in this document applies to any platform.


12.1.3 in Test with patch

ATP Inquiry form will not open
1. Happens only on the APS destination instance
2. We have distributed install and the form opens fine on the EBS Source instance.

Gives error
ORA-1403: No data found
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exceptions ORA-06550

Tried to manually recompile the forms and libraries to fix the error and this did not work
No errors when recompiling the form.

go to ASCP responsibility and try to open the form.

form will open normally.

Cannot use this form, which is part of our business process requirements.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms