My Oracle Support Banner

Patch 26372978 failed Running FNDLOAD for arglc.ldt with Error: ORA-01400: cannot insert NULL into ("AR"."RA_LINE_ORDER_BYS"."COLUMN_ID") (Doc ID 2435132.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

Patch 26372978 failed running FNDLOAD for arglc.ldt file.

 

Patch log shows the following:

Loading data using  FNDLOAD function.
FNDLOAD APPS/***** 0 Y UPLOAD @AR:patch/115/import/arglc.lct @AR:patch/115/import/US/arglc.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /<DIR>/US_arglc_ldt.log
Error calling FNDLOAD function.

 

FNDLOAD log file shows the following:

Uploading from the data file /<DIR AR_TOP>patch/115/import/US/arglc.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/<DIR AR_TOP>/patch/115/import/arglc.lct(120.1), /<DIR AR_TOP>/patch/115/import/US/arglc.ldt) to staging tables
Dumping LCT file /<DIR AR_TOP>/patch/115/import/arglc.lct(120.1) into FND_SEED_STAGE_CONFIG
Dumping LDT file /<DIR A_TOP>/patch/115/import/US/arglc.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (RA_GROUPING_RULES -1 , RA_GROUPING_RULES 1024 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
 Error loading seed data for RA_LINE_ORDER_BYS:  ORDERING_RULE_ID = 1, LOR = 1, ORDER_BY_SEQUENCE = 1,  ORA-01400: cannot insert NULL into ("AR"."RA_LINE_ORDER_BYS"."COLUMN_ID")
ORA-01403: no data found



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
 Still Have Questions?


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