Access User Extension through Scheduler

4.1.2.2.5 Access User Extension through Scheduler

You can access the User Extension using the Scheduler service.

To access User Extension using the scheduler service:

From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Batch. For more details, see Define Batch.
From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Task. For more details, see Define Tasks.
1. Task Type: REST
2. Component: Select Execute Custom PLSQL.
3. Under Task Parameters, select/enter the following:
  1. CustomPLSQL Definition: Select the relevant user extension function.
  2. CustomPLSQL Params: Enter the required parameters with comma separator. For example, USD,200.
    When executing this function the parameter will be assigned to the selected function as show below. Its mandatory to develop user-extensions with BatchID and MisDate as the first 2 parameter.
    
    For example: Given the below function signature
```
create or replace FUNCTION FNUPDATERECORD (BatchID Varchar2,
                                                            MisDate Varchar2,
                                                            vCurrency varchar2,
                                                            vBalance number) return number is
```
    The wrapper will be created in the following fashion:
```
DECLARE
                batchid     VARCHAR2(32767) := 'user_extension_2024-09-30_16';
                misdate     VARCHAR2(32767) := '20240930';
                vCurrency    VARCHAR2(32767) := 'USD';
                vBalance     number := '100';
                vreturn     NUMBER(30);
BEGIN
                vreturn := fnupdaterecord(
                batchid     => batchid,
                misdate     => misdate,
                vCurrency    => vCurrency,
                vBalance    => vBalance);
END;
```
Save the Task.
From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Execute Batch.
From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Monitor Batch. For more information, see Monitor Batch.
Select the Batch and then select the MISDATE and the Batch name. Select the latest execution and click Start Monitor.
The UI displays the Status of the batch.