Request for SQL/OTBI to Extract Scheduled Process Parameters (ESS)
Details:
We are looking for a way to extract Scheduled Process details (ESS), specifically the following information that is visible in the UI for processes such as Calculate Accruals and Balances:
- Process Header Information
- Process ID
- Process Name
- Submitted By
- Start Time / End Time
- Status
- Parameter Names with Values (as displayed in the UI)
- Example:
- Effective Date = 2025-07-31
- Absence Plan = UAE PS Annual Leave
- Business Unit = UAE PS BU
- etc.
- Example:
- All Parameter Values (ARGUMENT1, ARGUMENT2 … ARGUMENT20)
- Example:
- ARGUMENT2 = 2025-07-31
- ARGUMENT4 = UAE PS Annual Leave
- ARGUMENT9 = 300000264691201
- etc.
- Example:
Tagged:
0