Supplier Locations are not Imported into the Regions And Zones Form after Running Import Shipping Locations Program (Doc ID 1415964.1)

Last updated on MAY 23, 2023

Applies to:

Symptoms

ISSUE

A supplier, zone and 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 a customer location rather than a supplier
type location even after running the Import Shipping Locations program.  Since the newly created supplier is not displayed in the relevant zone,
the transit time defined for that supplier is not being honored and the ship method is not showing up in the Bill of Distribution in the Planning Destination instance.


STEPS

1. Payables > Suppliers form
Supplier name = <supplier name>
Supplier number = <supplier number>

2. Payable > Supplier Sites
Site name = <site>
Site Location = <site address>
Site uses: Pay and Purchasing

Second supplier
Name = <second supplier name>
Site Name = <second supplier number>
Site Use: Purchasing only

3. Shipping > Setup > Regions and Zones form
Creates a Region for:
<supplier one zip code> to <supplier two zip code>

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.
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 changes in Trading Community Architecture(TCA) product with Release 12. 
The supplier data model changes now sync the data in the hz_locations and po_vendor_sites_all table.

Cause

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