Supply Chain Management - PSFT (MOSC)

MOSC Banner

Possibility to update the CATEGORY_CD from the PS_ITM_CAT_TBL table to be able to work on global rep

edited May 16, 2015 12:03AM in Supply Chain Management - PSFT (MOSC) 6 commentsAnswered ✓
We currently setup Items in multiple SetID's for different regions (EU vs NA). Currently the Item categorization (Category, Family, and Group) is not the same in both SetID's but in order to be able to do global reporting we are aligning this for inventory Items.

The PS_ITM_CAT_TBL table where we setup the Categories uses a Category ID and Category CD. The Category ID seems to be the field used on the transactions and the Category CD seems to be used for display only. The Category ID is system generated and is unique across all SetID's. The Category CD can be entered manually and can be the same across all SetID's. We use the Category CD in our reporting and would like to have the same codes in both SetID's.

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