Results for “txn_type”

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

Overview

CST_EAM_BALANCE_BY_ACCOUNTS is an Oracle EBS table owned by the BOM (Bills of Material) schema that stores estimated cost information organized by WIP accounting class accounts. Despite the BOM ownership and the "CST" prefix, this object is functionally tied to the Enterprise Asset Management (EAM) work order costing flow, capturing accumulated balances per accounting period, per department, and per cost element for EAM-maintained assets. Each row represents a summarized balance position tied to a specific WIP entity, accounting period, and account combination, enabling the Cost Management and WIP processes to reconcile estimated EAM costs against the general ledger.

From a Data Vault modeling perspective, the mined foreign-key structure would suggest classifying this table heuristically as a link, since it primarily connects a discrete job (WIP entity), an accounting period, an owning department, a manufacturing cost element, and an EAM cost element transaction type rather than acting as a self-contained descriptive hub or satellite.

Key Information Stored

The table contains 20 documented columns in the ETRM 12.2.2 schema. The most significant include:

• WIP_ENTITY_ID — identifier of the discrete EAM work order being costed; a foreign key to WIP_DISCRETE_JOBS.
• ACCT_PERIOD_ID — the accounting period the balance belongs to; foreign key to ORG_ACCT_PERIODS.
• ORGANIZATION_ID — the inventory organization owning the transaction and period context.
• PERIOD_SET_NAME and PERIOD_NAME — the accounting calendar and named period, providing the human-readable period key.
• PERIOD_START_DATE — the start date of the accounting period.
• OWNING_DEPT_ID — the department that owns the cost; foreign key to BOM_DEPARTMENTS.
• OPERATIONS_DEPT_ID and OPERATIONS_SEQ_NUM — the department and sequence of the operation generating the cost.
• MAINT_COST_CATEGORY — EAM maintenance cost category classification.
• ACCOUNT_ID and ACCT_VALUE — the GL account combination and its resolved value.
• WIP_ACCT_CLASS_CODE — the WIP accounting class controlling cost absorption and variance posting.
• MFG_COST_ELEMENT_ID — foreign key to CST_COST_ELEMENTS identifying the manufacturing cost element (material, resource, overhead, etc.).
• TXN_TYPE — foreign key to CST_EAM_COST_ELEMENTS, identifying the EAM transaction type that drove the balance.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard audit columns.

The table does not expose an explicitly documented single-column surrogate primary key; the business key is effectively the composite of period, organization, WIP entity, department, cost element, and transaction type. The audit columns follow the standard EBS WHO-column convention.

Common Use Cases and Queries

Typical usage centers on EAM cost reporting and period-end reconciliation. Analysts join this table to WIP_DISCRETE_JOBS to describe the work order, to ORG_ACCT_PERIODS for period validation, and to CST_COST_ELEMENTS to label cost elements.

A representative query pattern aggregates estimated cost by cost element for a given period:

• SELECT c.mfg_cost_element_id, ce.cost_element, SUM(c.acct_value) FROM cst_eam_balance_by_accounts c JOIN cst_cost_elements ce ON ce.cost_element_id = c.mfg_cost_element_id WHERE c.organization_id = :org AND c.period_name = :period GROUP BY c.mfg_cost_element_id, ce.cost_element;

Another common pattern reconciles balances to the GL by joining ACCT_VALUE or ACCOUNT_ID to GL_CODE_COMBINATIONS, grouped by WIP_ACCT_CLASS_CODE and TXN_TYPE. Reporting use cases include EAM work order cost variance analysis, department-level maintenance spend breakdowns using MAINT_COST_CATEGORY, and period-over-period cost trend reporting across organizations.

Related Objects

• WIP_DISCRETE_JOBS — joined on WIP_ENTITY_ID; supplies work order attributes.
• ORG_ACCT_PERIODS — joined on ACCT_PERIOD_ID and ORGANIZATION_ID; governs open/closed period status.
• BOM_DEPARTMENTS — joined on OWNING_DEPT_ID; provides department definitions.
• CST_COST_ELEMENTS — joined on MFG_COST_ELEMENT_ID; labels the cost element.
• CST_EAM_COST_ELEMENTS — joined on TXN_TYPE; identifies the EAM transaction type.
• GL_CODE_COMBINATIONS — logically joined via ACCOUNT_ID for account validation and GL reconciliation.
• CST_EAM_BALANCES and related EAM costing tables — sibling objects in the EAM cost balance family.
• WIP_ACCOUNTING_CLASSES — referenced by WIP_ACCT_CLASS_CODE to resolve accounting class behavior.