Total Pageviews

Sunday, 16 July 2023

EBS : API to Add / Remove Concurrent Program from Request Group in Oracle Apps (r12)

How to ADD / Remove concurrent 

Program using API in Request Group

 

Remove Concurrent Request from request Group

BEGIN

begin

    apps.fnd_program.remove_from_group

           (PROGRAM_SHORT_NAME  => 'XXTECHARDS_PROG',

            PROGRAM_APPLICATION => 'SQLAP',

            REQUEST_GROUP       => 'All_Payables',

            GROUP_APPLICATION   => 'SQLAP'

          );

    commit;

exception

    when no_data_found then

    dbms_output.put_line('Unable to remove from Request group');

end;

ADD Concurrent Request from request Group

begin

apps.fnd_program.add_to_group(

            PROGRAM_SHORT_NAME  => 'XXTECHARDS_TRANS',

            PROGRAM_APPLICATION => 'SQLAP',

            REQUEST_GROUP       => 'All_Payables',

            GROUP_APPLICATION   => 'SQLAP'

      );

=========================================================================

#Oracle Apps #EBS #Concurrent Request #Remove Concurrent Program from Request Group #Add Concurrent Program from Request Group #Request Group

#Add Concurrent Program to Request group without front end.

No comments:

Post a Comment

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...