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