Store Inventory Management (MOSC)

MOSC Banner

Vendor's data integrity problem (item loc without a primary supplier)

edited Sep 8, 2014 3:50AM in Store Inventory Management (MOSC) 2 commentsAnswered ✓

Hello all,

I have a data integrity problem in SIM 13.2.4.

There are a supplier and its items in RMS. The vendor has been created in SIM by RIB's VendorCre message.

Now, all StockOrders or ASNs related to the vendor's items stick in staged_message with "Cannot have item loc without a primary supplier!" error.

I check some tables and I have entries in RK_ITEM_SUPP_COUNTRY, RK_STORE_ITEM_SOH and AS_ITM for this supplier and its items.

But there is no entry in the RK_ITEM_SUPPLIER and AS_ITM_RTL_STR.

When I try to populate the data to RK_ITEM_SUPPLIER manually (based on data in RMS) then the ASNs' and StockOrders' messages stick with PK_RK_STORE_ITEM_SOH constriant integrity validation error.

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