DATAFIX: Duplicate Country And Country Codes Exist in Regions and Zones Form
(Doc ID 1366451.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Shipping Execution - Version 12.1.3 and later
Information in this document applies to any platform.
Form:WSHRGZON.FMB - Regions and Zones Form
Duplicate country codes and regions exist in the WSH_REGIONS_TL table. When a different region was defined and Import Shipping Locations was ran, the country codes were updated resulting in another record for the same country with a different country code.
For example, in the Regions and Zones form on the Regions Tab it shows two records for Lithuania.
1st record: Lithuania with country code = LX
2nd record: Lithuania with country code = LT
Expect that there would only be one record with one country code per each country defined.
The issue can be reproduced at will with the following steps:
1) Order Management Super User Responsibility
4) Define Regions and Zones
5) Regions and Zones
6) Regions Tab
7) Enter Record and Save
10) Import Shipping Locations
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