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 make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...