Error :ORA-01747: Invalid user.table.column ORA- 06512 while matching PO invoices (Doc ID 2730981.1)

Last updated on NOVEMBER 27, 2021

Applies to:

Symptoms

Reported Issue
-----------------
Error when trying to match PO invoices.

Error message 
-----------------
APP-SQLAP-10000: ORA-01747: invalid user.table.column, table.column, or column specification
ORA-06512: at "APPS.CLE_F126_IPV_PROTOCOL_PKG", line 2223
ORA-06512: at "APPS.CLE_F126_AP_INVOICES_AU2", line 7
ORA-04088: error during execution of trigger 'APPS.CLE_F126_AP_INVOICES_AU2' occurred in
AP_AI_TABLE_HANDLER_PKG.INSERT_ROW<-AP_INVOICES_PKG.INSERT_ROW<-APXINWKB
with parameters (p_Rowid = , p_invoice_id = XXXXX)
while performing the following operation:
Insert into ap_invoices_all

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an invoice.
2. Match it with PO.
3. Notice the given error.


Expected Behavior 
---------------------
Expects that the PO matched invoices should be allowed for creation.

Changes

Cause

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