Access User Extension through Scheduler

5.1.2.5 Access User Extension through Scheduler

You can access the Customer PLSQL 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 PLSQL function.
  2. Consumer Group: There are 3 option which the user can select.
    1. High
    2. Medium
    3. Low
      The default selection is Medium. The use can choose the appropriate Consumer Group.
      
      Figure 5-1 Consumer Group
    When executing this function, the parameter will be assigned to the selected function as show below. It is mandatory to develop Customer PLSQL extensions with BatchID and MisDate as the first 2 parameters.
    
    For example: Given 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;
```
  3. CustomPLSQL Params: Enter the required parameters for selected PLSQL function. If there are multiple parameters use comma separator. For example: USD,200.
Save the Task.
From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Execute Batch. For more information, see 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.