Import AutoInvoice Program Does Not Process Records In Interface
(Doc ID 2691431.1)
Last updated on MAY 25, 2023
Applies to:
Oracle Fusion Receivables Cloud Service - Version 11.13.20.04.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.20.04.0 version, Customer Billing (Transactions)
Import AutoInvoice program does not process records in Interface
Import Exceptions Infotile shows all records as Unprocessed lines
Scenario:
1. Importing Migration Invoices & Credit Memos in FBDI AutoInvoiceImporttemplate; Each distinct transaction has only 1 line in RA_INTERFACE_LINES_ALL and corresponding distribution line in RA_INTERFACE_DISTRIBUTIONS_ALL
2. Try full load Import AutoInvoice program still does not process records
Log shows the below error:
ERROR
-----------------------
Document Sequencing mode :::
Document Sequencing level:::
Enforce Correlation:::
Accounting Dates out of Order:::
Entering the block for Ledger based document sequencing option
No assignment exists and the sequencing option is always used -- insert into errors table
(DATE=11-JUL-2020) (TIME=09:59:39)
(GENERIC_TEXT=ORA-01000: maximum open cursors exceeded
)
insert into RA_INTERFACE_ERRORS (INTERFACE_LINE_ID,MESSAGE_TEXT,INVALI^X
(GENERIC_TEXT=c/src/autoinv/raavdn.lpc 671)
Document Sequencing mode ::: <>
Document Sequencing level::: <>
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run AutoInvoice process
2. Process ends in Success, but it does not process the interface data.
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 |
References |