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 laterInformation 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 |