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 Service Order, or a Service Order group using these update programs.
The Depot Repair Receipt Update program is used to update Service Orders and create service order history records when returns are received.
Return Material Authorizations (RMA) to receive service items are created using the Logistics tab of the Service 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 service order line is received, the program updates the total quantity received for the service order line, and creates a service order 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 Service 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 Service Order information in the CSD_REPAIRS and CSD_REPAIR_JOB_XREF tables, and to create service order history records when WIP Jobs related to Oracle Depot Repair are created or completed.
WIP Jobs for service order lines are created using the Submit Jobs window and the Submit Jobs for Service Orders window. A given service order line can be represented by multiple Jobs in WIP, or multiple service order lines can be grouped as a single Job.
For new WIP Jobs created, the Depot Repair Job (WIP) Update program updates the service order line in the CSD_REPAIRS table with the quantity processed, updates the service order line, job combination record in the CSD_REPAIR_JOB_XREF table with the wip_entity_id of the new job and creates a Job history record for each updated service order 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 Service 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 Jobs window or in the Submit Jobs for Service Orders window, after the program WIP Mass Load completes successfully.
When you click the Update Job button in the Jobs tab.
The program logic is as follows:
Click the Submit Jobs button in either the Submit Jobs window or in the Submit Jobs for Service Orders window.
Complete the WIP Job by clicking the Complete Job button in the Jobs tab in the Service Orders window.
Click the Update Job button on the 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 Service 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 service order 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 Service Orders and create service order history records when serviced goods are shipped and a related sales order is generated.
Sales orders for service order line shipments are created using the Logistics tab of the Service Orders window. The sales orders are submitted to Oracle Order Management for processing, and are shipped by the Shipping module. The associated service order 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 service order 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 Service 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 Technician Portal. 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.
Depot Repair XMLP Estimate Report program generates a report that a service business presents to customers to provide a list of estimated charges for performing a service. This includes the item serviced, diagnostic codes, service codes and estimated material, labor and expense charges.
The Depot Repair Purge Message Stack program handles error/warning/informational messages for Actuals, Estimates, and Serial Number capture. These messages are saved in the database and then displayed. When the issue goes away, the message is deleted by the system. However, in case the system fails to delete a message or if you want to manually clear out the message stack, you can do it by running this concurrent program.