My Oracle Support Banner

AR: Journal Entries Report (ARRGTA) Error ORA-01400: Cannot Insert NULL Into ("AR"."AR_JOURNAL_INTERIM_ALL"."CUR (Doc ID 2803027.1)

Last updated on JULY 12, 2023

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

On : R12 version, Reports Issues

When running AR: Journal Entries report(ARRGTA) for 'Trade Receipt Category' or 'CM Application Category' and for a particular period, the following error occurs:

ERROR:
-----

Oracle error in function 'arjira'
AR-ARRGTA: -1400 ORA-01400: cannot insert NULL into ("AR"."AR_JOURNAL_INTERIM_ALL"."CUR
AR-ARRGTA: Error from arjira
AR-ARRGTA: Error from arjicr
     Truncating AR_JOURNAL_INTERIM table.
     AR_JOURNAL_INTERIM table are truncated.



STEPS:
--------
Receivables:
Navigation: Control > Requests > Run
Report Name: AR: Journal Entries Report


Changes

 

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
Changes
Cause
Solution
References


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