Search Results bis_concurrent_manager_pvt




Overview
Explore in AI Chat

Overview

APPS.BIS_CONCURRENT_MANAGER_PVT is a private PL/SQL API packaged in BISVCONB.pls that centralizes the management of Oracle E-Business Suite concurrent requests on behalf of the BIS (Business Intelligence System / Daily Business Intelligence) product family. Its stated purpose, per the source header, is to serve as the "Private API for managing concurrent requests." In the Oracle EBS 12.1.1 and 12.2.2 releases, the package underpins the scheduling, submission, monitoring, and resubmission logic used by DBI alerts and related concurrent programs, shielding callers from the lower-level FND concurrent manager tables.

The package is classified as PVT (private), indicating it is intended for internal consumption by other BIS components rather than direct customer invocation. Its history header records continuous maintenance from June 2000 through November 2005, addressing bugs relating to resubmission intervals, alert re-scheduling while running, next-run date formatting, and DBI actuals for prior time periods.

Key Procedures and Functions

  • SET_REPEAT_OPTIONS — Configures the repeat/resubmission attributes of a scheduled concurrent request, including interval and unit handling. This procedure relates directly to the documented fix (bug 2834133) that returns a "ONCE" frequency with the end date set equal to the start date when the frequency is one-time only.
  • GET_FREQ_DISPLAY_UNIT — Returns the display unit associated with a schedule frequency for presentation on screen.
  • FORMAT_SCHEDULE_FREQ_UNIT — Formats the frequency unit value into a user-readable representation used by the UI.
  • GET_REQUEST_SCHEDULE_INFO — Retrieves schedule details for a given request, supporting the display of next run date and interval information.
  • SUBMIT_CONCURRENT_REQUEST — Submits a concurrent request through the BIS-managed path.
  • MANAGE_ALERT_REGISTRATIONS — Handles alert registration lifecycle; documented fixes prevent re-scheduling an alert that is already running (bug 2834155).
  • GET_ALL_REQUESTS — Returns the set of requests relevant to BIS processing.
  • GET_PMF_CONCURRENT_PROGRAM_ID — Resolves the concurrent program identifier for PMF-related programs.

Tables Accessed

  • FND_CONCURRENT_REQUESTS — The primary repository for request state, scheduling, and resubmission data; read and updated to manage request lifecycles.
  • FND_CONCURRENT_PROGRAMS — Used to resolve program definitions and identifiers.
  • FND_APPLICATION — Supplies application context for program resolution.
  • PLITBLM — The PL/SQL table-to-database interface table, used for bulk operations.

Usage Notes

Because BIS_CONCURRENT_MANAGER_PVT is private, it is invoked indirectly. Typical call paths include BIS/DBI alert definition forms, which rely on SET_REPEAT_OPTIONS and the schedule-info functions to render and persist scheduling choices, and concurrent programs that submit dependent or chained requests. The package is referenced by five other packages, confirming its role as a shared internal utility. Custom code should avoid direct calls; instead, customers should use supported public APIs, as the PVT signature may change between patch levels.