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 |