My Oracle Support Banner

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.

Goal

Components issued to Work Orders are not getting collected when Collecting Service Parts Usage History - Depot Repair

STEPS
--------
 Navigation:
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?
 

Solution

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
Goal
Solution


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