Search Results fa_balrep_pkg




Overview
Explore in AI Chat

Overview

FA_BALREP_PKG is the Oracle Assets (Fixed Assets) package responsible for generating the Balance Report and related period-comparison reports within Oracle E-Business Suite. The Balance Report provides a reconciliation of asset balances between two accounting periods, showing opening balances, additions, adjustments, retirements, transfers, and closing balances by book, category, and period. This package implements a parallel, worker-based processing model to support high-volume asset books, splitting report generation across multiple concurrent workers rather than executing the report in a single serial pass through the asset tables.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner. This is significant because the balance report queries operate against a wide range of FA tables and rely on the invoking user's access to APPS synonyms. The package header carries a NOSHIP designation, indicating it is an internal, non-API component not intended for direct customer invocation.

Key Procedures and Functions

  • LOAD_WORKERS — Populates the worker job framework used by the parallel balance report run. It accepts a book type code and request ID, then seeds the worker assignments (through the FA_WORKER_JOBS structure) that divide the reporting workload into discrete units of work. It returns standard concurrent program OUT parameters for error buffer and return code.
  • POPULATE_GT_TABLE — Populates the global temporary table used to stage the intermediate balance report results. Its parameter list includes the book, report type, report style, request ID, and worker number, together with the period-comparison inputs that define the reporting window: Period1_PC, Period1_POD, Period1_PCD, Period2_PC, and Period2_PCD, along with an optional distribution source book. The period identifier parameters allow the procedure to compute movements for two distinct periods and present a comparative balance. This procedure is the core work unit executed by each parallel worker.
  • LAUNCH_WORKERS — Coordinates the overall parallel run. It receives the same book, report type, report style, period, and distribution-source parameters as POPULATE_GT_TABLE, and additionally takes the total request count. It manages the launch and synchronization of the individual worker requests, collecting error buffer and return code outputs for the parent concurrent request.

Tables Accessed

The package references a broad set of Assets transactional and setup tables through APPS synonyms. FA_BOOK_CONTROLS, FA_BOOKS, FA_BOOKS_GROUPS, and FA_CATEGORY_BOOKS supply book, category, and accounting-control context. FA_DEPRN_PERIODS and FA_DEPRN_SUMMARY provide the depreciation period definitions and period-end asset balances that form the backbone of the report. FA_DEPRN_DETAIL contributes the transaction-level depreciation and cost detail. FA_ADJUSTMENTS, FA_ASSET_HISTORY, and FA_TRANSACTION_HEADERS provide adjustments and asset transaction history supporting cost and adjustment movement lines. FA_DISTRIBUTION_HISTORY and FA_GROUP_ASSET_RULES/FA_GROUP_ASSET_DEFAULT support distributions and group-asset accounting rules. FA_BALANCES_REPORTS_ITF is the interface table used to stage report output, and FA_WORKER_JOBS tracks the parallel worker assignments created by LOAD_WORKERS.

Usage Notes

FA_BALREP_PKG is invoked primarily from the Oracle Assets concurrent program that produces the Balance Report. The parent request calls LAUNCH_WORKERS, which in turn spawns worker requests invoking POPULATE_GT_TABLE after LOAD_WORKERS has established the job partition. It is documented as being referenced by one other package, and it is not a public API; customizations should not call it directly. The period1_pcd parameter (Period 1 Period Close Date) that triggered this search is the period-close date identifying the first comparison period, paired with period1_pc (the period counter). Administrators investigating balance report performance or worker failures typically trace FA_WORKER_JOBS and FA_BALANCES_REPORTS_ITF for diagnostics.