Results for “compute_pf_func_billed_amt”

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

Overview

IGC_CC_COMP_AMT_PKG is an Oracle E-Business Suite package body owned by the APPS schema that supports the Funds Control and commitment accounting functionality within the Grants Accounting / Costing (IGC) module. Its primary business function is to compute billed amounts, functional amounts, and commitment-related expenditures associated with purchasing and invoicing activity. In the context of Oracle EBS 12.1.1 and 12.2.2, this package performs the amount derivation logic that translates entered (transaction) currency values into functional currency values, and reconciles billed versus unbilled balances at the purchase order (PF, or "purchase fund") and account-line level. These calculations feed the commitment control and budgetary checking processes that determine whether funds are available before commitments or expenditures are posted.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package. Each is named to reflect the computation it performs:

• COMPUTE_PF_BILLED_AMT — Derives the billed amount associated with a purchase fund (PF) reference. It is used to determine how much of a commitment has been invoiced.
• COMPUTE_PF_FUNC_BILLED_AMT — Returns the functional-currency equivalent of the PF billed amount, applying currency conversion rules.
• COMPUTE_ACCT_BILLED_AMT — Computes the billed amount at the account-line level, aggregating or attributing invoice distributions to the appropriate accounting line.
• COMPUTE_ACCT_FUNC_BILLED_AMT — Provides the functional-currency version of the account-level billed amount.
• COMPUTE_FUNCTIONAL_AMT — A general utility routine that converts a given amount into functional currency, typically using the GL sets of books configuration.
• COMPUTE_PF_BILL_AMT_CURR — Computes the PF billed amount expressed in a specified (entered) currency, distinct from the functional-currency variant.
• COMPUTE_ACCT_BILLED_AMT_CURR — Computes the account-level billed amount in the entered currency.

Together these routines provide both transaction-currency and functional-currency views of billed amounts, at both the purchase fund and account-line aggregation levels.

Tables Accessed

The package reads and writes data across purchasing, invoicing, and Grants Accounting tables, all accessed through APPS synonyms:

• AP_INVOICE_DISTRIBUTIONS_ALL — the primary source of billed amounts, providing invoice distribution lines matched to purchase orders.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL — the purchasing tables that supply commitment line structure, quantities, prices, and distribution accounting.
• IGC_CC_HEADERS — the commitment-control header table storing the control record being processed.
• IGC_CC_ACCT_LINES — the commitment-control account lines where computed billed and functional amounts are recorded or compared.
• IGC_CC_DET_PF — the purchase-fund detail table linked to commitment control headers.
• GL_SETS_OF_BOOKS — supplies functional currency and accounting configuration used by COMPUTE_FUNCTIONAL_AMT.

These tables are consistent with a package that reconciles open commitments against actual invoiced activity.

Usage Notes

IGC_CC_COMP_AMT_PKG is not referenced by any database object, meaning it is not invoked as a dependency of another stored object in the documented metadata; instead, it is called directly by application logic. Its seven procedures are typically invoked from Grants Accounting commitment-control forms and concurrent programs, and it is referenced by nine other packages. The most common invocation context is during invoice validation and purchase-order commitment processing, where the current billed amount must be computed before funds availability is evaluated. Custom code extending commitment control or budgetary checking may call these routines directly, supplying the appropriate header or account-line keys. Because the package supports both entered and functional currency computations, it is suitable for multi-currency ledgers and for reconciliation reporting where transaction-currency and functional-currency balances must be compared.