Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

category is not displaying in purchase order line screen against expense items

edited May 18, 2018 11:07AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

Hi,

I try to enter expense item in purchase order line screen.no category  coming against items.recently i updated expense account of item master  interface programme. Before updating item master ,item category is coming in purchase order screen.if i update manually in item master.it appearing categoy in purchase order screen.Please kindly advice me.

i use below script for upload item master.

INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE (PROCESS_FLAG,ORGANIZATION_CODE,

                                                    INVENTORY_ITEM_ID,EXPENSE_ACCOUNT,ENCUMBRANCE_ACCOUNT,COST_OF_SALES_ACCOUNT,SALES_ACCOUNT

                                                   

                                                     TRANSACTION_TYPE

                                                    , SET_PROCESS_ID)

                                              VALUES (

                                              1,rec.ORGANIZATION_CODE,rec.INVENTORY_ITEM_ID,rec.EXPENSE_ACCOUNT,REC.ENCUMBRANCE_ACCOUNT,

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