Print an Invoice Under 'All Customer Accounts' View Gives ORA-01400 (Doc ID 1270075.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle iReceivables - Version 12.1.1 and later
Information in this document applies to any platform.
12.1.1
***Checked for relevance on 31-JAN-2013***

Symptoms

'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.

Cause

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