My Oracle Support Banner

In IM_AP_STAGE_DETAIL Table Org_Unit Column Picks Value From Primary_VWH Instead of Order Location or Supplier Org_Unit (Doc ID 2301900.1)

Last updated on APRIL 16, 2020

Applies to:

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


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'.


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

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