How to run the Concurrent Program from Backend.

How to Run Concurrent Program from Backend.

Now we are going to learn about how to run the concurrent program from backend.

We can run the concurrent program from backend using FND_REQUEST.Submit_Request API.

Call the FND_REQUEST.Submit_Request and pass the necessary parameters.

Application     -           Give the application short name in which application your con 

 program was registered.

            Program           -           Give the short name of the concurrent program.

            Description      -           Give the name of the concurrent program.

            start_time        -           Null.

            sub_request     -           FALSE

            argument1       -           Give the parameters.

Declare

Request_id NUMBER := 0;

Begin

            Request_id := FND_REQUEST.Submit_Request(application => 'XX'

                                    , program => 'XX_PLANNER_CSD_UPDATE'

                                    , description => 'Planner csd update data load'

                                    , start_time => NULL

                                    , sub_request => FALSE

                                    , argument1 => p_file_path

                                    );

            IF Request_id = 0    THEN

                        DBMS_OUTPUT.PUT_LINE( 'Request submission For this store FAILED' );

            ELSE 

  DBMS_OUTPUT.PUT_LINE( 'Request submission For this store SUCCESSFUL' );

            END IF;

End;

commit;