My Oracle Support Banner

Customer Form, Profile Issue: Cannot Update Tax Registration Num In Customer Profile Form, Causes Unsynchronized Data in TCA and Ebtax (Doc ID 796619.1)

Last updated on JUNE 02, 2021

Applies to:

Oracle Receivables - Version 12.0.5 and later
Information in this document applies to any platform.


There have been multiple changes that deal with the Tax Registration Num field in the Profile tab in the Customer Form.  Code changes introduced in Bug 7242429 removed the value of this field from the Profile tab. You could see the field prompt but there was no value displayed. To update this field you needed to navigate to the Tax Profile tab.

Further, in the course of hiding this field from updates, the tables that stored Tax Registration Numbe in Trading Community Architecture (TCA) and E-business tax (ZX) tables have become unsynchronized.

Symptoms encountered display the following:

  1. For existing customers:
    As the old customer has data on HZ_ORGANIZATION_PROFILES and ZX_PARTY_TAX_PROFILE, everytime a change will be done on Tax Profile tab, that will not be reflected on HZ_ORGANIZATION_PROFILES and this will cause confusion to the users.
  2. For new customers:
    As the users are not able to enter information on the "Tax Registration Num"  (Profile Tab), if a new value is inserted on the field "Default Reporting Registration Number" (Tax profile), that value will not be reflected on the HZ_ORGANIZATION_PROFILES.

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation: Customers > Customers

  1. Create a new customer
  2. Navigate to Tax Profile tab
  3. Populate the field: Default Reporting Registration Number with 'DEMO'
  4. In backend, use Customer Account Number to review data:

    Notice that TAX_REFERENCE does not have DEMO value.




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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