R12: 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 APRIL 19, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms