Search Results print_header_info

Overview

PSA_FA_MASS_ADDITIONS is an APPS-owned PL/SQL package body classified as OTHER within the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. It supports the Projects (PSA) to Fixed Assets (FA) integration flow, specifically the processing of mass additions that originate from capitalized project costs and are transferred into Oracle Assets as asset addition lines. The package operates against the FA_MASS_ADDITIONS interface table, which holds the intermediate records representing expense or capital transactions awaiting asset creation.

The body is instrumented with the FND_LOG framework, declaring standard logging levels (STATEMENT, PROCEDURE, EVENT, EXCEPTION, ERROR, UNEXPECTED) and a common path prefix of 'PSA.PLSQL.PSAFAUCB.PSA_FA_MASS_ADDITIONS.'. This instrumentation indicates the package is intended for diagnostic tracing of mass addition processing, asset type classification, and reporting output. The package is self-contained with respect to ETRM references, as it is not referenced by any other documented package.

Key Procedures and Functions

• UPDATE_ASSET_TYPE — The principal processing routine. Its purpose is to select mass addition records that correspond to a specified asset book, chart of accounts, and account ranges, and to update the asset type classification (for example, EXPENSED) on qualifying records. The procedure constructs a dynamic WHERE clause through FA_RX_FLEX_PKG.FLEX_SQL using an application ID (101) and the GL# key flexfield structure, then builds and executes a dynamic cursor over FA_MASS_ADDITIONS joined to GL_CODE_COMBINATIONS to resolve the distinct MASS_ADDITION_ID values that satisfy the account and posting-status criteria.
• PRINT_HEADER_INFO — A reporting helper invoked at the start of processing (line 38 of the source) to emit header information describing the run context. It prints the asset book and the capital and CIP account ranges supplied to the calling procedure, providing an audit trail of the parameters that governed the update. This is the routine associated with the user's search term.
• PRINT_MASS_ADDITION_DETAILS — A reporting helper that formats and outputs the detail rows of the mass additions being processed, giving operators visibility into the individual records affected by the update.
• PRINT_REPORT_HEADER — A reporting helper that produces the report-level header for the output generated during mass addition processing.

Tables Accessed

The package references a single documented table through its APPS synonym: FA_MASS_ADDITIONS. It reads this table to identify candidate records by asset type and posting status and to match payables code combinations, and it writes updated asset type values back to the qualifying rows. The dynamic SQL additionally joins FA_MASS_ADDITIONS to GL_CODE_COMBINATIONS on PAYABLES_CODE_COMBINATION_ID to resolve account ranges constructed by FA_RX_FLEX_PKG.FLEX_SQL; GL_CODE_COMBINATIONS is a supporting reference rather than a documented table dependency of this package.

Usage Notes

PSA_FA_MASS_ADDITIONS is typically invoked from the Oracle Projects to Oracle Assets mass addition workflow, where capitalized project expenditures must be reclassified before they are posted to asset books. Because the package exposes no documented public API outside its four procedures and is not referenced by other packages, it is most commonly driven by concurrent programs or internal project-to-asset integration logic rather than by direct customer calls. The FND_LOG instrumentation allows administrators to enable statement- and procedure-level tracing when diagnosing update failures. The presence of PRINT_HEADER_INFO, PRINT_MASS_ADDITION_DETAILS, and PRINT_REPORT_HEADER confirms that the package also produces formatted output, most likely through DBMS_OUTPUT or the concurrent manager log file, making it suitable for review of mass addition processing results during period-end asset transfers.