You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Item Conversion

1 reply [Last post]
nitin_hexa's picture
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 07/22/2008
Posts: 14

Hi Lepa,

I have to Convert PS Inventory Master Items from Legacy( Excel files) into peoplesoft 9.1.

Are there any staging tables i can populate so Item Loader process can pick up those and insert items into target component.

I know there are two excel to CI sheets but we can't use that because of Volume & performance constraint.

Please help.

Thanks,
Nitin

Guest's picture
Guest (not verified)
Re: Item Conversion

Staging tables for Item Loader:
PS_MASTER_ITEM_TBL_EC
PS_INV_ITEMS_EC
PS_INV_ITM_UOM_EC
PS_ITEM_MFG_EC
PS_PUR_ITM_ATTR_EC
PS_BU_ITM_INV_EC
PS_ITEM_VENDOR_EC

Additionally PS_EO_EIP_CTL needs to be populated as well.Populate these tables and then run the item loader process.