Tax Country Populated On Create Supplier Page Is Not Saved To Tax Profile and Database

(Doc ID 1393684.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Payables - Version: 12.1.3 to 12.1.3 - Release: 12.1 to 12.1
Oracle Supplier Hub - Version: 12.1.3 and later    [Release: 12.1 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:

select *
order by last_update_date desc;

select *
from hz_parties
where party_id = 11111;

see tax country is not populated

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.


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