Search Results calculate_adjustment

Overview

CST_MGD_INFL_ADJUSTMENT_CP is a concurrent program package belonging to the Oracle Cost Management (CST) module. It implements the inflation adjustment cycle used by organizations operating in hyperinflationary economies, where local accounting regulations and IAS 29-style requirements mandate that inventory and cost balances be restated to reflect the effects of inflation before they are transferred to the general ledger. The package encapsulates the two-stage processing model for this cycle: the calculation of inflation-adjusted cost amounts, and the subsequent creation of general ledger account entries and period finalization. As the package name and header comment indicate, its logic is driven by organization, country, and accounting period parameters, working in conjunction with the price index stored in Oracle Assets (FA) tables. The package resides in the APPS schema and is classified as OTHER, meaning it is not a public open-interface API but an internal concurrent-program driver invoked only by its registered concurrent program.

Key Procedures and Functions

The package exposes two documented procedures. Both return the standard concurrent program error buffer and return code, where a return code of 0 indicates success, 1 indicates a warning, and 2 indicates an error.

• CALCULATE_ADJUSTMENT — This is the concurrent program routine for inflation adjustment. It accepts the organization identifier, country code, accounting period identifier, and inflation index, and performs the calculation of inflation-adjusted cost amounts for the period. This is the procedure most commonly associated with the search term "calculate_adjustment." Its primary parameters include the organization ID, country code, account period ID, and inflation index, along with the standard error buffer and return code.
• TRANSFER_TO_GL — This procedure creates accounting entries for the inflation-adjusted items and sets the accounting period to final. It accepts the organization identifier, country code, and accounting period identifier, together with the error buffer and return code, and drives the transfer of adjusted amounts into the general ledger.

Tables Accessed

The package reads and writes a wide set of cost management, assets, and general ledger tables through APPS synonyms:

• CST_MGD_INFL_ADJUSTED_COSTS — stores the calculated inflation-adjusted cost amounts produced by CALCULATE_ADJUSTMENT.
• CST_MGD_INFL_ADJ_PER_STATUSES — tracks the status of the inflation adjustment period.
• CST_MGD_INFL_TSF_ORG_ENTRIES — holds inflation transfer entries destined for the general ledger.
• CST_PERIOD_CLOSE_SUMMARY, ORG_ACCT_PERIODS, MTL_PER_CLOSE_DTLS — provide and update period close context and status.
• CST_COST_GROUPS, MTL_SYSTEM_ITEMS, MTL_PARAMETERS — supply cost group definitions, item master data, and organization parameters used to scope the adjustment.
• FA_PRICE_INDEXES, FA_PRICE_INDEX_VALUES — supply the inflation index values used in the restatement calculation.
• GL_JE_CATEGORIES, GL_JE_SOURCES — provide the journal category and source used when creating GL entries in TRANSFER_TO_GL.
• PLITBLM — the standard Oracle PL/SQL table used for internal batch processing.

Usage Notes

CST_MGD_INFL_ADJUSTMENT_CP is not called from Oracle Forms and is not referenced by any other documented package (Referenced by 0 other packages). It is designed to be executed as a registered concurrent program, with CALCULATE_ADJUSTMENT run first to compute adjusted amounts, followed by TRANSFER_TO_GL to generate GL entries and finalize the period. The required parameters—organization ID, country code, account period ID, and inflation index—are supplied at submission time. Because the package is classified as OTHER rather than a public API, custom code should not invoke its procedures directly; instead, the concurrent program should be submitted, and any extension should be built around the documented tables CST_MGD_INFL_ADJUSTED_COSTS and CST_MGD_INFL_TSF_ORG_ENTRIES.