My Oracle Support Banner

How To Mass Update the Onhand Quantity of Newly Created Items (Doc ID 1932857.1)

Last updated on OCTOBER 24, 2022

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 8 SP1 to 9.1 [Release 8 to 9]
Information in this document applies to any platform.


Say that you have created many new Inventory Items by using one of these methods:

* manually by using the 'Define Item' page (navigation: Items, Define Items and Attributes, Define Item) and the 'Define Business Unit Item' page (navigation: Items, Define Items and Attributes, Define Business Unit Item),
* by copy of existing Items (navigation: Items, Define Items and Attributes, Copy Item),
* by using Item Templates (navigation: Items, Configurable Item Templates, Item Add),
* by using the ExcelToCI utility and the IN_MST_ITM_XLS Component Interface as well as the 'Item Loader' process (IN_ITMLOAD) (navigation: SCM Integrations, Process Transactions, Items, Item Loader).

How do you mass update the onhand quantity of these new Items?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1) Inventory Adjustment EIP
 2) Manual Count
 3) INSERT SQL's and Putaway flow

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.