Search Results submit_all_reports




Overview
Explore in AI Chat

Overview

BEN_REOPEN_LER_CONC is an Oracle EBS Advanced Benefits (OLTP) concurrent-processing package owned by the APPS schema. Its purpose is to support the reopening of Life Event Records (LERs) in bulk. In Oracle Advanced Benefits, a life event (such as marriage, birth, or a change in employment status) creates a Life Event Record that drives eligibility and enrollment processing for a participant. When a life event has already been processed and closed but must be recalculated or re-evaluated — for example, because upstream data was corrected or a retroactive change was loaded — the affected LERs must be reopened so that Ben

Use the following package API to create a Life Event: ben_life_event_api. Once the life event is created, you may use this process to reopen a life event to allow reprocessing. Use this process to reprocess a life event for a person or a group of persons. Activities such as loading, deleting, or backing out data trigger this process to reevaluate a person's eligibility/enrollment for a life event.

Use this process to reprocess the life event to recognize the changes.

This package implements the concurrent program logic that performs that reopen operation.

Key Procedures and Functions

  • PROCESS — The main driver procedure. It orchestrates the reopen of life event records based on the parameters supplied to the concurrent program, applying the appropriate person-action and benefit-action changes.
  • DO_MULTITHREAD — Handles the multithreaded execution path. Because the reopen operation can affect large populations, this procedure partitions the work so multiple worker processes can run in parallel, improving throughput for high-volume requests.
  • SUBMIT_ALL_REPORTS — Submits the associated report/request output, typically the post-processing reports that summarize which life events were reopened and any resulting errors. The ETRM documents three procedures; no parameter lists are published, so exact signatures are not reproduced here.

Tables Accessed

  • BEN_LER_F — The Life Event Records base table; this is the primary object whose rows are reopened and reset for reprocessing.
  • BEN_PER_IN_LER — Links participants to life events; used to identify which persons are affected.
  • BEN_BENEFIT_ACTIONS and BEN_PERSON_ACTIONS — Define the benefit and person action types applied to the records during the reopen.
  • BEN_BATCH_RANGES — Supplies the range-based partitioning used by the multithreaded path.
  • PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — Provide person and assignment context, driving eligibility determination for the affected population.
  • HR_SOFT_CODING_KEYFLEX — Used when soft coding is relevant to the processing set.
  • PLITBLM — The PL/SQL index-by table library global used internally by the concurrent packages.

Usage Notes

BEN_REOPEN_LER_CONC is normally invoked through the concurrent manager rather than called directly from forms or custom code. The ETRM dependency listing shows that the package references BEN_PERSON_ACTIONS and is referenced only by itself, confirming it is a self-contained concurrent program implementation. Because it is an "OTHER"-classified API with no published signature, direct invocation from custom PL/SQL is not supported and the documented interface — submitting the corresponding concurrent program — should be used instead. The multithread and submit-reports procedures indicate that production usage involves a submit phase, parallel worker execution, and a reporting phase. Reprocessing of opened life events should be run when data corrections or retroactive loads make previously processed LERs invalid.