Receivables Auto Invoice Import Failed with DUPLICATE INVOICE Error Message
Introduction:-
Oracle Fusion Cloud Applications 23B (11.13.23.04.0) Information in this document applies to any oracle fusion platform.
Cause of the issue:-
While we are receiving the data from feeder system through a data file (FBDI) we are receiving with multiple payment terms for an invoice
Normally we would be having only one payment term per one invoice and it should be unique for invoice. In any case, if we receive multiple payment terms for multiple invoice lines that would go to Error.
In generally system validates the data before it process it in the base tables, while doing that if there are any multiple payment terms, it will consider each line as a separate invoice based on the payment term, then when we have different lines with different payment terms with the same invoice numbers will be stuck at interface with this error message.
How do we solve:-
This solution is applicable for fusion receivables environment for any version, We need to navigate to the ADFDI sheet and need to query for the interface batch data by source and business unit, when you click on search it will be displaying the lines which are stuck for that invoice.
We need to validate the payment terms for all the invoice lines and need to correct/update the payment terms for the invoice lines… Each invoice should have only one payment term, means though we have multiple lines, we should have only one payment term for all invoices.
Once the payment term is placed we need to click on Update from Manage Auto Invoices options (Add ins), it will update the interface lines with the new payment terms. Once it is updated you need to submit the Import Auto invoice job to import the data to the base tables.
There are two ways in calling this Import Auto Invoice Job. We can navigate to the scheduled processes and we can run this Import Auto Invoice job for that source or we can click on Submit button from the ADFDI sheet, which will ask for transaction source and other required parameters to import the data.
