Thursday 18 February 2016

Batch Status in OPM

select * from fnd_lookup_values where lookup_type  like 'BATCH_STATUS' AND LANGUAGE ='US'

Monday 15 February 2016

How to attach concurrent program to request group using pl/sql script.

DECLARE
BEGIN
FND_PROGRAM.add_to_group
    (
     PROGRAM_SHORT_NAME  =>'XXHLFUSIONPHLFIINT'
    ,PROGRAM_APPLICATION =>'XXHL'
    ,REQUEST_GROUP       => 'US SHRMS Reports & Processes'
    ,GROUP_APPLICATION   =>'PER'
    ) ;   
  commit;
exception
    when others then
           dbms_output.put_line('Object already exists');
END;

/