R12: AP: How to Import VAT Registration Number at Supplier Site Level - VAT_REGISTRATION_NUM column in AP_SUPPLIER_SITES_INT is not displaying in the Tax Registration Number Field
(Doc ID 605302.1)
Last updated on FEBRUARY 04, 2025
Applies to:
Oracle Payables - Version 12.0.1 and laterOracle iSupplier Portal - Version 12.0.1 and later
Information in this document applies to any platform.
Symptoms
- Value populated in VAT_REGISTRATION_NUM column in AP_SUPPLIER_SITES_INT is not displaying in the Tax Registration Number field
- AP_SUPPLIER_SITES_INT and AP_SUPPLIERS_INT, both the tables have VAT_REGISTRATION_NUM column populated.
- After Import, in AP_SUPPLIERS Table VAT_REGISTRATION_NUM is populated and in AP_SUPPLIER_SITES_ALL Table VAT_REGISTRATION_NUM is null.
- How do you import the VAT Registration Number at Supplier Site Level?
- Upon running the Supplier Sites Open Interface program, the VAT registration number is not getting populated at supplier site level.
- Column VAT_registeration_num of AP_Supplier_Sites_All table is coming out to be NULL.
- Within the application the VAT number is getting populated in REP_REGISTRATION_NUMBER column of ZX_PARTY_TAX_PROFILE table.
Steps to Reproduce:
---------------------
AP Supplier Sites -> Tax and Reporting ->Update Transaction tax for the site (Tax Details)
Tax Registration Number Column does not display the value that was loaded into the interface.
Changes
Check if ZX_PARTY_TAX_PROFILE table have REP_REGISTRATION_NUMBER column populated, Use below query:
- SELECT PARTY_TAX_PROFILE_ID
FROM ZX_PARTY_TAX_PROFILE
WHERE PARTY_ID = <Enter Party_id>
AND PARTY_TYPE_CODE = 'THIRD_PARTY_SITE';
- SELECT PARTY_TAX_PROFILE_ID
FROM ZX_PARTY_TAX_PROFILE
WHERE PARTY_ID = <Enter Party_id>
AND PARTY_TYPE_CODE = 'THIRD_PARTY';
If data is not imported into ZX_PARTY_TAX_PROFILE please see Doc ID 726562.1
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 |
References |