My Oracle Support Banner

Customer Form Issue: Language Field On Customers Page Does Not Populate HZ_PARTY_SITES.LANGUAGE (Doc ID 862651.1)

Last updated on OCTOBER 13, 2022

Applies to:

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


After populating the 'Language' field in the Site Details tab of the R12 Customers page when creating or updating a new customer, this value is getting populated in HZ_LOCATIONS.LANGUAGE but it is not being populated in HZ_PARTY_SITES.LANGUAGE.

In 11i, this value is populating in both HZ_LOCATIONS.LANGUAGE and HZ_PARTY_SITES.LANGUAGE.

Steps To Reproduce:

1) Personalize the Account Site Address page to make the field 'Language' visible.

2) Add language to a customer

Responsibility: Receivables Manager
Navigation: Customers > Customers
-Query for customer
-Click on Address Details button.
-Under Account Site Address, enter a language (selected from LOV).

3) Run the following script:




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.