Results for “csf_debrief_lines”

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

Overview

CSF_DEBRIEF_LINES is the line-level detail table for Field Service debrief (Service Report) transactions in Oracle E-Business Suite, owned by the CSF schema. A debrief captures what a field service technician actually performed, consumed, returned, or charged during a service visit; CSF_DEBRIEF_HEADERS stores the visit-level summary, while CSF_DEBRIEF_LINES stores the individual activity lines that roll up to it. Each row represents a single debrief action such as material consumption, part removal/return, labor time, expense, or mileage entry, and carries the reference data needed for downstream charge calculation, inventory movement, and interface into Order Management, Inventory, and Projects.

The table contains 86 documented columns and is validated as of ETRM 12.2.2. Based on FK topology, the heuristic Data Vault classification is satellite-leaning: the table is anchored to a parent (CSF_DEBRIEF_HEADERS) via a persistent key and primarily stores descriptive, attribute-rich context rather than acting as a pure many-to-many relationship table, though the presence of several dimension-style FKs (billing type, business process, security group) gives it minor link-like characteristics.

Key Information Stored

• DEBRIEF_LINE_ID — surrogate primary key (CSF_DEBRIEF_LINES_PK) and the column of unique index CSF_DEBRIEF_LINES_U1; the true row identifier.
• DEBRIEF_HEADER_ID — FK to CSF_DEBRIEF_HEADERS; links each line to its parent debrief/service report.
• DEBRIEF_LINE_NUMBER — ordering/sequence within the parent debrief.
• SERVICE_DATE — the date the line's activity occurred, used for period and aging reporting.
• TXN_BILLING_TYPE_ID — FK to CS_TXN_BILLING_TYPES; drives whether and how the line is billed.
• INVENTORY_ITEM_ID, ITEM_SERIAL_NUMBER, ITEM_REVISION, ITEM_LOTNUMBER, UOM_CODE, QUANTITY — material identity and quantity for consumed or returned parts.
• ISSUING_INVENTORY_ORG_ID / RECEIVING_INVENTORY_ORG_ID plus subinventory and locator columns — the source/destination warehouses and bins for the material transaction.
• PARENT_PRODUCT_ID, REMOVED_PRODUCT_ID, STATUS_OF_RECEIVED_PART, DISPOSITION_CODE — installed-base context for parts removed and returned.
• LABOR_START_DATE, LABOR_END_DATE, STARTING_MILEAGE, ENDING_MILEAGE, EXPENSE_AMOUNT, CURRENCY_CODE — labor time, travel, and expense capture.
• DEBRIEF_LINE_STATUS_ID and the CHARGE_UPLOAD_*, IB_UPDATE_*, SPARE_UPDATE_* status/message column groups — interface processing state and error text.
• SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS; BUSINESS_PROCESS_ID — FK to CS_BUSINESS_PROCESSES; both provide classification and access context.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ATTRIBUTE1–15/ATTRIBUTE_CATEGORY for extensibility.

Note: business-key candidates are limited — the documented unique index is on the surrogate DEBRIEF_LINE_ID, so no natural alternate key is exposed in the metadata.

Common Use Cases and Queries

Primary reporting on debrief lines typically joins to the header and to item/billing dimensions. Typical patterns include material usage per service call, billable vs. non-billable charges, and unreconciled interface lines:

• Detail listing for a debrief: SELECT dl.DEBRIEF_LINE_ID, dl.DEBRIEF_LINE_NUMBER, dl.SERVICE_DATE, dl.INVENTORY_ITEM_ID, dl.QUANTITY, dl.DEBRIEF_LINE_STATUS_ID FROM CSF_DEBRIEF_LINES dl WHERE dl.DEBRIEF_HEADER_ID = :header_id ORDER BY dl.DEBRIEF_LINE_NUMBER;
• Material consumption by item and org: SELECT INVENTORY_ITEM_ID, ISSUING_INVENTORY_ORG_ID, SUM(QUANTITY) FROM CSF_DEBRIEF_LINES GROUP BY INVENTORY_ITEM_ID, ISSUING_INVENTORY_ORG_ID;
• Interface/error monitoring: filter on CHARGE_UPLOAD_STATUS, IB_UPDATE_STATUS, or SPARE_UPDATE_STATUS along with ERROR_TEXT to find failed debrief lines pending posting.
• Labor and expense rollups by service date, joined to CSF_DEBRIEF_HEADERS for customer, resource, and service request context.

Related Objects

• CSF_DEBRIEF_HEADERS — parent table; join on CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID = CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID.
• CS_ESTIMATE_DETAILS — references this table via ORIGINAL_SOURCE_ID; links debrief activity back to the originating estimate line for charge comparison.
• CS_TXN_BILLING_TYPES — lookup for TXN_BILLING_TYPE_ID, determining billing treatment.
• CS_BUSINESS_PROCESSES — classification via BUSINESS_PROCESS_ID.
• FND_SECURITY_GROUPS — row-level security context via SECURITY_GROUP_ID.
• Downstream Inventory/Order Management and Projects interfaces consume the charge upload, item interface (IB_UPDATE_*), and spare update (SPARE_UPDATE_*) status groups to post material movements and billable charges.