Search Results update_gl_balances

Overview

PSB_WS_ACCT2 is a private PL/SQL package in the Oracle EBS Applications (APPS) schema that supports the budgeting and worksheet generation engine of Oracle Enterprise Planning and Budgeting / Public Sector Budgeting (PSB). Its central responsibility is to build the account (code combination) lines that make up a budgeting worksheet for a given budget group. As the header notes, the package "Create Worksheet Account Lines for Budget Group after applying all Account Parameters specified in the Parameter Set and distributing the Account Lines using the Allocation Rules."

The package maintains several package-level PL/SQL collection types and global variables that persist state across procedure calls within a session. These include g_deferred_ccids (a table of deferred code combination records with budget group, proposed years, code combination id, and start/end periods), g_sorted_ccids, g_dependent_ccids (a table capturing ccid-to-dependent-ccid relationships), and counters such as g_num_defccids, g_num_sortccids, and g_num_depccids. A public variable g_running_total was added under bug 3704360. The package is classified as OTHER and is referenced by four other packages, indicating it functions as a building block within the broader PSB/worksheet processing chain rather than as a standalone public API.

Key Procedures and Functions

• CREATE_WORKSHEET_ACCOUNTS — The package's flagship routine (initial version 1.0, created 05/16/1997 by Supriyo Ghosh, and revised several times). It generates the worksheet account lines for a budget group, applying account parameters from the parameter set and distributing the resulting account lines according to allocation rules. Its documented parameter is p_return_status (standard FND_API–style status), alongside worksheet, rounding factor, stage set, service package, and start stage sequence inputs.
• UPDATE_GL_BALANCES — Synchronizes general ledger balances associated with the worksheet accounts being processed.
• REVISE_ACCOUNT_PROJECTIONS — Adjusts projected (proposed-year) amounts for accounts, supporting the multi-year budgeting model.
• PROCESS_DEFERRED_CCIDS — Handles code combinations that cannot be resolved immediately and are stored in the deferred-ccid collection for later processing once dependent data is available.
• APPLY_ACCOUNT_PARAMETERS — Applies the filtering and selection rules defined in the parameter set to determine which accounts qualify for the worksheet.
• DISTRIBUTE_ACCOUNT_LINES — Spreads account amounts across periods or organizations using the allocation rules.
• CREATE_ROLLUP_TOTALS — Produces summary/rollup totals over the account hierarchies used in the budget.
• GET_DEBUG — Returns debug/diagnostic information, useful for troubleshooting worksheet generation.

Tables Accessed

The package reads and writes through APPS synonyms. It consults setup and control tables including FINANCIALS_SYSTEM_PARAMETERS, PSB_BUDGET_GROUPS, PSB_BUDGET_PERIODS, PSB_BUDGET_YEAR_TYPES, PSB_ENTITY, PSB_ENTITY_ASSIGNMENT, PSB_SERVICE_PACKAGES, and PSB_PARAMETER_FORMULAS. Account and allocation logic draws on GL_CODE_COMBINATIONS, GL_ACCOUNT_HIERARCHIES, PSB_ALLOCRULE_PERCENTS, PSB_SET_RELATIONS, and PSB_BUDGET_ACCOUNTS. Balance and budget data reside in PSB_GL_BUDGETS and PSB_GL_BUDGET_SETS. Together these tables provide the hierarchies, allocation percentages, projection rules, and account parameters required to construct and distribute worksheet account lines.

Usage Notes

Because the package is a private implementation and is referenced by four other packages, it is not intended for direct customer invocation. It is typically driven by the PSB worksheet generation flow — the budget worksheet form and its associated concurrent programs call the higher-level service package, which in turn invokes CREATE_WORKSHEET_ACCOUNTS. Customizations should call the public worksheet API rather than PSB_WS_ACCT2 directly. The package is compatible with both EBS 12.1.1 and 12.2.2, with its header last modified at version 120.5.