Search Results apps_initialize_sysadmin

Overview

FND_JOBS_PKG is an Oracle E-Business Suite (EBS) PL/SQL package owned by the APPS schema. It belongs to the Application Object Library (FND) product family, which provides the underlying security, concurrent processing, and system administration infrastructure for the entire EBS application stack. The package is classified as an "OTHER" API under the ETRM documentation model, meaning it is a utility or internal helper package rather than a formally supported public interface.

The business function of FND_JOBS_PKG centers on job submission and system administration initialization. It provides EBS with a controlled mechanism for submitting standard concurrent programs and for initializing the SYSADMIN user environment. This is essential during setup, patching, and routine administration activities where specific jobs — such as menu compilation — must be launched programmatically rather than manually from the concurrent manager forms.

Key Procedures and Functions

The package exposes four documented program units, three of which are distinct named members (SUBMIT_MENU_COMPILE appears as both a function and a procedure overload).

• APPS_INITIALIZE_SYSADMIN — A procedure that initializes the runtime environment for the SYSADMIN user. It establishes the application context required before other package routines execute under system administrator credentials, ensuring correct security and responsibility context.
• SUBMIT_JOB — A function that submits a concurrent job for execution. It accepts the application short name, the concurrent program name, and an alternate program identifier, and returns a numeric job identifier. This allows callers to request standard EBS concurrent programs without navigating the Submit Requests form.
• SUBMIT_MENU_COMPILE — Documented twice: once as a function returning a varchar2 and once as a procedure. This routine triggers the menu compilation concurrent program, which regenerates the compiled menu structures used by the navigator and responsibility menus.

Tables Accessed

The package references several core FND tables through APPS synonyms, along with the DBMS_JOB built-in package.

• FND_APPLICATION — Resolves the application short name supplied to SUBMIT_JOB to its internal application identifier, which is required to locate the concurrent program.
• FND_RESPONSIBILITY — Provides responsibility context, likely to determine request group and security applicability for the submitted job.
• FND_USER — Used to validate and establish the submitting user context, particularly for the SYSADMIN initialization routine.
• DBMS_JOB — The Oracle database job scheduler package used to enqueue the actual background job submission.

These tables and the DBMS_JOB package are accessed to resolve identifiers, enforce security context, and physically queue work for the concurrent managers.

Usage Notes

FND_JOBS_PKG is typically invoked from three contexts within EBS 12.1.1 and 12.2.2:

• Concurrent program logic — Wrapper concurrent programs call SUBMIT_JOB to chain or schedule dependent requests.
• Forms and system administration — Administrative forms may invoke the package to compile menus after responsibility or menu changes.
• Custom code and installation scripts — Setup and patching routines use APPS_INITIALIZE_SYSADMIN and SUBMIT_MENU_COMPILE to bootstrap the environment and refresh menu structures.

Because the package is classified as OTHER rather than a public API, its signature should be treated as subject to change across releases. Customizations that reference FND_JOBS_PKG directly should verify availability in the target patch level. The package is referenced by two other packages, indicating use as a shared utility for job submission across the FND layer.