Supplier Locations are not Imported into the Regions And Zones Form after Running the Import Shipping Locations Program

(Doc ID 1415964.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Shipping Execution - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Form:WSHRGZON.FMB - Regions and Zones Form
Executable:WSHMLOCR - Import Shipping Locations


Symptoms

A supplier, zone and a transit time is newly created between the zone and an organization.   The zone should encompass the supplier created.  The Import Shipping Locations program is then run to import the new supplier and supplier location into the corresponding region and zone.

When viewing the Zones < Locations form,  the newly defined supplier is displaying as a customer and customer location rather than a supplier type location even  after running the Import Shipping Locations concurrent program.

Since the newly created supplier is not displayed in the relevant zone, the transit time defined is not being honored and the ship method is not showing up in the Bill of Distribution in the Planning Destination instance.

STEPS

1. Suppliers form
Supplier name = A S PINDEL CORP
Supplier number = 13480

2. Supplier Sites
Site name = New Berlin
Site Location = New Berlin, Wisconsin, 53151
Site uses: Pay and Purchasing

Second supplier
Name = TIMBER RESOURCE LLC
Site Name = Milwaukee, Location is Milwaukee WI, zip code = 53225
Site Use: Purchasing only

3. Shipping < Setup < Regions and Zones form
Creates a Region for: United States, Wisconsin, Milwaukee, zip code from 53225 to 53225

4. Shipping < Interfaces< Run Import Shipping Locations:
Map Regions : Yes
Location Type : Both (Process both Internal and External Locations)
Number of Instances : NULL
Insert Flag : Yes
Number of regions to process : as required

5. Shipping < Interfaces < Run Region Interface (WSHRGINT)

6. Assign the Zone/Location and Ship Method
And make the Ship method as default

7. Shipping < Setup < Regions and Zones Form
There are no regions < zones < locations displayed with type Supplier


Changes

There were some Trading Community Architecture(TCA) changes with the delivery of Release 12.  The supplier data model changes now sync the data in the hz_locations and po_vendor_sites_all table.

Cause

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