Search Results ben_plan_design_copy_process




Overview
Explore in AI Chat

Overview

BEN_PLAN_DESIGN_COPY_PROCESS is an Oracle Applications (APPS) PL/SQL package within the Oracle Advanced Benefits (BEN) product family. Its purpose is to support the plan design copy functionality, which allows implementers and administrators to duplicate an existing benefits plan design configuration — including its associated eligibility, rate, and coverage definitions — into a new plan design, thereby reducing manual reconfiguration effort during implementation or when rolling out similar plans. The package is classified as an "OTHER" API and is not part of the public external API surface; it is an internal processing engine invoked by the Benefits configuration and copy infrastructure.

The package's role is largely orchestration and post-processing: it coordinates the copy operation across the Benefits and Public Sector Human Resources (PQH) copy entity framework, records copy results, compiles any modified Fast Formulas, and logs processing activity into the standard BEN process log. It is a supporting package rather than a user-facing entry point.

Key Procedures and Functions

  • PROCESS — The main driver procedure. It executes the plan design copy workflow, handling entity iteration and result recording through the PQH copy entity tables and BEN copy results table. It also writes status and error information to the process log.
  • COMPILE_MODIFIED_FF — Responsible for recompiling Fast Formulas that were modified as a result of the copy operation. Because copied plan designs may reference or produce formula-attribute variations, this procedure ensures formula validation by compiling against FF_FORMULA_TYPES. This prevents runtime failures caused by stale or invalid formula definitions.

No additional procedures or functions are documented in the ETRM metadata; the package registers exactly two callable units.

Tables Accessed

  • BEN_COPY_ENTITY_RESULTS — Stores the outcome of each copied entity, providing traceability of successes and failures during the copy.
  • PQH_COPY_ENTITY_ATTRIBS — Holds attribute-level configuration for copy entities, consumed and/or updated during processing.
  • PQH_COPY_ENTITY_TXNS — Tracks copy entity transaction records that drive the overall copy operation.
  • FF_FORMULA_TYPES — Used to validate and compile modified Fast Formulas, ensuring type consistency.
  • PQH_PROCESS_LOG — Receives process logging entries for audit and troubleshooting.

Usage Notes

This package is invoked indirectly rather than through direct user navigation. It is typically triggered by the Benefits plan design copy concurrent process or from the Benefits configuration UI when a copy action is submitted. It is also referenced by BEN_PLAN_DESIGN_TXNS_API, indicating that the plan design transaction API calls into this package as part of its copy-related processing. Developers extending copy behavior should not call this package directly unless reproducing the standard copy workflow, as it assumes an established PQH copy entity transaction context. In 12.1.1 and 12.2.2, the package is VALID in the APPS schema. Custom code should prefer the documented public APIs (such as BEN_PLAN_DESIGN_TXNS_API) and treat BEN_PLAN_DESIGN_COPY_PROCESS as an internal implementation package. When troubleshooting copy failures, administrators should examine PQH_PROCESS_LOG and BEN_COPY_ENTITY_RESULTS for diagnostic detail.