Monday 2 December 2019

Create Concurrent Program Executable From Backend In Oracle Apps Ebs System



/*==================================================
CREATE CONCURRENT PROGRAM EXECUTABLE FROM BACKEND in Oracle apps EBS System
===================================================*/
SELECT * FROM FND_APPLICATION_VL
WHERE 1=1
AND APPLICATION_SHORT_NAME LIKE 'XXCUST'


DECLARE
   v_executable   VARCHAR2 (50) := 'XXAA_AR_AGING';
BEGIN
   fnd_global.apps_initialize (user_id           => 1318,
                               resp_id           => 21623,
                               resp_appl_id      => 660
                              );                           
   fnd_program.executable (executable               => 'XXAA Ar Aging Report',                         
                           application              => 'XXCUST Custom Application',
                           short_name               => 'XXAA_AR_AGING',
                           execution_method         => 'Oracle Reports',
                           execution_file_name      => 'XXAA_AR_AGING'
                          );                       
   COMMIT;
   DBMS_OUTPUT.put_line (   'Succeefully created executable name is '|| v_executable );
END;


SELECT * FROM fnd_executables
 WHERE execution_file_name = 'XXAA_AR_AGING'
   

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...