IM_AP_STAGE_DETAIL ORG Unit Pick Observed From Primary_vwh Instead Of Order Location Or Supplier.

(Doc ID 2301900.1)

Last updated on SEPTEMBER 04, 2017

Applies to:

Oracle Retail Invoice Matching - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

In IM_AP_STAGE_DETAIL table the ORG_UNIT  is picked from the Primary virtual warehouse instead of order location or supplier.

Steps To Recreate:

1. Create an item with virtual warehouse '99991 '

  Physical warehouse = 9999, Primary Virtual warehouse ='99992'
  Virtual warehouse 99991= org_unit 18
  Virtual warehouse 99992= org_unit 69

2. Create and receive an order for the above item with location as '9991'.

3. Create and match the invoice with location =9999

4. Run the posting batch.

Check IM_AP_STAGE_HEAD.ORG_UNIT and IM_AP_STAGE_DETAIL.ORG_UNIT as '69'. It should be '18'.

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