OKS Invoices rejected during Autoinvoice Import Program with error "Transaction Extension Does Not E
Hi...We are upgrading from 11.5.10.2 to 12.2.03. When we run autoinvoice import for some specific OKS Contracts, the invoices have exceptions with message "Transaction extension does not exist". Based on my research, it appears that the following columns of the AutoInvoice interface table RA_INTERFACE_LINES_ALL have become obsolete in R12:
CUSTOMER_BANK_ACCOUNT_ID
CUSTOMER_BANK_ACCOUNT_NAME
PAYMENT_SERVER_ORDER_NUM
APPROVAL_CODE
Instead of these fields, Autoinvoice requires you to populate the PAYMENT_TRXN_EXTENSION_ID. You can obtain this by calling the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension before populating the Autoinvoice tables.
In reviewing the data in our 11i instance, I could only see values for some records in the field CUSTOMER_BANK_ACCOUNT_ID and not the other 3 mentioned above.
CUSTOMER_BANK_ACCOUNT_ID
CUSTOMER_BANK_ACCOUNT_NAME
PAYMENT_SERVER_ORDER_NUM
APPROVAL_CODE
Instead of these fields, Autoinvoice requires you to populate the PAYMENT_TRXN_EXTENSION_ID. You can obtain this by calling the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension before populating the Autoinvoice tables.
In reviewing the data in our 11i instance, I could only see values for some records in the field CUSTOMER_BANK_ACCOUNT_ID and not the other 3 mentioned above.
0