Search Results psprep_init

Overview

PSP_CREATE_EFF_REPORTS is a PL/SQL package owned by the APPS schema that supports the Oracle E-Business Suite effort reporting process, also referred to as Personnel Status and Payroll (PSP) effort reporting. Effort reports are the mechanism by which an organization certifies the distribution of an employee's compensated time across sponsored projects, awards, and indirect cost activities. The package is declared with AUTHID CURRENT_USER, meaning its database objects and privileges are resolved against the invoking user's schema rather than the package owner, which is typical for EBS packages that are called from concurrent programs and forms running under application session identity.

Within ETRM, this package is classified as an OTHER API. It provides the procedural engine used to build, populate, validate, and archive effort reporting information at the conclusion of a payroll or effort processing cycle. The header revision marks preserved in the source (120.4, dated 2006) confirm it is a long-standing component carried forward into the 12.1.1 and 12.2.2 releases without structural change.

Key Procedures and Functions

• PSPREP_INIT — Initialization procedure invoked at the start of effort report processing. It establishes the processing context for a given payroll action, preparing the internal state and global variables that subsequent procedures in the same run depend upon.
• EFFORT_ARCHIVE — Performs the archival of effort reporting records. This is the procedure directly associated with the "effort_archive" search term and is the archive counterpart to report generation.
• CREATE_EFFORT_REPORTS — The primary report creation procedure. It carries the standard EBS concurrent program out parameters errBuf and retCode alongside the payroll action identifier, request identifier, and chunk number, indicating it is designed to run as a concurrent program with parallel chunk processing. It orchestrates the generation of effort report records.
• POPULATE_EFF_TABLES — Based on the CREATE_EFFORT_REPORTS signature and exposes errBuf, retCode, the payroll action identifier, request identifier, chunk number, and a p_supercede_mode parameter. The supercede flag indicates the procedure supports regeneration of effort reports that supersede previously produced versions.
• EFFORT_ASG_ACTION_CODE — Operates over a range of persons defined by start and end person identifiers and a chunk number, applying action codes to effort assignment records. This supports chunked parallel processing of the assignment population.
• POPULATE_ERROR_TABLE — Captures errors encountered during population and validation, scoped by person range, minimum effort report identifier, retry request identifier, mode, and match level. Writes to the report errors tables so failures can be reviewed and retried.
• VALIDATE_PTAOE — A validation routine referenced in the documented metadata. Its name reflects the PTAOE effort reporting construct (Project, Task, Award, Organization, Expenditure type), and it is used to validate effort line distributions against valid PTAOE combinations before reports are finalized.

Tables Accessed

The package reads and writes a broad set of EBS tables through APPS synonyms. Concurrent processing infrastructure is consulted via FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS, allowing the package to resolve request parameters and log status. Payroll and assignment context is drawn from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, and PAY_TEMP_OBJECT_ACTIONS. Employee identity comes from PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F.

Project validation relies on PA_PROJECTS_ALL. The core effort reporting data resides in PSP_EFFORT_REPORTS_S, PSP_EFF_REPORTS, PSP_EFF_REPORT_DETAILS, and PSP_EFF_REPORT_DETAILS_S, which hold report headers and line-level effort detail. PSP_ADJUSTMENT_LINES stores adjustments applied to reported effort, while PSP_REPORT_ERRORS and PSP_REPORT_ERRORS_S record exceptions surfaced by POPULATE_ERROR_TABLE.

Usage Notes

PSP_CREATE_EFF_REPORTS is not intended for direct ad hoc invocation. It is driven by the Effort Reporting concurrent programs in Oracle Grants/Projects, which pass the payroll action identifier, request identifier, and chunk number used to partition work across parallel workers. The errBuf/retCode convention confirms concurrent program registration.

Initialization is performed by PSPREP_INIT, followed by the populate and validate steps, then CREATE_EFFORT_REPORTS to produce final output; EFFORT_ARCHIVE is used when effort data must be moved out of active reporting tables. The package is referenced by one other package, indicating it is a mid-level component in the PSP effort reporting call stack rather than a top-level entry point. Customizations should avoid modifying the package directly because it is an Oracle-shipped object subject to patching in 12.1.1 and 12.2.2; extensions are best implemented by wrapping the documented procedures or by consuming the populated effort reporting tables directly.