Print an Invoice Under 'All Customer Accounts' View Gives ORA-01400
Last updated on AUGUST 18, 2016
Applies to:Oracle iReceivables - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 31-JAN-2013***
'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:
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
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
If you select an invoice and print under a specific customer, then it works fine and there is no error.
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