Results for “cst_mgd_infl_tsf_org_entries”

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

Overview

CST_MGD_INFL_TSF_ORG_ENTRIES is a table owned by the BOM schema in Oracle E-Business Suite (documented for ETRM 12.2.2, also present in 12.1.1). It falls under the Bills of Material product family and stores transfer organization information used for inflation adjustment. In the context of Oracle Cost Management and the ETRM (Enterprise Transaction and Reporting Model), this table acts as the repository for the organization-level entries that qualify a material transaction for inflation-based cost adjustment across a transfer between organizations. Each row associates an inventory transaction with the accounting period and the transfer organization through which the inflation adjustment is processed.

Mined from its foreign-key structure, the heuristic Data Vault classification for this object is a link. As a modeling suggestion, this reflects that the table primarily resolves relationships between core business entities — a material transaction, an accounting period, an inventory item, and a transfer organization — rather than carrying a rich set of descriptive attributes that would characterize a satellite. The physical schema documents 17 columns, with the primary key CST_MGD_INFL_TSF_ORG_PK defined on TRANSACTION_ID.

Key Information Stored

The most significant columns capture transaction context, accounting context, and the transfer organization for which inflation adjustment entries are maintained:

• TRANSACTION_ID — The surrogate primary key (CST_MGD_INFL_TSF_ORG_PK) and a foreign key to MTL_MATERIAL_TRANSACTIONS, identifying the underlying inventory transaction.
• INVENTORY_ITEM_ID — The item being transferred and adjusted.
• ORGANIZATION_ID — The organization context in which the entry applies; referenced as part of the foreign-key relationship to organization-period data.
• ACCT_PERIOD_ID — Foreign key to ORG_ACCT_PERIODS, anchoring the entry to a specific accounting period.
• TRANSFER_ORGANIZATION_ID — The transfer organization that the inflation adjustment pertains to, the central purpose of the table.
• COUNTRY_CODE — The country context in which the inflation adjustment logic applies.
• ENTERED_DR and ENTERED_CR — The entered debit and credit amounts associated with the adjustment entries.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — Audit columns identifying the concurrent program that created or last updated the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY — Standard EBS who-columns for change tracking and audit.

While the primary key is a surrogate on TRANSACTION_ID, the meaningful business keys are the composite of transaction, item, organization, accounting period, and transfer organization — the combination that gives each row its business meaning.

Common Use Cases and Queries

Typical uses include reconciliation of inflation adjustments to inventory transactions, period-close validation, and reporting of transfer-organization adjustment activity by accounting period or country. A representative join pattern follows:

• Joining to MTL_MATERIAL_TRANSACTIONS on TRANSACTION_ID to retrieve transaction details such as transaction date, quantity, and transaction type.
• Joining to ORG_ACCT_PERIODS on ACCT_PERIOD_ID (and ORGANIZATION_ID) to place the adjustment within the correct accounting period state — for example, querying only open or unclosed periods.
• Aggregating ENTERED_DR and ENTERED_CR by TRANSFER_ORGANIZATION_ID, COUNTRY_CODE, or ACCT_PERIOD_ID for adjustment summaries.
• Filtering by REQUEST_ID or PROGRAM_ID to trace entries back to the concurrent program that generated them.

Related Objects

The following objects are most significant in relation to this table, based on the documented foreign-key and primary-key relationships:

• MTL_MATERIAL_TRANSACTIONS — Referenced via CST_MGD_INFL_TSF_ORG_ENTRIES.TRANSACTION_ID; the source inventory transaction.
• ORG_ACCT_PERIODS — Referenced via CST_MGD_INFL_TSF_ORG_ENTRIES.ACCT_PERIOD_ID and ORGANIZATION_ID; the accounting period definition.
• CST_MGD_INFL_TSF_ORG_PK — The primary key constraint on TRANSACTION_ID that uniquely identifies each entry.
• Related Cost Management inflation adjustment tables (for example, managed inflation adjustment headers and lines) that share the same transaction and organization context and are typically joined through TRANSACTION_ID.
• Organization and item master tables referenced indirectly through ORGANIZATION_ID, TRANSFER_ORGANIZATION_ID, and INVENTORY_ITEM_ID for descriptive reporting.