5.1.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:

1. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Define Batch. For more details, see Define Batch.
2. 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.
         1. When function has only BatchId and MisDate as parameters:
            For Example,

            FUNCTION FN_UPDATE_TRANSFERRATE_CUSTOM (BatchID varchar2,
                                                       MisDate varchar2) RETURN NUMBER

            then CustomPLSQL Params text field will have the following value:

            BATCH_RUN_ID_01,20250408

         2. When function has BatchId and MisDate and other optional Parameter:
            For Example

            FUNCTION FN_UPDATE_TRANSFERRATE_CUSTOM (BatchID varchar2,
                                                       MisDate varchar2,
                                                       LEGAL_ENTITY varchar2,
                                                       CURRENCY_CODE varchar2) RETURN NUMBER

            then CustomPLSQL Params text field will have the following value:

            BATCH_RUN_ID_01,20250408,LE1,USD

3. Save the Task.
4. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Execute Batch.
5. From the LHS menu, navigate to Operations and Processes, select Scheduler, and then select Monitor Batch. For more information, see Monitor Batch.
6. 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.