Search Results revalue_main

Overview

The IGC_CC_REVALUE_PROCESS_PKG package is a PL/SQL component of the Oracle E-Business Suite Contracts Commitment (IGC) module, which forms part of the broader Enterprise Technical Reference Model (ETRM) landscape in Oracle EBS 12.1.1 and 12.2.2. Its principal business function is to perform currency revaluation processing on commitment control (CC) transactions and balances. Currency revaluation is the accounting exercise of restating foreign-currency-denominated balances at a current exchange rate so that the general ledger reflects prevailing market values rather than historical rates.

Within the IGC schema, the package coordinates the recalculation of commitment amounts held in a foreign currency, applies the appropriate rate type and rate date, and records the resulting revaluation entries against the relevant commitment headers, account lines, and detail records. The package owner is APPS, and it is classified in the ETRM metadata as an "OTHER" API, meaning it is not a formally published open interface but is nonetheless a callable server-side routine used by the commitment control processing framework. The header comment indicates a long-standing code line (version 120.4, dated 2007), reflecting the maturity of the routine across EBS releases.

Key Procedures and Functions

The ETRM documentation records a single public procedure within the package specification:

• REVALUE_MAIN — The entry point for the revaluation process. It drives the end-to-end revaluation of commitment control data for a specified scope. Its parameters, as documented in the package specification, include output parameters for error buffering and return code (ERRBUF and RETCODE, consistent with the concurrent program calling convention), a process phase indicator, a currency code, a rate type, a rate date, a rate value, and a commitment control header identifier. These inputs allow the caller to target revaluation either across a currency and rate configuration or against a specific CC header. The procedure orchestrates the selection of eligible records, retrieval of exchange rates, computation of revaluation differences, and persistence of the resulting entries and exceptions.

No other packaged procedures or functions are documented in the available metadata, which suggests REVALUE_MAIN is the sole supported invocation surface for the revaluation logic.

Tables Accessed

The package references a substantial set of tables, primarily through APPS synonyms. These fall into three functional groups.

• Commitment control core tables: IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF, IGC_CC_ACTIONS, IGC_CC_INTERFACE, and IGC_CC_PERIODS hold the commitment documents, their accounting distributions, detail lines, workflow actions, interface staging rows, and the commitment period definitions that govern revaluation eligibility. PO_HEADERS_ALL links the commitment records to their originating purchasing documents.
• Processing and audit tables: IGC_CC_PROCESS_DATA and IGC_CC_PROCESS_EXCEPTIONS store run-time processing state and any rows that failed revaluation, supporting diagnostics and restartability. FND_APPLICATION provides application context.
• General Ledger reference tables: GL_DAILY_RATES, GL_PERIODS, GL_PERIOD_STATUSES, and GL_PERIOD_TYPES supply the exchange rates (by rate type and rate date), the open/closed status of accounting periods, and the period definitions required to validate that revaluation is performed only for permissible periods.

Collectively, these reads and writes establish the exchange rate, validate the period, identify the commitment balances to restate, and persist both successful revaluation entries and exceptions.

Usage Notes

IGC_CC_REVALUE_PROCESS_PKG is typically invoked in a batch, server-side context rather than from an interactive form. The presence of ERRBUF and RETCODE output parameters strongly indicates that it is called from a concurrent program registered under the Commitment Control responsibility, where the concurrent manager supplies and captures these standard parameters. The process phase parameter allows the routine to be executed in stages, which supports resumable or multi-pass runs.

Because the package is classified as OTHER and is referenced by no other packages, it should be treated as a private implementation routine of the commitment control revaluation concurrent process. Customizations or extensions that call it directly must pass a consistent combination of currency code, rate type, rate date, rate, and header identifier, and must respect General Ledger period status to avoid writing entries into closed periods. As with all EBS server-side routines, direct invocation beyond the delivered concurrent program is unsupported and should be validated against the specific 12.1.1 or 12.2.2 patch level in use.