Results for “igc_cc_det_pf_v”

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

Overview

IGC_CC_DET_PF_V is a seeded Oracle E-Business Suite view owned by the APPS schema within the IGC (Contract Commitment) product. It exposes detailed contract commitment lines drawn from the IGC_CC_DET_PF table, enriched with computed amounts supplied by the IGC_CC_COMP_AMT_PKG package. The view is the primary reporting interface through which functional consultants and developers retrieve billed, unbilled, encumbered, and unencumbered commitment balances, since the computed values are not persisted in the underlying base table and must be derived at query time.

The column cc_det_pf_billed_amt is one such derived value. It is not a stored column on IGC_CC_DET_PF; it is returned by the view and computed through IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT, using the detail line identifier, line number, and accounting line identifier as arguments. This is why the term surfaces in searches against the view rather than against the base table.

Underlying Base Objects

The view is defined with the following ETRM-documented base objects:

• IGC_CC_DET_PF (accessed as synonym) — the primary source of detail commitment lines, aliased CCDPF in the view text.
• IGC_CC_ACCT_LINES (accessed as synonym) — joined as CCAL on CC_ACCT_LINE_ID, supplying the accounting line number and header linkage used for functional currency conversion.
• IGC_CC_COMP_AMT_PKG (PL/pgSQL package) — provides the computation functions for billed, functional billed, and functional amounts.

IGC_CC_DET_PF is joined twice: once as CCDPF (the detail line) and again through the PCCDPF alias to resolve the parent detail line via PARENT_DET_PF_LINE_ID. Both the accounting line join and the parent line join are outer joins (+), so detail lines without a matching accounting line or parent are retained. The view therefore behaves as a flat, denormalised projection of the commitment hierarchy with all monetary conversions pre-applied.

Key Columns

• CC_DET_PF_LINE_ID / CC_DET_PF_LINE_NUM — primary line identifier and display number for the detail commitment.
• CC_ACCT_LINE_ID / CC_ACCT_LINE_NUM — accounting line linkage from IGC_CC_ACCT_LINES.
• PARENT_DET_PF_LINE_ID / PARENT_DET_PF_LINE_NUM / PARENT_ACCT_LINE_ID — hierarchy pointers resolved through the PCCDPF alias.
• CC_DET_PF_ENTERED_AMT — original entered amount before currency conversion.
• CC_DET_PF_BILLED_AMT (billed_amt) — computed billed amount via COMPUTE_PF_BILLED_AMT.
• CC_DET_PF_FUNC_BILLED_AMT (FUNC_BILLED_AMT) — functional currency equivalent, via COMPUTE_PF_FUNC_BILLED_AMT.
• CC_DET_PF_UNBILLED_AMT — remaining unbilled commitment balance.
• CC_DET_PF_COMP_FUNC_AMT (COMP_FUNC_AMT) — functional amount derived from COMPUTE_FUNCTIONAL_AMT on the entered amount.
• CC_DET_PF_ENCMBRNC_AMT / ENCMBRNC_DATE / ENCMBRNC_STATUS — encumbrance amount, date, and status.
• CC_DET_PF_UNENCMB (UNENCMBRD_AMT) — functional amount less encumbrance, calculated inline.
• ATTRIBUTE1–15, CONTEXT — descriptive flexfield columns carried through from IGC_CC_DET_PF.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns plus ROW_ID.

Common Use Cases and Queries

Typical usage includes reconciliation of billed versus unbilled commitments, encumbrance reporting, and drill-down from header-level commitment summaries to the detail line level.

SELECT cc_det_pf_line_num,
       cc_det_pf_billed_amt,
       cc_det_pf_func_billed_amt,
       cc_det_pf_unbilled_amt,
       cc_det_pf_encmbrnc_amt,
       cc_det_pf_encmbrnc_status
FROM   apps.igc_cc_det_pf_v
WHERE  cc_acct_line_id = :p_acct_line_id;

Comparing entered and functional amounts for a given accounting line:

SELECT cc_det_pf_line_num,
       cc_det_pf_entered_amt,
       cc_det_pf_comp_func_amt,
       cc_det_pf_unencmb
FROM   apps.igc_cc_det_pf_v
WHERE  cc_det_pf_date BETWEEN :p_from AND :p_to;

Because the billed and functional billed columns are computed per row by IGC_CC_COMP_AMT_PKG, performance-sensitive extracts should filter on indexed base columns (CC_ACCT_LINE_ID, CC_DET_PF_LINE_ID, CC_DET_PF_DATE) before projection, and should be tested against production data volumes in both 12.1.1 and 12.2.2, where the view definition is unchanged.