The 'Issue History' SQR Report (INS7150) Should Select Issued Items for the Transaction Group 231 (WM Usage)

(Doc ID 1902054.1)

Last updated on AUGUST 04, 2016

Applies to:

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


The 'Issue History' SQR report (INS7150) (navigation: Inventory, Manage Inventory, Reports, Issues History) is only selecting issued Items for the Transaction Group 030 (Usage & Shipments). It should process transactions for the Transaction Group 231 too (WM Usage).

This report displays monthly issue information on stock items for each Business Unit and Item. Based on the PeopleBook extracts below, transactions for the Transaction Group 231 are created as a result of item consumption for repair and maintenance. Since these transactions are true issues, they should be processed by the INS7150 report.

PeopleSoft Enterprise Cost Management 9.1 PeopleBook > Costing Transactions and Creating Accounting Entries > Costing and Accounting for the Repair and Maintenance of Assets

PeopleSoft Maintenance Management is a product within the asset life cycle management suite in PeopleSoft Enterprise Financials. This product manages the maintenance and repair of an asset. The maintenance and repair of an asset may require parts from inventory. Work orders, created in PeopleSoft Maintenance Management, place demand for parts or items in PeopleSoft Inventory, where demand fulfillment picks, issues, and depletes the part. The technician maintaining the asset may pick up the material or the material might be delivered directly to the job site. Once work is completed, the technician returns any unused material back to PeopleSoft Inventory.


PeopleSoft Enterprise Inventory 9.1 PeopleBook > Fulfilling Work Orders from Maintenance Management > Understanding Work Order Item Fulfillment from PeopleSoft Inventory

When work order parts are committed to PeopleSoft Inventory, they are inserted as demand lines into the IN_DEMAND table with a demand source of WM and a fulfillment state (IN_FULFILL_STATE) of pending. Work order demand lines do not follow the same fulfillment process as demand lines from sales orders or material stock requests. Instead, work order demand lines stay in the pending state during reservations, allocations, and picking. When the work order task is set to a status of completed, then the work order demand line in PeopleSoft Inventory is set to the depleted state.





Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms