R12: AP: Custom Code Not Executing Properly Due Reference To Base Table Columns After Structural Changes (Table AP_SUPPLIERS, Column VAT_REGISTRATION_NUM Vs. VAT_REGISTRATION_NUM#1)
(Doc ID 2865703.1)
Last updated on NOVEMBER 21, 2024
Applies to:
Oracle Payables - Version 12.2.10 and laterOracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.
Goal
Custom Code Not Executing Properly Due Table AP_SUPPLIERS Column Name Change From VAT_REGISTRATION_NUM to VAT_REGISTRATION_NUM#1
Why is the customized DB Packages referencing column VAT_REGISTRATION_NUM of table AP_SUPPLIERS, is not working properly?
Why is Customization stop working after the column VAT_REGISTRATION_NUM of table AP.AP_SUPPLIER, name changed from VAT_REGISTRATION_NUM to VAT_REGISTRATION_NUM#1, and vice versa.
NOTE: Even though this document uses column VAT_REGISTRATION_NUM of table AP_SUPPLIERS to explain the issue, the same scenario has been reported for the following table - columns
Table Name | Column Name |
AP_INVOICES_ALL | PAY_GROUP_LOOKUP_CODE |
AP_INVOICE_LINES_ALL | MERCHANT_NAME |
AP_INVOICE_DISTRIBUTIONS_ALL | MERCHANT_NAME |
AP_SUPPLIERS | VAT_REGISTRATION_NUM |
AP_SUPPLIER_SITES_ALL | VAT_REGISTRATION_NUM |
PAY_GROUP_LOOKUP_CODE | |
IBY_PAY_INSTRUCTIONS_ALL | PAYMENT_CURRENCY_CODE |
IBY_PAYMENTS_ALL | DECLARATION_CURRENCY_CODE |
IBY_DOCS_PAYABLE_ALL | DOCUMENT_CURRENCY_CODE |
PO_LINE_LOCATIONS_ALL | OUTSOURCED_ASSEMBLY |
CANCEL_REASON | |
CE_CASHFLOWS | BANK_ACCOUNT_TEXT |
CE_STATEMENT_LINES | BANK_ACCOUNT_TEXT |
Solution
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
Goal |
Solution |
References |