Search Results cf_accts_descformula

Overview

The APPS.JA_JAINJVR_XMLP_PKG package is a report logic package in Oracle E-Business Suite, associated with the Oracle XML Publisher (BI Publisher) concurrent program infrastructure. Its naming convention — the _XMLP_PKG suffix combined with the source file JAINJVRS.pls — identifies it as the PL/SQL package that supports a Java/JA-module journal voucher report. It belongs to the JA (Asia/Pacific Localizations) product family and is used to produce the Journal Voucher Report, extracting journal header and line data alongside account combination descriptions.

The package exposes a set of public package variables that map to concurrent program report parameters, including from/to dates, journal voucher number, set of books identifier, source, chart of accounts identifier, and column value. These parameters drive the report query and its formatting logic. The package is owned by APPS and classified as OTHER, indicating it is an internal support package rather than a published API.

Key Procedures and Functions

The package documents seven procedures and functions. The parameter lists below are intentionally described only by purpose, as the full signatures should be verified against the deployed source.

• CF_ACCOUNTFORMULA — A report formula function that resolves the account combination for a given code combination identifier, returning the formatted account string used in the journal voucher output.
• CF_SOB_NAMEFORMULA — A report formula function that returns the set of books (SOB) name for display on the report header.
• CF_ACCTS_DESCFORMULA — A report formula function that returns the account description text associated with a code combination identifier. This is the object directly relevant to the search term cf_accts_descformula, which appears to be an underscore-normalized or truncated reference to this function name.
• BEFOREREPORT — The standard XML Publisher before-report trigger, used to initialize package state and derive values prior to report execution.
• AFTERPFORM — The after-parameter-form trigger, invoked once the concurrent program parameters have been submitted, typically used to validate or transform parameter values.
• AFTERREPORT — The after-report trigger, invoked at the conclusion of report generation for cleanup or final formatting.
• M_2_GRPFRFORMATTRIGGER — A group format trigger returning a numeric value, controlling conditional formatting of a report group section.

Tables Accessed

The package reads from the following tables via APPS synonyms:

• GL_JE_HEADERS and GL_JE_LINES — the primary journal entry header and line tables supplying the voucher data.
• GL_CODE_COMBINATIONS — provides account combination values used by the account and description formulas.
• FND_ID_FLEX_SEGMENTS and FND_SEGMENT_ATTRIBUTE_VALUES — supply key flexfield segment definitions and attribute settings needed to render account descriptions.
• FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS — used to resolve concurrent program context and request metadata for the report run.

Usage Notes

This package is invoked automatically by the XML Publisher concurrent program that generates the Journal Voucher Report; it is not intended for direct invocation by end users. The formula functions (CF_*) are referenced from the report's RTF or data template through XML Publisher formula calls, while the trigger functions integrate with Oracle Reports or XML Publisher runtime events. No other packages reference this package, confirming it sits at the top of its call hierarchy and functions purely as report-support code. Customizations should be avoided; the object is marked noship in its header, indicating it is not shipped as a standalone deliverable and may change between patch levels in 12.1.1 and 12.2.2.