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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.