Search Results period2_pod_p

Overview

FA_FAS444_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It is the generated database-side support package for the Oracle Assets XML Publisher (BI Publisher) report FAS444, which is part of the fixed asset reporting suite. In EBS 12.1.1 and 12.2.2, Oracle Reports-based concurrent programs are frequently re-hosted against XML Publisher templates. When this migration occurs, Oracle's report generation tooling emits a supporting PL/SQL package that (a) declares the package-level variables that hold the concurrent program's lexical parameters, (b) exposes the report's data model group formulas as callable functions, and (c) implements the BeforeReport and AfterReport anchors used before and after the report query is executed. The package is therefore not business logic in its own right, but the runtime contract between the XML Publisher template, the report's data model, and the concurrent manager. Users searching for period1_pcformula are typically investigating how the report derives the "period 1" accounting period and its associated fiscal context.

Key Procedures and Functions

The package declares fifteen documented program units in two distinct families.

• REPORT_NAMEFORMULA — derives the display name of the report, typically combining company name with the report title for the report header.
• BEFOREREPORT — the standard Oracle Reports BeforeReport trigger implementation; it runs prior to the main query and is used to resolve parameter values, initialize state, and populate package globals such as the depreciation period and fiscal year fields.
• AFTERREPORT — the companion trigger executed after the report query completes; used for cleanup and final computation.
• PERIOD1_PCFORMULA — the formula that computes the value behind the period1_pcformula search term. It returns a Number and is the mechanism by which the report resolves the "period 1" period counter or period identifier presented to the user.
• PERIOD2_PCFORMULA — the equivalent formula for the second accounting period, allowing the report to present comparative period data.

The remaining ten functions are accessor functions suffixed with _p, which expose the value of the corresponding package global to the report layout template: ACCT_BAL_APROMPT_P, PERIOD1_POD_P, PERIOD1_PCD_P, PERIOD1_FY_P, PERIOD2_POD_P, PERIOD2_PCD_P, PERIOD2_FY_P, RP_COMPANY_NAME_P, RP_REPORT_NAME_P, and RP_BAL_LPROMPT_P. These return the period open date (POD), period close date (PCD), fiscal year, and the various prompt and label strings used in the report output.

Tables Accessed

Two tables are referenced through APPS synonyms:

• FA_DEPRN_PERIODS — the Oracle Assets depreciation period definition table. It is the authoritative source for the period name, period open and close dates, and fiscal year that the PERIOD1 and PERIOD2 accessors expose. The Period1_POD, Period1_PCD, and Period1_FY globals are populated from this table.
• FND_CONCURRENT_REQUESTS — the standard concurrent request table, queried to resolve the request identifier and its runtime context for the currently executing request (correlated with the P_CONC_REQUEST_ID parameter).

Usage Notes

FA_FAS444_XMLP_PKG is invoked exclusively by the concurrent program that runs the FAS444 XML Publisher report. It is not a general-purpose API; the ETRM metadata records zero other packages referencing it. The package is called by:

• The concurrent manager, which executes the report through the XML Publisher engine, causing BeforeReport and AfterReport to fire and the formula functions to be evaluated during data model processing.
• The XML Publisher RTF or XSL-FO template, which calls the _p accessor functions to render period dates, fiscal years, company name, report name, and prompt strings into the report layout.

Because the package is declared AUTHID CURRENT_USER, it executes with the privileges of the calling session. Customizations should be limited to the underlying XML Publisher template or to a copied, renamed report definition; direct modification of the generated package is overwritten whenever the report is regenerated. In 12.1.1 and 12.2.2 the header comment indicates a last revision of 120.1 (2009), so the logic is stable across both releases. When diagnosing period-related output issues, PERIOD1_PCFORMULA and PERIOD2_PCFORMULA, together with the FA_DEPRN_PERIODS rows they resolve, are the first items to inspect.