Search Results p_period2

Overview

APPS.FA_FAS740_XMLP_PKG is the Oracle E-Business Suite package body that backs the Oracle Assets report commonly identified as the Asset Reclassification Report (internally FAS740). It belongs to the Oracle Assets (FA) module, which is registered under application ID 140, and follows the standard XML Publisher report-helper pattern used throughout EBS 12.1.1 and 12.2.2. The package does not perform asset transactions itself; instead it acquires the runtime context needed by the report — the selected asset book, the accounting flexfield structure, the book currency and precision, the distribution source book, and the reporting period range — and exposes those values to the report layout through package-level variables and "P_" accessor functions. In the ETRM 12.2.2 inventory it is classified as API classification OTHER, is owned by APPS, and is referenced by no other packages, confirming that it is a standalone report-support unit rather than a shared library.

The variable name p_period2, which is the term most frequently searched against this object, is the concurrent program parameter that supplies the "to" period of the report range.

Key Procedures and Functions

The package metadata documents eleven procedures and functions:

• BOOKFORMULA — Validates the book entered at run time and resolves the derived book attributes. The excerpt shows it querying FA_BOOK_CONTROLS, GL_SETS_OF_BOOKS, and FND_CURRENCIES, then populating the accounting flex structure, currency code, precision, and distribution source book for downstream formulas.
• REPORT_NAMEFORMULA — Accepts the company name and derives the report title from the concurrent program definition. It captures the concurrent request ID, retrieves the program that was submitted, and strips the " (XML)" suffix from the user-facing program name. It also assigns the period range, setting Period_From from P_PERIOD1 and Period_To from P_PERIOD2. If the lookup fails, it falls back to the literal title "Asset Reclassification Report".
• BEFOREREPORT — Standard XML Publisher before-report trigger used to initialise report-level state prior to data retrieval.
• AFTERREPORT — Standard after-report trigger used for cleanup and finalisation once the report output has been produced.
• ACCOUNTING_FLEX_STRUCTURE_P — Accessor returning the accounting flexfield structure identifier resolved by BOOKFORMULA.
• CURRENCY_CODE_P — Accessor returning the currency code of the selected book's set of books.
• DIST_SOURCE_BOOK_P — Accessor returning the distribution source book associated with the selected book.
• RP_COMPANY_NAME_P — Accessor returning the company name captured during report name resolution.
• RP_REPORT_NAME_P — Accessor returning the resolved report name for display in the report header.
• PERIOD_FROM_P — Accessor returning the beginning period of the report range, sourced from P_PERIOD1.
• PERIOD_TO_P — Accessor returning the ending period of the report range, sourced from P_PERIOD2.

Tables Accessed

• FA_BOOK_CONTROLS — Read to retrieve the book type code, accounting flexfield structure, distribution source book, and set of books for the book entered by the user.
• FND_CURRENCIES — Read to obtain the precision of the book currency, which governs rounding in the report output.
• FND_CONCURRENT_REQUESTS — Read to link the current concurrent request to its concurrent program definition so the report title can be derived.
• GL_SETS_OF_BOOKS — Joined in the excerpt to supply the currency code of the book's set of books, and present in the metadata as a referenced synonym alongside the tables above.
• FND_CONCURRENT_PROGRAMS_VL — Queried by REPORT_NAMEFORMULA to obtain the user concurrent program name. All access is read-only.

Usage Notes

The package is invoked exclusively by the Oracle Assets concurrent program for FAS740. It is not called from Oracle Forms and is not referenced by any other package, so customisations should be limited to the report layout or to the concurrent program parameters rather than to the package itself. Because the package is compiled into APPS, any modification requires a valid APPS schema connection and should be followed by recompilation of dependent objects. Analysts investigating p_period2 should understand that it only feeds Period_To and does not participate in validation logic; the value entered at submission determines the closing period of the report. Tuning considerations centre on the book lookup in BOOKFORMULA, which is a single-row query, and on the concurrent request lookups in REPORT_NAMEFORMULA, which are keyed by request ID and program application ID 140.