ORA-1403,FRM-40735

When-New-Form-Instance Trigger Raised Unhandled Exception ORA-1403 FRM-40735

When-New-Form-Instance Trigger Raised Unhandled Exception ORA-1403 FRM-40735 [ID 265657.1]

--------------------------------------------------------------------------------

Applies to:
Oracle Order Management - Version: 11.5.9 to 11.5.10.3 - Release: 11.5 to 11.5
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders

Symptoms
While trying to enter a new customer in the Sales Orders Form,
receive the following errors:
.
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger unhandled exception.
ORA-1403.
ORA-1403: no data found.
.
Taken to the Add Customer Form, and receive the following errors:

FRM-41084: Error getting Group Cell.
FRM-40105: Unable to resolve reference to item INLINE_ADDRESS..
FRM-41045: Cannot find item: invalid ID.
Note: You cannot pass the account number because account number auto-generation is enabled.
Value for account_number must be unique.
.
Sales Orders Form:

FRM-40212: Invalid value for field SOLD_TO_CONTACT.

Errors in the Forms Trace (.FRD log) :
.
FRM-40815: Variable GLOBAL.GHR_INSTALLATION_STATE does not exist.
FRM-40815: Variable GLOBAL.OPM_GML_INSTALLED1 does not exist.
FRM-40815: Variable GLOBAL.ADD_CUSTOMER_PROFILE does not exist.
FRM-40815: Variable GLOBAL.TELESALES_CALL_ADD_CUSTOMER does not exist.
FRM-40815: Variable GLOBAL.CONTACT_SEARCH does not exist.
FRM-40815: Variable GLOBAL.RECALCULATE_CHARGE does not exist.
FRM-40815: Variable GLOBAL.TELESALES_CALL_ADD_CUSTOMER does not exist.
FRM-40815: Variable GLOBAL.RECALCULATE_CHARGE does not exist.

Cause
Profile Option Setting

Solution
1. Set profile option 'Default Country' to local country (i.e.: United States).
2. Set profile option OM:Add Customer to 'All'.


Note: Some customers have observed that the above do not take affect unless the Defaulting Rule Generator has been run after resetting these profile options.
References
BUG:3228397 - ADD CUSTOMER FROM SALES ORDERS FORM FRM-40735 ORA-01403