Print an Invoice Under 'All Customer Accounts' View Gives ORA-01400
(Doc ID 1270075.1)
Last updated on FEBRUARY 15, 2019
Oracle iReceivables - Version 12.1.1 and later Information in this document applies to any platform.
'OIR: Account Grouping profile option' is set to Always Group Accounts and Sites.
When logging in as an external user that has access to multiple customer accounts and try to print an invoice under All customer accounts view, the system gives the error:
Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details.
Exception Details. oracle.apps.fnd.framework.OAException: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("AR"."AR_IREC_PRINT_REQUESTS"."CUSTOMER_ID") ORA-06512: at "APPS.ARI_DB_UTILITIES", line 1238 ORA-06512: at line 1 etc...
If you select an invoice and print under a specific customer, then it works fine and there is no error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!