Search Results business_groupformula

Overview

APPS.BEN_BENXSMRY_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Benefits Summary XML Publisher report, identified by the concurrent program short name BENXSMRY. Its purpose is to supply the data logic and report-level exit points required to render a consolidated summary of a participant's benefits elections — plan enrollments, coverage levels, dependents, beneficiaries, and associated costs — as BI Publisher (XML Publisher) output. The package is classified as OTHER in the ETRM repository, meaning it is a report-supporting component rather than a public, reusable API. In both Oracle EBS 12.1.1 and 12.2.2, packages of this naming convention (BEN__XMLP_PKG) are generated or provided to accompany the XML Publisher data template and report definition registered under the Benefits (BEN) application. The object is VALID and owned by APPS.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package. Their names indicate the roles they play in the concurrent program lifecycle and data assembly:

• VALUEFORMULA — Supplies a computed value for a report-level formula column, returning a derived measure used in the Benefits Summary output.
• BUSINESS_GROUPFORMULA — Returns the business group context for the report run, resolving the HR business group against which the benefits data is scoped so the query returns the correct legislative and plan data.
• TOTAL_PEOPLEFORMULA — Provides a count or aggregate of the people (participants) included in the report, used for summary or control totals.
• BEFOREREPORT — The standard XML Publisher concurrent program before-report trigger. It performs session initialization, resolves parameters, and sets context before the data model executes.
• AFTERREPORT — The standard after-report trigger, used for cleanup or finalization once the report output has been produced.

Parameter lists are not documented in the ETRM extract and are therefore not reproduced here; the standard XML Publisher signature conventions apply to the before/after report hooks.

Tables Accessed

The ETRM metadata records no explicit tables referenced through APPS synonyms for this package. In practice, a Benefits Summary XML Publisher support package draws on Benefits and HR tables via APPS synonyms — typically participant and enrollment data (for example BEN_PTIP_* , BEN_PER_IN_ENRLMENTS_F, and related plan, option, and coverage tables) together with HR person and assignment data. Because the documented dependency list does not enumerate these objects, any table-level lineage should be verified directly in the database against the package body rather than assumed from this extract.

Usage Notes

BEN_BENXSMRY_XMLP_PKG is not intended for direct invocation from custom code. It is invoked indirectly by the Oracle XML Publisher engine when the Benefits Summary concurrent program runs: the BEFOREREPORT hook fires at the start of the run, the formula functions are called by the data template to populate calculated columns, and AFTERREPORT fires at completion. The ETRM metadata shows the package references SYS.STANDARD and is referenced only by itself (the package spec/body pair), confirming it is a leaf component with no downstream dependents among other APPS packages. Administrators and developers diagnosing Benefits Summary output issues — missing participants, incorrect totals, or wrong business group scoping — should inspect the results of VALUEFORMULA, BUSINESS_GROUPFORMULA, and TOTAL_PEOPLEFORMULA, and review the concurrent program parameters and XML Publisher template assignment rather than calling the package manually.