Search Results check_period_status

Overview

APPS.CST_MGD_INFL_ADJUSTMENT_CP is the consolidated package body that implements the inflation adjustment processor for Oracle E-Business Suite Cost Management. Its business purpose is to apply price-index-driven inflation adjustments to inventory and cost group balances for a given organization and accounting period, and then to transfer the resulting adjusting journal entries to the General Ledger. The package belongs to the CST (Cost Management) module family and follows the standard EBS CP (Concurrent Program) package pattern: a thin driver layer that validates inputs, identifies the relevant accounting period, and delegates the heavy calculation and accounting work to private procedures.

The inflation adjustment feature is used by organizations that report in a hyperinflationary currency or that otherwise require periodic revaluation of inventory costs to reflect changes in purchasing power. The package relies on price index tables maintained in Oracle Assets (FA_PRICE_INDEXES and FA_PRICE_INDEX_VALUES) as the source of adjustment factors, applying them against on-hand and cost group balances and generating adjusting entries that are ultimately posted to GL.

Key Procedures and Functions

The ETRM metadata documents two public procedures in this package body:

• CALCULATE_ADJUSTMENT — Computes the inflation adjustment amounts for the qualifying organization and accounting period. It reads price index values, applies them to the eligible cost and inventory balances, derives the adjustment delta, and populates the adjusted-cost staging table. This procedure represents the core computational logic of the inflation adjustment process and validates that the period is open for adjustment and that all required price index data is present.
• TRANSFER_TO_GL — Creates and posts the adjusting journal entries into General Ledger. It builds journal headers and lines using the accounting flexfield and journal category/source assignments defined for Cost Management inflation adjustments, writes the transfer records to the staging tables, and invokes the standard General Ledger interface. This procedure is the final accounting step of the run.

In addition, the source excerpt documents private procedures that support these public entry points. The most relevant to the "check_period_status" search is Check_Inflation_Process_Run, which validates whether the inflation adjustment processor has already been run for a given organization and accounting period ID. It queries CST_MGD_INFL_ADJ_PER_STATUSES for records with status 'PROCESS', and raises the internal exception g_period_is_final_exc when the period has already been finalized. This is the mechanism that prevents duplicate or out-of-sequence inflation adjustments and is typically the point at which a user's "period status" check fails.

Tables Accessed

The package references the following tables and views through APPS synonyms:

• CST_MGD_INFL_ADJ_PER_STATUSES — Tracks the processing status of inflation adjustments per organization and accounting period. It is the table queried by Check_Inflation_Process_Run and is central to period-status validation.
• CST_MGD_INFL_ADJUSTED_COSTS and CST_MGD_INFL_TSF_ORG_ENTRIES — Store the calculated adjusted cost amounts and the organization-level entries that are subsequently transferred to GL.
• FA_PRICE_INDEXES and FA_PRICE_INDEX_VALUES — Provide the price index definitions and period-by-period index values used as the inflation factors.
• GL_JE_CATEGORIES and GL_JE_SOURCES — Supply the journal category and source used when constructing the GL adjustment entries.
• MTL_PARAMETERS, MTL_PER_CLOSE_DTLS, MTL_SYSTEM_ITEMS, and ORG_ACCT_PERIODS — Provide organization defaults, period close status, item attributes, and accounting period definitions used in validation and calculation.
• CST_COST_GROUPS and CST_PERIOD_CLOSE_SUMMARY — Used to identify cost group classifications and to confirm that costing period activity has been summarized.
• PLITBLM — The standard EBS PL/SQL index-by table type used for internal collections.

Usage Notes

CST_MGD_INFL_ADJUSTMENT_CP is not an API intended for direct customer invocation. It is driven by the Inflation Adjustment concurrent program, which submits the calculation and the subsequent transfer-to-GL step for a specified organization and period. Because the package references ORG_ACCT_PERIODS and CST_MGD_INFL_ADJ_PER_STATUSES, the accounting period must be open and no prior inflation adjustment run may exist for the same organization and period; otherwise the period-status validation described above raises an exception and the concurrent request completes with an error.

The package is referenced by zero other packages in the ETRM catalog, confirming that it sits at the top of its call stack and is invoked only from the concurrent manager or from forms that call the underlying concurrent program. Custom code should not call CALCULATE_ADJUSTMENT or TRANSFER_TO_GL directly unless it fully replicates the concurrent program's validation and locking, since the procedures assume the period-status preconditions have been satisfied. When diagnosing a "check_period_status" issue in this area, the relevant artifacts are the CST_MGD_INFL_ADJ_PER_STATUSES rows and the accounting period status in ORG_ACCT_PERIODS; both must indicate an open period and an unprocessed organization before the inflation adjustment run will succeed.