Release 12.1
Part Number E13605-04
Contents
Previous
Next
| Oracle Depot Repair Implementation Guide Release 12.1 Part Number E13605-04 | Contents | Previous | Next |
This appendix presents the seeded Oracle Depot Repair lookup codes and values.
This appendix covers the following topics:
The following lookup values are seeded for the Repair Type Refs in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| AE | Advanced Exchange | No |
| AL | Loaner | No |
| ARR | Loaner, Repair and Return | No |
| E | Exchange | No |
| R | Replacement | No |
| RF | Refurbishment | No |
| RR | Repair and Return | No |
| SR | Standard Repair | No |
Repair Type Reasons are values seeded for the different reasons that affect the return of an item for repair.
| Code | Description | Editable? |
|---|---|---|
| APPRV | Customer approves the RMA | No |
| EST | Estimate approved | No |
| HOLD | Repair on hold | No |
| REJECT_1 | Product unrepairable | No |
| REJECT_2 | Declined repair | No |
| REV_EST | Revised estimate approved | No |
| WAIT_1 | Customer contacted | No |
| WAIT_2 | Awaiting approval | No |
The following seeded lookup values are used to define the repair mode used to process a repair using Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| ALL | Display all the values for repair modes | No |
| NONE | None of the modes are applicable | No |
| TASK | JTF Tasks | No |
| WIP | Discrete Jobs in Work in Process module | No |
Repair Approval Status lookup values are defined (seeded) to represent the acceptance or rejection of an item's repair.
| Code | Meaning | Editable? |
|---|---|---|
| A | Approved | No |
| P | Pending | No |
| R | Rejected | No |
The Repair Status lookup values define whether a Repair Order is open, closed, or on hold. The following values are seeded.
| Code | Meaning | Editable? |
|---|---|---|
| C | Closed | No |
| D | Draft (used in Mass RO) | No |
| H | Hold | No |
| O | Open | No |
Repair Event lookups are defined to represent particular events that take place in a depot during repair processing. The following values are seeded.
| Code | Meaning | Editable? |
|---|---|---|
| A | Customer Approved | No |
| CM | Charges Manually Updated for Repair Order | No |
| CONU | Default Contract Updated | No |
| CR | Charges Recorded | No |
| DIA | Diagnosed | No |
| DROC | Depot Repair Owner Changed | No |
| ESU | Estimate Status Updated | No |
| IP | Inspection Performed | No |
| JC | Job Completed | No |
| JCA | Job Completed Alert | No |
| JCN | Job Canceled | No |
| JS | Job Created | No |
| JSA | Job Submitted | No |
| JSU | Job Submitted Alert | No |
| OA | Repair Order Alert | No |
| PDC | Promise Date Changed | No |
| PS | Shipment | No |
| PSI | Sales Order Completed | No |
| R | Customer Rejected | No |
| RC | Repair Order Opened | No |
| RE | RMA Created | No |
| RO | Replace Order Created | No |
| RR | RMA Received | No |
| RRI | Requisition Received | No |
| RSC | Receipt Serial Number is different | No |
| RSCI | Sales Order Alert | No |
| SC | Status Changed | No |
| SLT | Repair Order Split | No |
| SOC | Sales Order Created | No |
| SRU | Service Request Status Updated | No |
| SSC | Shipped Serial Number is different | No |
| TAC | Task Assignee Changed | No |
| TBR | Ready to be Returned | No |
| TC | Task Created | No |
| TOC | Task Updated | No |
| TSC | Task Status Change | No |
Estimate Billing Type lookup values are defined to represent the type of transaction being billed. Following are the seeded values.
| Code | Description | Editable? |
|---|---|---|
| E | Expense | No |
| L | Labor | No |
| M | Material | No |
Estimate statuses are values defined for the different states of an estimate. Following are the seeded Estimate Status values.
| Code | Description | Editable? |
|---|---|---|
| ACCEPTED | Estimate approved by customer | No |
| BID | Estimate awaiting customer approval | No |
| CANCELLED | Estimate is cancelled | No |
| DRAFT | Estimate with information but not ready to reveal to customer | No |
| NEW | Estimate with no information entered | No |
| REJECTED | Estimate not approved by customer | No |
The following lookup values are seeded to specify the reason for an estimate rejection.
| Code | Description | Editable? |
|---|---|---|
| CUST_REJECT | Customer Rejects Estimate | No |
| MAC_SHORTAGE | Machine Not Available in Depot | No |
| MAT_SHORTAGE | Material Shortage in Depot | No |
| NOT_PROFITABLE | Unprofitable for depot to repair the item | No |
| NOT_REPAIRABLE | Product Beyond Repair in Depot | No |
| RES_SHORTAGE | Resource Shortage in Depot | No |
The following are the Product Transaction Action codes seeded for Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| CUST_PROD | Customer Item | No |
| DEFECTIVES | Defective Item | No |
| EXCHANGE | Item Exchange | No |
| LOANER | Loaned Item | No |
| REPLACEMENT | Replacement Item | No |
| USABLES | Usable Item | No |
The following Product Transaction Action Type lookup values are seeded in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| MOVE_IN | Move in defective products | No |
| MOVE_OUT | Move out usable products | No |
| RMA | Inbound transaction for returned product | No |
| SHIP | Outbound transaction for Repaired Product, Loaner etc. | No |
Product Transaction Statuses are lookup values defined for representing the state of product transactions. The following values are seeded.
| Code | Description | Editable? |
|---|---|---|
| BOOKED | Sales Order Booked | No |
| ENTERED | Created Product Txn | No |
| RECEIVED | Received against RMA | No |
| RELEASED | Sales Order Pick Released | No |
| SHIPPED | Sales Order Shipped | No |
| SUBMITTED | Charge Line Interfaced | No |
Repair Order Statuses are lookup values that define the different stages in Repair Order processing. The following Repair Order Transaction Status values are seeded in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| CHARGE_ENTERED | Charge Entered | No |
| ESTIMATE_APPROVED | Estimate Approved | No |
| ESTIMATE_REJECTED | Estimate Rejected | No |
| NEW | New | No |
| OM_BOOKED | OM Booked | No |
| OM_RECEIVED | OM Received | No |
| OM_RELEASED | OM Released | No |
| OM_SHIPPED | OM Shipped | No |
| OM_SUBMITTED | OM Submitted | No |
| WIP_COMPLETED | WIP Job Complete | No |
| WIP_SUBMITTED | WIP Job Submitted | No |
The following are the seeded values for Unit of Measure for the estimated repair lead time.
| Code | Description | Editable? |
|---|---|---|
| DAY | Day | No |
| HR | Hour | No |
| MONTH | Month | No |
| WEEK | Week | No |
| YEAR | Year | No |
The following lookup values are seeded for Repair Job Statuses in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| RELEASED | Released | No |
| UNRELEASED | UnReleased | No |
The following lookup values are seeded for Recall Flow Statuses in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| CLOSED | CLOSED | Yes |
| DRAFT | DRAFT | Yes |
| OPEN | OPEN | Yes |
The following lookup values are seeded for Material Dispositions in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| HAZMAT | Hazardous Materials | No |
| RECOVER | Recover | No |
| RECYCLE | Recycle | No |
| REUSE | Re-use | No |
| SCRAP | Scrap | No |
The following lookup values are seeded for Return Streams in Oracle Depot Repair.
| Code | Description | Editable? |
|---|---|---|
| CUST_CREDIT | Customer Return For Credit | Yes |
| TRADEIN | Trade In | Yes |
| TAKEBACK | Takeback | Yes |
| INT_CREDIT | Internal User Return For Credit | Yes |
| TOOMUCH | Excess and Obsolete | Yes |
| RET_ASSETS | Retired Assests | Yes |
| RET_SPARES | Retired Spares | Yes |
| EWASTE | e-Waste | Yes |
Copyright © 2002, 2010, Oracle and/or its affiliates. All rights reserved.