API To Assigns An Existing Role To An Existing User In The 'CRM_DOMAIN'

Script to Assign the Install base roles for a User

BEGIN
jtf_auth_bulkload_pkg.assign_role('<&USER_NAME>','CSI_NORMAL_USER');
COMMIT;
END;

Query to Find the SID of the a Concurrent Program running from Application

SELECT   fcr.request_id
       , SUBSTR (DECODE (fcr.description
                       , NULL, fcp.user_concurrent_program_name
                       , fcr.description || ' (' || fcp.user_concurrent_program_name || ')'
                        )
               , 1
               , 40
                ) conc_prog_name
       , TO_CHAR (fcr.actual_start_date, 'hh24:mi') s_time
       , fu.user_name requestor
       , SID
       , vs.process
       , vp.spid
FROM     v$session vs
       , v$process vp
       , apps.fnd_user fu
       , apps.fnd_concurrent_programs_vl fcp
       , apps.fnd_concurrent_requests fcr
   WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
     AND fcr.program_application_id = fcp.application_id
     AND fcr.status_code = 'R'
     AND fcr.phase_code = 'R'
     AND fcr.requested_by = fu.user_id
     AND fcr.oracle_process_id = vp.spid(+)
     AND vp.addr = vs.paddr(+)
     AND fcr.request_id = :request_id
ORDER BY SUBSTR (DECODE (fcr.description
                       , NULL, fcp.user_concurrent_program_name
                       , fcr.description || ' (' || fcp.user_concurrent_program_name || ')'
                        )
               , 1
               , 40
                )
       , fcr.actual_start_date
     

Syntax to Create the Soft link for .PROG file

Script to create the Soft Link for the Shell Script

ln -s $FND_TOP/bin/fndcpesr FILE_NAME

How to Query on the LONG datatype Columns

-- Create the custom table as mentioned below 

CREATE TABLE XX_ALL_TRIGGERS AS SELECT TRIGGER_NAME,TO_LOB(TRIGGER_BODY) AS TRIGGER_BODY FROM ALL_TRIGGERS;

--After creating the table execute the below query

SELECT * FROM XX_ALL_TRIGGERS WHERE UPPER(TRIGGER_BODY) LIKE 'XX%TRG%';

Query to get the Details of the WF Service Components

1. Go To responsibility Workflow Administrator

2. Navigation 

           Workflow Administrator --> Oracle Application Manager --> Workflow Manager --> Service Components --> Edit

   

SELECT para_values.parameter_value

  FROM fnd_svc_components fsc

     , fnd_svc_comp_params_b para

     , fnd_svc_comp_param_vals para_values

WHERE para.parameter_name = 'REPLYTO'

   AND para.parameter_id = para_values.parameter_id

  AND fsc.component_id = para_values.component_id

   AND fsc.component_name = 'Workflow Notification Mailer';