Retail Merchandising System (MOSC)

MOSC Banner

PO Create for a same item with a new location fails, when the item is associated with multiple origi

edited Oct 13, 2015 4:54AM in Retail Merchandising System (MOSC) Question

Environment - RMS 14.0.1 , RMS 14.1

Scenario: First create PO's for an Item with multiple origin country and same location. Then create a PO for the item with a different location, PO create fails.

Step 1: Item ITM1 created via XItem with country as 'US'. ITEM_COST_HEAD has record with ORIGIN_COUNTRY_ID ='US', NIC_STATIC_IND = 'N'.

            The value for NIC_STATIC_IND is derived from COUNTRY_ATTRIB table as per value of ITEM_COST_TAX_INCL_IND for country = 'US'.

Step 2: Create PO P1 for item ITM1 with ORIGIN_COUNTRY_ID ='FR' and location WH1. PO P1 is created and ITM1 has a new record in ITEM_COST_HEAD with ORIGIN_COUNTRY_ID='FR', NIC_STATIC_IND='Y'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center