Sitmain Range Item To Store But Source Method As Wh Not Supplier (Doc ID 2919745.1)

Last updated on JANUARY 09, 2023

Applies to:

Symptoms

While ranging item from sitmain ,the following issue 

ACTUAL BEHAVIOR
---------------
sitmain range item to store but source method as wh not supplier

EXPECTED BEHAVIOR
-----------------------
if default_wh is null then program should check in the below order.
1) Check the supplier if DSD enable the range the item to store with source of method as 'S'.
2) If non dSD supplier then it should pick the virtual Warehouse(VWH) belongs same tsf_entity_id and channel_id.
3) If tsf_entity_id not matching them pick up the vwh belonging to same channel id.
4) in last it should check wf_default_wh.

Steps to recreate : 

Scenario 1: wf_default_wh is NULL in system_options.

1) Create one 2 items( one having DSD supplier , one NON DSD supplier) , Create one item list.
2) create a location list( only 1 store).
3) store default_wh is null.
4) link the item list to location list through schedule item maintainance.
5) Run the sitmain batch.
6) notice the item having DSD supplier will be ranged to store having source of method as supplier.
7) for 2nd item we are getting error.
If source method is supplier then non-dsd supplier cannot be primary. NON_DSD_ITEM_100810002 , item = NON_DSD_ITEM_100810002, loc = 3225, status = A
Error :sitmain_1~20181022215301~update_insert~ ~105~RET-0105: generic stored procedure error~If source method is supplier then non-dsd supplier cannot be primary. 100810002 3225, item = 100810002,

Scenario 2 :wf_default_wh is NOT NULL in system_options.

1) Create one 2 items( one having DSD supplier , one NON DSD supplier) , Create one item list.
2) create a location list( only 1 store).
3) store default_wh is null.
4) link the item list to location list through schedule item maintainance.
5) Run the sitmain batch.
6) notice both item will be ranged to store with source method as "wareshouse" and with the wf_deafult_wh.

Cause

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