Collecting Service Parts Usage History - Depot Repair - Components Issued To Work Orders Are Not Getting Collected
(Doc ID 2497427.1)
Last updated on JANUARY 22, 2019
Applies to:Oracle Service Parts Planning - Version 12.2 and later
Information in this document applies to any platform.
Components issued to Work Orders are not getting collected when Collecting Service Parts Usage History - Depot Repair
1) To create a work order and issue components go to Depot Repair Engineer > Depot Repair > Repair Orders - create a new order for an item that has components and issue out the components for that order.
2) To run the parts collection go to Service Supply Chain Planner Responsibility > Collections > Oracle Systems > Collect Service Parts Usage History - Depot Repair
SQL check for collected data
select * from MSD_DEM_DPT_REP_USG_HISTORY;
LEVEL1 - Item name
LEVEL1_SR_PK - sr_inventory_item_id
LEVEL2 - Org Code
lEVEL2_SR_PK - Org_id
SDATE - Date
EBS_USG_QTY - Quantity
How can we check to see which records should be collected?
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