R12 - Province Does Not Show Provinces For Canadian Customer Address
(Doc ID 1276245.1)
Last updated on OCTOBER 13, 2022
Applies to:Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.
In R12.1.3, upon entering a Canadian customer address, and entering in a province, the province users want to enter does not show the 2 character abbreviation code for the province (i.e. BC for British Columbia) but instead shows the cities that have been setup in TCA Geography Hierarchy. The page does not show the provinces, but instead shows Canadian cities in the Province field.
The following error appears:
"Value BC for the flexfield segment Province does not exist in the value set HZ_CA_PROVINCE."
Steps to reproduce:
Responsibility: Receivables Manager
Navigation: Customers > Customers
- Query a customer
- Click on Account Details icon
- Click on Create Site then click on Create Address button
- Select counrty 'Canada'
- Enter 'Abercombie' in the Province field.
- The City field populated with 'Logan Lake'
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