Search Results igc_cc_acct_line

Overview

IGC.IGC_CC_MC_ACCT_LINES is a reporting-currency detail table within the Oracle E-Business Suite Grants and Contracts (IGC) schema. Its documented purpose is to store reporting currency information for each account line held in the IGC_CC_ACCT_LINE table. The table supports multi-currency cost and encumbrance reporting by preserving one row per reporting set of books for a given account line, allowing functional amounts to be converted and stored against multiple reporting currencies simultaneously.

The relationship between IGC_CC_ACCT_LINES and IGC_CC_ACCT_LINE is documented as an optional one-to-many association. For any single account line, several rows may exist in IGC_CC_MC_ACCT_LINES sharing the same CC_ACCT_LINE_ID but differing in REPORTING_SET_OF_BOOKS_ID. The number of stored lines corresponds to the number of Reporting Sets of Books defined in the environment, which means the table grows in proportion to both account line volume and the breadth of the reporting currency configuration.

The metadata classifies this table heuristically as a standalone Data Vault object. In modeling terms, this suggests it can be treated as its own hub-like or link-like artifact anchored on the composite key (CC_ACCT_LINE_ID, SET_OF_BOOKS_ID), rather than being a strictly dependent satellite of a single parent. It does not reference any other database object per the documented dependency graph, and it is referenced only by its own synonym/alias object IGC_CC_MC_ACCT_LINES#.

Key Information Stored

The table contains eight documented columns. The composite primary key, IGC_CC_MC_ACCT_LINES_PK, is defined on CC_ACCT_LINE_ID and SET_OF_BOOKS_ID. The unique index IGC_CC_MC_ACCT_LINES_U1 also covers (CC_ACCT_LINE_ID, SET_OF_BOOKS_ID), confirming this pair as the business-key candidate. Notable columns include:

• CC_ACCT_LINE_ID — Account line defining column; the surrogate identifier linking back to the parent account line.
• SET_OF_BOOKS_ID — Reporting Set of Books defining column (length 15); distinguishes reporting currency contexts.
• CC_ACCT_FUNC_AMT — The account line functional amount to be converted.
• CC_ACCT_ENCMBRNC_AMT — The account line encumbrance amount to be converted.
• CONVERSION_TYPE — Conversion type used for converting between currencies (VARCHAR2, 30).
• CONVERSION_DATE — Conversion date used for the currency conversion.
• CONVERSION_RATE — Conversion rate applied during conversion.
• CC_FUNC_WITHHELD_AMT — Withheld amount expressed in the functional currency.

Together these columns capture the source amounts, the conversion mechanics (type, date, rate), and derived reporting values per reporting set of books.

Common Use Cases and Queries

Typical scenarios include multi-currency cost reporting, encumbrance reconciliation across reporting books, and audit of conversion rates applied to specific account lines. A common query pattern joins the reporting detail back to the parent account line by CC_ACCT_LINE_ID and filters on SET_OF_BOOKS_ID:

• Retrieve all converted amounts for a given account line across reporting currencies.
• Reconcile CC_ACCT_ENCMBRNC_AMT against source encumbrance balances.
• Audit CONVERSION_TYPE, CONVERSION_DATE, and CONVERSION_RATE for period-end reporting.
• Aggregate withheld amounts (CC_FUNC_WITHHELD_AMT) by reporting set of books.

The documented query text selects CC_ACCT_LINE_ID, SET_OF_BOOKS_ID, CC_ACCT_FUNC_AMT, CC_ACCT_ENCMBRNC_AMT, CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE, and CC_FUNC_WITHHELD_AMT from IGC.IGC_CC_MC_ACCT_LINES, and can be extended with WHERE clauses on SET_OF_BOOKS_ID or joined to IGC_CC_ACCT_LINE on CC_ACCT_LINE_ID.

Related Objects

Based on the documented dependency and key data, the most significant related objects include:

• IGC.IGC_CC_ACCT_LINE — Parent account line table; joined on CC_ACCT_LINE_ID.
• IGC.IGC_CC_MC_ACCT_LINES# — The only object documented as referencing this table.
• IGC_CC_MC_ACCT_LINES_U1 — Unique index on (CC_ACCT_LINE_ID, SET_OF_BOOKS_ID).
• IGC_CC_MC_ACCT_LINES_PK — Composite primary key on the same two columns.
• IGC_CC_MC_ACCT_LINES (synonym/alias) — The queryable form exposed to reporting.

The metadata notes no outbound references from this table, so its relationships are driven primarily through the CC_ACCT_LINE_ID linkage to the account line parent and the SET_OF_BOOKS_ID association with reporting set of books definitions.