Search Results arpr_log




Overview
Explore in AI Chat

Overview

The APPS.PA_PURGE_UNASGN_FI package body provides the purge and archival logic for unassigned time forecast items in Oracle Projects. Within the Oracle E-Business Suite Projects suite, forecast items of type "U" represent resource time forecasts that have not yet been assigned to a specific resource. When these items are no longer needed—either because the related projects have been closed or the transactions fall before a defined cutoff date—they must be removed from the transactional tables to control data volume and preserve performance. The package encapsulates this housekeeping function, optionally archiving records to shadow tables before deletion so that an audit trail is retained.

The package carries the header identifier PAXUSGNB.pls 120.1.12000000.2 and is classified under ETRM as an "OTHER" API. It is not referenced by any other packaged API, indicating it is intended as a standalone utility rather than a reusable building block within the Projects code line.

Key Procedures and Functions

The package exposes four documented procedures and functions:

  • PA_FORECASTITEM — The primary entry point. It drives the purge of unassigned time forecast items whose item date is on or before the supplied purge-through date. It accepts an archive flag indicating whether records should be archived prior to removal, and it uses a bulk-fetch cursor over PA_FORECAST_ITEMS with a commit size of 1000 rows. Diagnostic progress is written through calls to the logging routine during execution.
  • DELETE_FI — The internal deletion routine that performs the physical removal of forecast item rows, and corresponding amount detail rows, once the qualifying records have been identified by the driving cursor.
  • ARPR_LOG — A diagnostic logging utility. It writes trace messages such as the purge-through date and archive flag to the concurrent program log, and is the routine matched when users search for "arpr_log."
  • ARPR_OUT — The companion output routine used to emit formatted messages to the concurrent request output file.

The package also declares error-handling variables (x_err_stack, x_err_stage, x_err_code) consistent with the standard Oracle Projects purge API error convention.

Tables Accessed

The package reads from and writes to the following APPS synonyms:

  • PA_FORECAST_ITEMS and PA_FORECAST_ITEM_DETAILS — the primary transactional tables holding unassigned time forecast items and their detail rows; these are queried for identifiers and purged.
  • PA_FRCST_ITEMS_AR and PA_FRCST_ITEM_DTLS_AR — the archive shadow tables populated when the archive flag is set.
  • PA_FI_AMOUNT_DETAILS and PA_FI_AMOUNT_DETAILS_AR — amount detail records and their archive counterpart, deleted or copied alongside the forecast items.
  • PA_PROJECTS_ALL — used to associate forecast items with their owning projects, including the project-ID ordering added for bug 5870223.
  • PA_PURGE_BATCHES_S — the sequence source for generating a purge batch identifier that groups a single purge run.
  • PA_PURGE_PRJ_DETAILS — records the detail of each purge batch.
  • PA_IMPLEMENTATIONS — read to confirm the Projects installation context.
  • DUAL and PLITBLM — used for PL/SQL table operations and single-row selections.

Usage Notes

PA_PURGE_UNASGN_FI is designed to be invoked as a concurrent program, where the archiving flag and purge-through date are supplied as runtime parameters. The p_txn_to_date parameter is expected to be null when the purge batch targets active projects, and populated when purging through a specific historical cutoff. The standard call signature returns errbuf and retcode outputs, making it compatible with the Oracle Concurrent Manager's error-reporting convention. Because the package is not referenced by other APIs, custom code should call PA_FORECASTITEM directly and must supply a valid canonical date string. The ARPR_LOG calls embedded throughout the execution path make it straightforward to monitor progress through the concurrent request log when diagnosing long-running or failed purge runs.