My Oracle Support Banner

Tax Country Populated On Create Supplier Page Is Not Saved To Tax Profile and Database (Doc ID 1393684.1)

Last updated on JULY 15, 2020

Applies to:

Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Supplier Hub - Version 12.1.3 and later
Information in this document applies to any platform.


When creating a new supplier with tax information notice that field Tax Country is not saved in the Database in table ZX_PARTY_TAX_PROFILE, and tax country is not shown in the Tax Details screen when querying this new supplier

Users expect tax country being populated and displayed in Tax Details screen of supplier

Steps  To Reproduce

1. Log in and select Responsibility: Supplier Data Librarian
2. Navigate to Suppliers > Profile Management Button: Create Supplier
3. Enter a new Supplier with Tax Country, Tax Registration Number and Taxpayer Id.
4. Run following SQL:

5. On the Tax Details screen users can observe that the Tax Registration is populated in the field Default Reporting Registration Number but the Default Reporting Country Name is not populated.


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

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