Retail Merchandising System (MOSC)

MOSC Banner

inv_status_codes table - relation of inv_status_code to inv_status

edited Aug 24, 2015 1:24PM in Retail Merchandising System (MOSC) Question

(RMS13.2.8)

Can there be more than one inv_status_code for each inv_status in inv_status_codes table? I believe there can be, but I want to confirm it as we are seeing issue of unavailable inventorygetting multiple by the number of inv_status_codes for each inv_status when validated in the inventory adjustment form. Sample data below -

INV_STATUS_CODEINV_STATUS_CODE_DESCINV_STATUS
'0184'XYZ6
'0196'ABC6
'0211CCC6

If an item location has say 20 qty in inv_status 6 int he inv_status_qty table then the value for above combination is calculated as 60 (multiplied three times) when validating in invadjst form.

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