My Oracle Support Banner

SAEXPGL Job Fails With Error ORA-01400: Cannot Insert NULL Into SA_GL_REF_DATA.ACCT_DATE (Doc ID 2807179.1)

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

Sales audit GL posting batch- SAPEXPGL failed with below errors.

Error:
saexpgl_1~20210428075324~InsertToOracleGL~sa_gl_ref_data~-1400~ORA-01400:cannot insert NULL into ("RMSXX"."SA_GL_REF_DATA"."ACCT_DATE")~Array insert to sa_gl_ref_data null
saexpgl_1~20210428075324~process~sa_gl_ref_data~0~ORA-0000: normal,successful completion~Cannot Process storeday return error for 8000001 null


Steps To Recreate:
1. Run SAPEXPGL
2. Batch fails.

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.