Results for “ro_diagnostic_code_id”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CSD_RO_DIAGNOSTIC_CODES is a transactional table in the Oracle EBS Depot Repair (CSD) module. It stores the association between repair orders (more precisely, repair lines) and the diagnostic codes captured during the repair lifecycle. When a technician records a fault finding, symptom category, or root-cause classification against a repair line, that relationship is persisted in this table as a discrete mapping record. The table therefore functions as the authoritative source for diagnostic attribution across the depot repair process, supporting downstream reporting, failure analysis, warranty adjudication, and quality trending.
The ETRM metadata classifies this object heuristically as standalone under the Data Vault model, derived from its foreign-key structure. In Data Vault terms, this can be viewed as a link-style construct that resolves the many-to-many relationship between repair lines and diagnostic codes, with the surrogate key RO_DIAGNOSTIC_CODE_ID providing identity for each association. Modelers may alternatively treat it as a satellite of the repair line hub if diagnostic attribution is considered descriptive context of the repair event.
Key Information Stored
The table contains 26 documented columns. The most operationally significant are:
- RO_DIAGNOSTIC_CODE_ID — Surrogate primary key, enforced by the unique index CSD_RO_DIAGNOSTIC_CODES_PK1 (and mirrored by CSD_RO_DIAGNOSTIC_CODES_U1, the documented business-key candidate).
- REPAIR_LINE_ID — Foreign key to CSD_REPAIRS; identifies the specific repair line to which the diagnostic attribution applies.
- DIAGNOSTIC_CODE_ID — Foreign key to CSD_DIAGNOSTIC_CODES_B; the diagnostic code assigned to the repair line.
- DIAGNOSTIC_ITEM_ID — Additional reference to the diagnostic item context, useful where codes are organized within broader diagnostic item hierarchies.
- OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF/ADF framework during concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit trail columns capturing who created and last modified each mapping and when.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS descriptive flexfield (DFF) column set, available for customer-specific extension of the diagnostic mapping without schema modification.
The separation between the surrogate identifier and the business-key unique index is important in integration scenarios: external systems should generally reference the surrogate key, while the natural relationship is expressed through REPAIR_LINE_ID and DIAGNOSTIC_CODE_ID.
Common Use Cases and Queries
Typical usage centers on retrieving the diagnostic codes attached to a repair, and on aggregating diagnostic frequency for failure analysis.
- List all diagnostic codes for a given repair line:
SELECT d.ro_diagnostic_code_id,
d.diagnostic_code_id,
c.diagnostic_code,
c.description
FROM csd_ro_diagnostic_codes d,
csd_diagnostic_codes_b c
WHERE d.diagnostic_code_id = c.diagnostic_code_id
AND d.repair_line_id = :p_repair_line_id;
- Join through CSD_REPAIRS to report diagnostics by repair order, enabling warranty and root-cause summaries.
- Aggregate code usage counts over a date range using CREATION_DATE to identify the most frequently recorded fault conditions.
- Feed downstream quality dashboards by extracting code and repair-line combinations, joining to inventory and customer data via the repair order.
Because the table is updated transactionally during repair processing, reporting queries should account for the audit columns to support point-in-time reconstruction.
Related Objects
- CSD_REPAIRS — referenced via REPAIR_LINE_ID; provides the repair line context.
- CSD_DIAGNOSTIC_CODES_B — referenced via DIAGNOSTIC_CODE_ID; the base diagnostic code definition table.
- CSD_DIAGNOSTIC_CODES_TL — the translation table supplying language-specific code descriptions (joined through the base table).
- CSD_DIAGNOSTIC_ITEMS / item-related CSD objects — related through DIAGNOSTIC_ITEM_ID where diagnostic item grouping is used.
Access to this table is normally mediated through the Depot Repair OA framework pages and associated PL/SQL APIs rather than direct DML, ensuring that object versioning and audit columns remain consistent.
-
Stores mapping between Repair Orders and Diagnostic codes.
-
Stores mapping between Repair Orders and Diagnostic codes.
-
Displays Diagnostic Codes associated to Repair Orders.
APPS.CSD_RO_DIAGNOSTIC_CODES_V·↳ CSD_DIAGNOSTIC_CODES_B·↳ CSD_DIAGNOSTIC_CODES_TL·↳ CSD_REPAIRS·Explore CSD module →
-
Displays Diagnostic Codes associated to Repair Orders.
APPS.CSD_RO_DIAGNOSTIC_CODES_V·↳ CSD_DIAGNOSTIC_CODES_B·↳ CSD_DIAGNOSTIC_CODES_TL·↳ CSD_REPAIRS·Explore CSD module →
-
eTRM - CSD Tables and Views 12.1.1
Transaction table for the High Volume Repair module.
-
eTRM - CSD Tables and Views 12.2.2
Transaction table for the High Volume Repair module.
-
eTRM - CSD Tables and Views 12.1.1
Transaction table for the High Volume Repair module.
-
eTRM - CSD Tables and Views 12.2.2
Transaction table for the High Volume Repair module.