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 23, 2020

Applies to:

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

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

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
Changes
Cause
Solution

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