My Oracle Support Banner

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:

EMEA Add-on Localizations - Version 12.1.3 and later
Information in this document applies to any platform.


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
with parameters (p_Rowid = , p_invoice_id = XXXXX)
while performing the following operation:
Insert into ap_invoices_all

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.




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

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