Results for “amount_ordered”

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

Overview

PA_COMMITMENT_TXNS_EFC is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the summarized commitment amounts for each commitment transaction line. In Oracle Projects, a "commitment" represents an obligation to spend against a project or task, typically originating from Purchasing (purchase order distributions) or from other feeder systems. The "EFC" suffix denotes that the table is an Encumbrance / Funds Control style summary: rather than holding the raw transaction rows themselves (which live in PA_COMMITMENT_TXNS), it aggregates and rolls up amounts—ordered, cancelled, delivered, invoiced, outstanding, and overbilled—along with raw and burdened cost representations in multiple currencies. Its primary role is to provide a fast, pre-aggregated view of commitment balances for project cost reporting, funds checking, and burdening calculations without re-summing the detail table on every query.

With respect to Data Vault modeling, the ETRM metadata classifies this object as standalone based on its foreign-key structure. Because the table is keyed by CMT_LINE_ID and carries only one documented foreign key (to PA_COMMITMENT_TXNS), it behaves structurally like a satellite attached to the commitment transaction line hub, holding descriptive and calculated numeric attributes rather than defining new relationships. This is a heuristic suggestion only; the definitive classification rests on the surrounding PA star schema.

Key Information Stored

The single documented foreign key is CMT_LINE_ID, which references PA_COMMITMENT_TXNS.CMT_LINE_ID. This column is the surrogate/primary key of the table and the join path to the parent commitment transaction line.

• CMT_LINE_ID — surrogates the commitment line; joins to the parent transaction table.
• AMOUNT_ORDERED / ORIGINAL_AMOUNT_ORDERED — the current and originally ordered commitment value.
• AMOUNT_CANCELLED — quantity of the commitment that has been cancelled.
• AMOUNT_DELIVERED — value received against the commitment.
• AMOUNT_INVOICED — value billed against the commitment.
• AMOUNT_OUTSTANDING_DELIVERY and AMOUNT_OUTSTANDING_INVOICE — remaining open delivery/invoice balances.
• AMOUNT_OVERBILLED — excess billed beyond the commitment.
• TOT_CMT_RAW_COST / TOT_CMT_BURDENED_COST — total raw and burdened commitment cost.
• DENOM_RAW_COST / DENOM_BURDENED_COST — equivalent costs in the project's denominator currency.
• ACCT_RAW_COST / ACCT_BURDENED_COST plus ACCT_RATE_DATE, ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE — accounting-currency cost and the exchange-rate context used to derive it.
• SET_OF_BOOKS_ID — identifies the ledger set of books under which the amounts are reported.
• Currency and rate columns (RECEIPT_CURRENCY_CODE, DENOM_CURRENCY_CODE, PROJECT_CURRENCY_CODE, their rate types, dates, and rates; RECEIPT_EXCHANGE_RATE, PROJECT_EXCHANGE_RATE) — capture the multi-currency translation context.
• CREATION_DATE — standard audit stamp of row insertion.

No unique business-key index is documented in the metadata, so CMT_LINE_ID acts as both surrogate and the practical join key.

Common Use Cases and Queries

Typical use cases include project commitment balance reporting, funds-consumption analysis (ordered versus delivered versus invoiced), and burdened-cost roll-forward. A common pattern joins the summary back to its parent transaction:

SELECT t.cmt_line_id, t.project_id, t.task_id,
       e.amount_ordered, e.amount_invoiced,
       e.amount_outstanding_invoice, e.tot_cmt_burdened_cost
FROM   pa_commitment_txns t, pa_commitment_txns_efc e
WHERE  t.cmt_line_id = e.cmt_line_id
AND    e.set_of_books_id = :sobid;

Because the table already aggregates amounts in raw, burdened, denominator, and accounting currencies, reports can avoid re-summing detail cost rows—useful for performance-sensitive dashboards. Auditors may query differences between ordered and invoiced amounts to flag overbillings (AMOUNT_OVERBILLED). Without a documented unique index, de-duplication logic on CMT_LINE_ID should be applied in report queries.

Related Objects

• PA_COMMITMENT_TXNS — parent table; joined on CMT_LINE_ID. This is the only documented foreign key relationship.
• PO_DISTRIBUTIONS — Purchasing distributions that feed commitment transactions into Oracle Projects.
• PA_PROJECTS / PA_TASKS — supply project and task context via PA_COMMITMENT_TXNS.
• PA_PROJECT_CURRENCIES / PA_PROJECT_RATE_TYPES — source of the rate-type definitions referenced by ACCT_RATE_TYPE and PROJECT_RATE_TYPE.
• GL_SETS_OF_BOOKS — validates SET_OF_BOOKS_ID for ledger-based reporting.
• Projects commitment reporting views and concurrent programs that populate EFC summaries from the detail transactions.

In summary, PA_COMMITMENT_TXNS_EFC is a Project-level commitment summary satellite keyed on CMT_LINE_ID, providing multi-currency ordered, delivered, invoiced, and burdened amounts for funds control and commitment reporting in Oracle EBS 12.1.1 and 12.2.2.