My Oracle Support Banner

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 later
Oracle iSupplier Portal - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

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


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