My Oracle Support Banner

Load Interface Table Showing Status As "Warning" While Uploading Auto Invoice CSV File (Doc ID 2811566.1)

Last updated on DECEMBER 09, 2021

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.21.07.0 and later
Information 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


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