Search Results expand_act_cal_gl




Overview
Explore in AI Chat

Overview

APPS.PJI_FM_SUM_ROLLUP_ACT is a PL/SQL package belonging to the Oracle E-Business Suite Project Intelligence (PJI) module, which supplies the Extract-Transform-Load (ETL) layer behind Oracle Projects' summary and rollup reporting structures. In Release 12.1.1 and 12.2.2, Project Intelligence maintains materialized summary tables and views that support project performance, cost, and commitment analytics. This package is the engine that consolidates detailed project transaction slices — expenditure, commitments, budgets, and related distribution lines — into the aggregate tables used by these reporting structures.

The package is not a public application programming interface. Its API classification is OTHER, and its header comment ($Header: PJISF05S.pls 120.2 2005/11/10 ... noship $) identifies it as an internal, non-shipped support unit. It is invoked by the Project Intelligence summarization and rollup concurrent programs rather than by end-user forms or external integrations. Every procedure in the package accepts a p_worker_id that identifies the concurrent request or worker session performing the rollup, allowing parallel workers to partition their work and coordinate progress.

Key Procedures and Functions

The package specification exposes the following subprograms:

  • ACT_ROWID_TABLE — Populates a work table of ROWIDs for the activity slices to be processed by the current worker, establishing the input set for downstream aggregation and merge steps.
  • AGGREGATE_ACT_SLICES — The core aggregation routine, and the object matched by the search term "aggregate_act_slices". It rolls up detailed activity slices into summary-level records, the heart of the summarization flow.
  • PURGE_ACT_DATA — Removes stale or already-processed activity data for the worker, keeping the staging structures clean between runs.
  • EXPAND_ACT_CAL_EN — Expands activity calendar or cumulative data for English (EN) reporting requirements.
  • EXPAND_ACT_CAL_PA — Expands activity calendar data for the Projects (PA) schema perspective.
  • EXPAND_ACT_CAL_GL — Expands activity calendar data for the General Ledger (GL) perspective.
  • EXPAND_ACT_CAL_WK — Expands activity calendar data for the weekly (WK) summary period.
  • MERGE_ACT_INTO_ACP — Merges processed activity rows into the aggregated project (ACP) summary object.
  • PROJECT_ORGANIZATION — Derives and stores organization-related attributes for the summarized project records.
  • REFRESH_MVIEW_ACO — Refreshes the ACO materialized view after the merge completes.
  • REFRESH_MVIEW_ACC — Refreshes the ACC materialized view after the merge completes.

Tables Accessed

The ETRM metadata documents no direct table references for this package; the referenced-tables list is empty in the supplied excerpt. Functionally, the package operates on the Project Intelligence activity slice and summary staging tables, using APPS synonyms. The ACT_ROWID_TABLE, AGGREGATE_ACT_SLICES, and PURGE_ACT_DATA procedures manipulate the staging and slice tables, while MERGE_ACT_INTO_ACP writes into the aggregated project tables and the REFRESH_MVIEW procedures touch the ACO and ACC summary materialized views. Consumers of those views include Oracle Projects and Project Intelligence reporting.

Usage Notes

This package is invoked internally by the Project Intelligence summarization and rollup concurrent programs. It is not intended for direct invocation from the E-Business Suite Forms interface, and it carries no public API contract. Custom code, concurrent program definitions, or extensions should not call these procedures directly; the supported integration point is the concurrent program that drives the rollup. Because each procedure is worker-scoped through p_worker_id, the package supports the multi-worker parallel processing model used by Project Intelligence rollups in both 12.1.1 and 12.2.2. The p_backlog_flag parameter, defaulting to 'N', indicates that expansion and merge procedures may optionally reprocess backlog activity data.