My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle iReceivables - Version 12.1.1 and later
Information in this document applies to any platform.
12.1.1

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.