Italy Localization While Trying to Refund the AR Transactions Error "frm-40734 internal error: pl/sql error occurred" is Populated (Doc ID 1966121.1)

Last updated on DECEMBER 07, 2016

Applies to:

EMEA Add-on Localizations - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

In Receivables transaction window, while refund, below error is populated.

 frm-40734 internal error: pl/sql error occurred

FND Debug shows:

CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols 2 Entering CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols
CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols 1 CLE_FND_DOC_SEQ_EXT Vat Registered? IT gc_doc_seq_attributeATTRIBUTE1 CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols
CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols 1 CLE_FND_DOC_SEQ_EXT Temporary Doc Seq IT gc_doc_seq_attribute1ATTRIBUTE2 CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols
fnd.plsql.FND_FILE.PUT_LINE 3 Segment name not foundItalian Hold Types
CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols 1 CLE_FND_DOC_SEQ_EXT Italian Hold Types IT gc_holdcode_attributeNULL CLE_F126_IPV_PROTOCOL_PKG.get_ldff_attribute_cols
fnd.plsql.FND_FILE.PUT_LINE 3 (Insert ap invoices step 4) - Insert into ap_invoices->exception
fnd.plsql.FND_FILE.PUT_LINE 3 ORA-01747: invalid user.table.column
ORA- -1 1090
fnd.plsql.FND_FILE.PUT_LINE 3 06512: at "APPS.CLE_F126_IPV_PROTOCOL_PKG"
ORA-06512: at "APPS.CLE_F1 -1 1090
fnd.plsql.FND_FILE.PUT_LINE 3 26_AP_INVOICES_AU2"
ORA-04088: error during execution of trigger 'APPS.C -1 1090
fnd.plsql.FND_FILE.PUT_LINE 3 LE_F126_AP_INVOICES_AU2'
fnd.plsql.FND_FILE.PUT_LINE 3 <-Import_invoicesfnd.plsql.FND_FILE.PUT_LINE 3 (Import_invoice 17.1) Change the invoice status to REJECTING
fnd.plsql.FND_FILE.PUT_LINE 3 (Change_invoice_status 1) Change invoice status to REJECTING
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms