SQL Script to find Concurrent program details with Path

SQL Script to find Concurrent program details with Path, program type, Executable details

SELECT fcp.concurrent_program_id
      ,fcp.concurrent_program_name 
      ,fcpt.user_concurrent_program_name usr_conc_program
      ,fcp.enabled_flag flag
      ,fcp.output_file_type output_TYPE
      ,fe.executable_name
      ,fcp.execution_method_code program_method_code
      ,(SELECT meaning FROM apps.fnd_lookup_values WHERE lookup_code = fcp.execution_method_code AND lookup_type = ‘CP_EXECUTION_METHOD_CODE’) prog_method
      ,fe.execution_method_code executable_method_code
      ,(SELECT meaning FROM apps.fnd_lookup_values WHERE lookup_code = fe.execution_method_code AND lookup_type = ‘CP_EXECUTION_METHOD_CODE’) exec_method
      ,fe.execution_file_name
      ,fa.application_short_name
      ,fat.application_name
      ,fa.basepath top
      ,(select value from apps.fnd_env_context where variable_name = fa.basepath and concurrent_process_id = (select max(concurrent_process_id) from apps.fnd_env_context)) ||’/reports/US’ path
      ,fcp.creation_date
      ,(select user_name||’ : ‘||description from apps.fnd_user where user_id = fcp.created_by) created_by
      ,fcp.last_update_date
      ,(select user_name||’ : ‘||description from apps.fnd_user where user_id = fcp.last_updated_by) updated_by
FROM apps.fnd_concurrent_programs_tl fcpt
    ,apps.fnd_concurrent_programs    fcp
    ,apps.fnd_executables            fe
    ,apps.fnd_application_tl         fat
    ,apps.fnd_application           fa

WHERE 1 = 1
and fcpt.application_id = fcp.application_id
and fcpt.concurrent_program_id = fcp.concurrent_program_id
and fe.executable_id = fcp.executable_id
and fe.application_id = fa.application_id
and fat.application_id = fa.application_id
AND fcp.enabled_flag = ‘Y’
and upper(fcpt.user_concurrent_program_name) = ‘&prog_name_upper_case’–like ‘%EVENT%’
;

How to Download Oracle Student Guide Courseware from My Oracle Support

 Pre-requisites

1. My Oracle Support account
2. Valid CSI, should be approved to your account
3. Patch download access

Login to your My Oracle Support Account

Go to Patch & Updates

Select Product or Family (Advanced)

Fill the details as below for search criteria

Product is: Oracle Tutor
Release is one of: all
Platform is Microsoft Windows (32 bit)
Description contains Courseware

Then hit Search

Click on Any patch name hyper link

Then click on Download.

It will download the complete courseware

!!!Happy Learning!!!

Query to find the Organization structure of a business

Run this script giving inventory org as the parameter

SELECT MP.ORGANIZATION_CODE,
       HAOU.NAME,

      HAOUBG.NAME BUSINESS_GROUP,
      GSOB.NAME SOB_NAME, /*gsob.short_name,*/
      GSOB.CURRENCY_CODE,
      GSOB.PERIOD_SET_NAME,
      (SELECT SEGMENT1 || ‘.’ || SEGMENT2 || ‘.’ ||SEGMENT3 || ‘.’ ||
              SEGMENT4 || ‘.’ || SEGMENT5 || ‘.’ ||SEGMENT6 || ‘.’ ||
              SEGMENT7 || ‘.’ || SEGMENT8 || ‘.’ ||SEGMENT9
         FROM APPS.GL_CODE_COMBINATIONS
        WHERE CODE_COMBINATION_ID =GSOB.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNT,
      HLE.NAME LE_NAME,
      HLE.VAT_REGISTRATION_NUMBER,
      HOU.NAME OU_NAME
—  ,hri.*
 FROM APPS.HR_ALL_ORGANIZATION_UNITS   HAOU,
      APPS.HR_ORGANIZATION_INFORMATION HRI,
      APPS.MTL_PARAMETERS              MP,
      APPS.GL_SETS_OF_BOOKS            GSOB,
      APPS.HR_LEGAL_ENTITIES           HLE,
      APPS.HR_OPERATING_UNITS          HOU,
      APPS.HR_ALL_ORGANIZATION_UNITS   HAOUBG,
      APPS.HR_ORGANIZATION_INFORMATION HRIBG

WHERE HRI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
  AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
  AND MP.ORGANIZATION_CODE IN (‘V1’)
  AND HRI.ORG_INFORMATION_CONTEXT = ‘Accounting Information’
  AND GSOB.SET_OF_BOOKS_ID = HRI.ORG_INFORMATION1
  AND HLE.ORGANIZATION_ID = HRI.ORG_INFORMATION2
  AND HOU.ORGANIZATION_ID = HRI.ORG_INFORMATION3
  AND HAOUBG.ORGANIZATION_ID = HLE.BUSINESS_GROUP_ID
  AND HRIBG.ORG_INFORMATION_CONTEXT = ‘Business Group Information’
  AND HRIBG.ORGANIZATION_ID =HAOUBG.ORGANIZATION_ID;