Results for “cstfv_mfg_txn_distributions”

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

Overview

CSTFV_MFG_TXN_DISTRIBUTIONS is a VALID view owned by the APPS schema in Oracle EBS releases 12.1.1 and 12.2.2, catalogued under the BOM (Bills of Material) product family and marked in the ETRM repository as "Retrofitted." The view exposes manufacturing transaction accounting distributions sourced from the Work in Process and Cost Management schemas, denormalizing the accounting lines generated when WIP transactions (issues, completions, scrap, resource charges, overhead absorption) are costed and distributed to the General Ledger. Its role is primarily reporting and integration: it provides a flattened, human-readable projection of WIP_TRANSACTION_ACCOUNTS joined to supporting master and transactional entities, so that cost accountants, manufacturing analysts, and downstream integrators can inspect the debit and credit side of each manufacturing cost event without navigating the underlying normalized tables.

The "Retrofitted" designation indicates the object was carried forward or re-created as part of upgrade/retrofit activity across the 12.x code line; functionally it remains the reporting surface for WIP transaction distributions. Because it is a view rather than a table, it carries no independent storage or index structure — its performance is a direct function of the cost of joining the referenced base objects, most notably WIP_TRANSACTION_ACCOUNTS and GL_CODE_COMBINATIONS.

Underlying Base Objects

The view definition joins eleven documented synonym objects, ten of which are referenced in the ETRM metadata. The driving table is WIP_TRANSACTION_ACCOUNTS (aliased WTA), which holds one row per accounting distribution line. It is joined to WIP_TRANSACTIONS (WT) on TRANSACTION_ID to obtain the transaction type, and to WIP_ENTITIES (WE) for the WIP entity name. Repetitive manufacturing context is supplied by an outer join to WIP_REPETITIVE_SCHEDULES (WRS) on REPETITIVE_SCHEDULE_ID. Organization context comes from MTL_PARAMETERS (MP), HR_ALL_ORGANIZATION_UNITS (HAOU), and, via outer join, ORG_GL_BATCHES (OGB) on both ORGANIZATION_ID and GL_BATCH_ID. Accounting flexfield resolution is performed against GL_CODE_COMBINATIONS (GCC) on REFERENCE_ACCOUNT = CODE_COMBINATION_ID. Resource and activity attributes come from outer joins to BOM_RESOURCES (BR for the charged resource, BR1 for the basis resource) and CST_ACTIVITIES (CA). The remaining referenced synonym, BOM_RESOURCES, appears twice through its two aliases, consistent with the ten-object ETRM list.

Key Columns

• RESOURCE_ID, BASIS_RESOURCE_ID, ACTIVITY_ID, COST_ELEMENT_ID — identifiers linking the distribution to the charged resource, the resource used as an overhead/cost basis, the cost activity, and the cost element.
• REFERENCE_ACCOUNT — the GL code combination ID resolved to the accounting flexfield via GL_CODE_COMBINATIONS and the _KF:SQLGL:GL#:GCC flexfield descriptor.
• TRANSACTION_VALUE, BASE_TRANSACTION_VALUE, PRIMARY_QUANTITY, RATE_OR_AMOUNT, OVERHEAD_BASIS_FACTOR — the monetary and quantity measures of the distribution.
• CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE — currency and conversion detail for the transaction value.
• WIP_ENTITY_ID, WIP_ENTITY_NAME, REPETITIVE_SCHEDULE_ID, ORGANIZATION_ID, GL_BATCH_ID, TRANSACTION_ID, CONTRA_SET_ID — transactional and organizational identifiers, including the contra set that pairs debit and credit lines.
• ORGANIZATION_CODE, NAME, DESCRIPTION (OGB), TRANSACTION_TYPE, ACCOUNTING_LINE_TYPE, BASIS_TYPE — descriptive attributes resolved through MFG_LOOKUPS and organization tables.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard WHO audit columns.

Common Use Cases and Queries

A frequent scenario is reconciling WIP accounting distributions for a given organization and accounting period, benefiting from the denormalized organization code and GL batch description:

SELECT wip_entity_name, transaction_date, transaction_value, currency_code, description
FROM cstfv_mfg_txn_distributions
WHERE organization_id = :org_id
AND transaction_date BETWEEN :start_date AND :end_date;

Analysts also aggregate distributions by WIP entity to trace the flow of material, resource, and overhead costs into inventory and variance accounts, or filter by GL_BATCH_ID to confirm that a batch of manufacturing distributions was transferred to the General Ledger. Though the searched term offset_account_id does not appear among the columns projected by this view, the accounting entry structure is represented instead through REFERENCE_ACCOUNT, ACCOUNTING_LINE_TYPE, and CONTRA_SET_ID, which together identify the distributed account and its contra line. Users seeking offset-account semantics should therefore key on these columns rather than an offset_account_id attribute.