Results for “actual_source_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSD_REPAIR_ACTUAL_LINES is a transactional table in the CSD (Depot Repair) schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the individual repair actuals lines that record the resources, costs, and materials consumed or applied against a depot repair order. Each row represents a single line of actual activity — a labor resource, an item cost, a warranty-related charge, or a service part — accumulated during the execution of a repair. The parent header-level record is held in CSD_REPAIR_ACTUALS, to which every line is linked through REPAIR_ACTUAL_ID, forming a classic header-detail dependency that anchors the table within the Depot Repair costing and billing flow.

From a Data Vault modeling perspective, the metadata classifies CSD_REPAIR_ACTUAL_LINES heuristically as a link table. This reflects its role as an associative entity binding repair orders, estimate details, and inventory locators together, rather than serving as a standalone business hub. It carries descriptive measures (item cost) and audit columns, so a satellite treatment may be layered on top of the link in a dimensional warehouse design.

Key Information Stored

The surrogate primary key is REPAIR_ACTUAL_LINE_ID, enforced by CSD_REPAIR_ACTUAL_LINES_PK and reinforced by unique index CSD_REPAIR_ACTUAL_LINES_U1. A second unique index, CSD_REPAIR_ACTUAL_LINES_U2, is defined on ESTIMATE_DETAIL_ID, marking it as the principal documented business-key candidate.

• REPAIR_ACTUAL_ID — foreign key to CSD_REPAIR_ACTUALS; the actuals header this line belongs to.
• ESTIMATE_DETAIL_ID — foreign key to CS_ESTIMATE_DETAILS; ties the actual to the originating estimate detail (business-key candidate).
• REPAIR_LINE_ID — foreign key to CSD_REPAIRS; links the actual to the specific repair order line.
• ITEM_COST — the monetary cost recorded for the consumed resource or item on this line.
• RESOURCE_ID — identifier of the resource (labor, material, equipment) applied.
• ACTUAL_SOURCE_CODE / ACTUAL_SOURCE_ID — indicate the origin of the actual, supporting traceability.
• OVERRIDE_CHARGE_FLAG — indicates whether the default charge was overridden.
• WARRANTY_CLAIM_FLAG, WARRANTY_NUMBER, WARRANTY_STATUS_CODE — warranty adjudication details for the line.
• REPLACED_ITEM_ID — the inventory item substituted, where applicable.
• LOCATOR_ID and LOC_SEGMENT1 through LOC_SEGMENT20 — the inventory locator and its flexfield segments.
• LOT_NUMBER — lot/serial context for the part consumed.
• JUSTIFICATION_NOTES — free-text rationale for the actual.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for multi-org access control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER — standard audit and optimistic locking columns.

Common Use Cases and Queries

The table is central to repair costing, warranty recovery analysis, and reconciliation between estimated and actual consumption. A frequent reporting pattern joins lines to their header and repair order:

• Actual cost rollup per repair order: SUM(ITEM_COST) grouped by REPAIR_ACTUAL_ID joined to CSD_REPAIR_ACTUALS.
• Estimate-to-actual variance: compare ITEM_COST against CS_ESTIMATE_DETAILS via ESTIMATE_DETAIL_ID.
• Warranty claim extraction: filter WHERE WARRANTY_CLAIM_FLAG = 'Y' and group by WARRANTY_STATUS_CODE.
• Resource consumption reporting: aggregate by RESOURCE_ID across a date range using CREATION_DATE.
• Material traceability: resolve LOCATOR_ID and LOT_NUMBER to inventory for part-level audits.

Related Objects

• CSD_REPAIR_ACTUALS — parent header, joined on REPAIR_ACTUAL_ID.
• CS_ESTIMATE_DETAILS — estimate detail, joined on ESTIMATE_DETAIL_ID.
• CSD_REPAIRS — repair order/line, joined on REPAIR_LINE_ID.
• FND_SECURITY_GROUPS — security group, joined on SECURITY_GROUP_ID.
• CSD_REPAIR_ACTUAL_LINES_PK / _U1 / _U2 — primary and unique indexes enforcing integrity.