Load Interface Table Showing Status As "Warning" While Uploading Auto Invoice CSV File
(Doc ID 2811566.1)
Last updated on JULY 07, 2024
Applies to:
Oracle Fusion Receivables Cloud Service - Version 11.13.21.07.0 and laterInformation in this document applies to any platform.
Symptoms
Load interface file for import is filing to load interface lines and distributions.
Log shows:
455630-int-lt.txt
Record 1: Rejected - Error on table RA_INTERFACE_LINES_ALL.
ORA-01400: cannot insert NULL into (???)
Record 2: Rejected - Error on table RA_INTERFACE_LINES_ALL.
ORA-01400: cannot insert NULL into (???)
455629-dis-lt.txt
value used for ROWS parameter changed from 64 to 9
Record 1: Rejected - Error on table RA_INTERFACE_DISTRIBUTIONS_ALL, column AMOUNT.
ORA-01722: invalid number
Record 2: Rejected - Error on table RA_INTERFACE_DISTRIBUTIONS_ALL, column AMOUNT.
ORA-01722: invalid number
Record 3: Rejected - Error on table RA_INTERFACE_DISTRIBUTIONS_ALL, column AMOUNT.
ORA-01722: invalid number
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 |