Import AutoInvoice Program Does Not Process Records In Interface (Doc ID 2691431.1)

Last updated on MAY 25, 2023

Applies to:

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

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