Search Results je_jenogeim_xmlp_pkg




Overview
Explore in AI Chat

Overview

JE_JENOGEIM_XMLP_PKG is an Oracle EBS package under the APPS schema that serves as the supporting PL/SQL package for the "Journal Entry - No GEI" (JENOGEIM) XML Publisher concurrent program. The package is an XML Publisher report package (indicated by the _XMLP_PKG suffix), auto-generated and maintained as part of the Oracle E-Business Suite General Ledger journal reporting infrastructure. Its business purpose is to generate the data set and runtime parameters for a sub-ledger journal entries report, exposing account flexfield segments, ledger context, and period information for rendering in an XML Publisher template.

The package encapsulates report parameters such as the concurrent request ID, ledger identifier, report type, period, and output filename, along with structure and accounting flexfield configuration. The header records a last modification in the 120.1 file revision, consistent with the 12.1.1 release lineage and carried forward into 12.2.2 under the same ownership and classification (OTHER).

Key Procedures and Functions

The package documents twelve callable units, all public within the package specification:

  • BEFOREREPORT — Executed prior to report data retrieval; initializes session and report setup logic.
  • AFTERREPORT — Executed after report generation to finalize and clean up session state.
  • B_PERIOD_ENDFORMATTRIGGER — A format trigger associated with the period-end field, controlling conditional display or formatting in the report layout.
  • CF_REPORT_TITLEFORMULA — A formula column returning the dynamically constructed report title.
  • CF_DATEFORMULA — A formula column returning the report run date or effective date value.
  • STRUCT_NUM_P — Returns the accounting flexfield structure number (defaulted to '101').
  • SET_OF_BOOKS_NAME_P — Returns the ledger/set of books name resolved at runtime.
  • SELECT_ALL_P — Returns the concatenated account segment expression used to build the complete account combination string across segments 1 through 30.
  • WHERE_FLEX_P — Returns the flexfield WHERE clause predicate. In the shipped source this defaults to a range restriction on SEGMENT11, reflecting the configurable filtering applied to a specific balancing or cost center segment.
  • ORDERBY_ACCT_P — Returns the account ordering clause (defaulted to CC.SEGMENT10).
  • PRECISION_P — Returns the numeric precision used for monetary amounts in the report.
  • FUNC_CURRENCY_P — Returns the functional currency code used for reporting.

These getter functions allow the XML Publisher data template and the report's SQL statement to consume package-level variables consistently across the extraction and layout phases.

Tables Accessed

The documented table references are limited to two APPS synonyms:

  • FND_CURRENCIES — Read to resolve functional and reporting currency attributes, supporting FUNC_CURRENCY_P and precision handling.
  • DUAL — Used for single-row evaluations and parameter initialization queries.

The primary accounting data is supplied through the report's embedded SQL and ledger schema; the package itself acts primarily as a parameter and formatting container rather than a direct data reader.

Usage Notes

This package is not an API and is not referenced by any other documented packages. It is invoked exclusively by its parent XML Publisher concurrent program during report submission. The WHERE_FLEX variable is of particular interest to implementers: it is the mechanism by which the report constrains flexfield segment ranges, and the shipped default should be reviewed and, where necessary, modified in a custom copy to match the site's chart of accounts. Any change to this default is overwritten by patching unless the package is cloned into a custom application. Because the package is classified OTHER and marked noship in its header, it should be treated as Oracle-owned and subject to upgrade impact; extensions should be made through a copied package and a corresponding custom concurrent program definition.