My Oracle Support Banner

G-Invoicing Requesting 7600EZ Not Creating AP Invoices After Completing From BWC (Doc ID 3012016.1)

Last updated on MARCH 22, 2024

Applies to:

Oracle Purchasing - Version 12.2.13 and later
Information in this document applies to any platform.

Symptoms

G-Invoicing Requesting 7600EZ is not creating AP Invoices after Completing from Buyer Work Center (BWC).

A] Issue1: If an EZ fails for some reason, Header still says ‘Inprogress’ and there is no recovery option except to update table with status=’Incomplete’
B] Issue2: Potential code issue causing error while creating lines in interface

ERROR:
"Failed while inserting data into ap_invoice_lines_interface table"
";SQLERRM = ORA-22160: element at index[2] does not exist."

STEPS
-----------------------
1) Using Purchasing/G-Invoicing responsibility, Pull an EZ invoice into EBS, enter the Supplier, Accounting Flexfield Info from Update EZ page and submit which marks as internal_status='Completed'.
2) Launch Payables Integration Program by providing Org Name, Standard Invoice as parameters (without Ordr Info).
3) It tries to pick all the eligible Performance records in 'Pending Invoicing'. So, in customer case, there are 3 records picked:
1. Performance (valid record)
2. Performance (Invalid record as prepayment amount < invoice amount)
3. EZ invoice created above.

4) X_INV_HDR_DATA , X_INV_LINES_DATA is populated for record 1
5) When validation while building interface records is done, the second record X_INV_HDR_DATA is initialized and some values are assigned but validation failed at prepayment check.
So, it is stamped as error and X_INV_LINES_DATA is not assigned any data for that incremented index.
6) For EZ, X_INV_HDR_DATA , X_INV_LINES_DATA is populated
7) While the application is inserting data into ap_invoice_lines_interface, the following error occurs:
"Failed while inserting data into ap_invoice_lines_interface table"
";SQLERRM = ORA-22160: element at index[2] does not exist."

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


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