This appendix presents the Oracle Depot Repair update programs.
This appendix covers the following topics:
The following update programs are available for Oracle Depot Repair users:
You can process one Repair Order, or a Repair Order group using these update programs.
The Depot Repair Receipt Update program is used to update Repair Orders and create repair history records when returns are received.
Return Material Authorizations (RMA) to receive repair items are created using the Logistics tab of the Repair Orders window, or through internal requisitions and internal sales orders. RMAs are pushed into Order Management for standard processing, and subsequently into Inventory/Receiving for inspection and receiving. When an RMA related to a repair line is received, the program updates the total quantity received for the repair line, and creates a repair history record.
The Depot Repair Receipt Update program is run when you click the Update Logistics button in the Logistics tab for an RMA (Return) line.
Alternatively, you can run this program by either starting from the Navigator, then following the path Depot Repair > Others > Run Requests > Single Request, or, from the top menu in the Repair Orders window, selecting the options View > Requests > Submit a New Request.
The program logic is as follows:
Check if the receiving transaction process is complete for the RMA received. If not, wait until the process is complete.
If the process is complete, start the Depot Repair Receipt Update program, as described previously in this Program Logic section. This will check the receiving record and update the Oracle Depot Repair tables.
The Depot Repair Receipt Update program picks only the receiving lines that are actually delivered to a subinventory; for example, when inspection is stated as mandatory for items before being received, only the items that passed inspection and were not returned.
The Depot Repair Receipt Update program is dependent on the following application modules:
Oracle Depot Repair, Release 11i
Oracle Purchasing, Release 11i
Oracle Order Management, Release 11i
Oracle Inventory, Release 11i
The Depot Repair Job (WIP) Update program is used to update Repair Order information in the CSD_REPAIRS and CSD_REPAIR_JOB_XREF tables, and to create repair history records when WIP Repair Jobs related to Oracle Depot Repair are created or completed.
WIP Repair Jobs for repair lines are created using the Submit Repair Jobs window and the Submit Repair Jobs for Repair Orders window. A given repair line can be represented by multiple Repair Jobs in WIP, or multiple repair lines can be grouped as a single Repair Job.
For new WIP Repair Jobs created, the Depot Repair Job (WIP) Update program updates the repair line in the CSD_REPAIRS table with the quantity processed, updates the repair line, job combination record in the CSD_REPAIR_JOB_XREF table with the wip_entity_id of the new job and creates a Repair Job history record for each updated repair line, job combination record.
For WIP Jobs completed, the Depot Repair Job (WIP) Update program updates the quantity completed in the CSD_REPAIR_JOB_XREF table. If the completed job is associated with multiple Repair Orders, the update program allocates the quantity completed, if needed.
The Depot Repair Job (WIP) Update program is run in the following cases:
When you click the Submit Jobs button in either the Submit Repair Jobs window or in the Submit Repair Jobs for Repair Orders window, after the program WIP Mass Load completes successfully.
When you click the Update Job button in the Repair Jobs tab.
The program logic is as follows:
Click the Submit Jobs button in either the Submit Repair Jobs window or in the Submit Repair Jobs for Repair Orders window.
Complete the WIP Repair Job by clicking the Complete Job button in the Repair Jobs tab in the Repair Orders window.
Click the Update Job button on the Repair Jobs tab.
Alternatively, you can run this program by either starting from the Navigator, then following the path Depot Repair > Others > Run Requests > Single Request, or, from the top menu in the Repair Orders window, selecting the options View > Requests > Submit a New Request. When submitting the request, you can specify using a parameter whether to run for a specific repair number and whether to update Job Completion information.
The Depot Repair Job (WIP) Update program is dependent on the following application modules:
Oracle Depot Repair, Release 11i
Oracle WIP, Release 11i
The Depot Repair Shipment Update program is used to update Repair Orders and create repair history records when repaired goods are shipped and a related sales order is generated.
Sales orders for repair line shipments are created using the Logistics tab of the Repair Orders window. The sales orders are submitted to Oracle Order Management for processing, and are shipped by the Shipping module. The associated repair lines in Oracle Depot Repair need to be updated with the shipped quantity. A history record must be created to record the shipped quantity and shipped date against the repair line.
The Depot Repair Shipment Update program is run when you click the Update Logistics button in the Logistics tab for a Sales order (Ship) line.
Alternatively, you can run this program by either starting from the Navigator, then following the path Depot Repair > Others > Run Requests > Single Request, or, from the top menu in the Repair Orders window, selecting the options View > Requests > Submit a New Request.
The program logic is as follows:
Ensure that the Interface Trip Stop concurrent program completes successfully.
When the Interface Trip Stop concurrent program has successfully completed, start the Depot Repair Shipment Update program, as described previously in this Program Logic section. This program finds the shipment record, and updates the Oracle Depot Repair tables with the data.
The Depot Repair Shipment Update program is dependent on the following application modules:
Oracle Depot Repair, Release 11i
Oracle Order Management, Release 11i
Oracle Shipping Execution, Release 11i
Depot Repair Business Intelligence Update Program computes a number of business intelligence features in the Repair Technician Module. This program updates the frequency of occurrence for diagnostic codes and service codes. It also calculates the materials and frequencies displayed in the Most Common Materials bin and calculates the resources and frequencies displayed in the Most Common Resources bin.