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%’
;

Defining Shipping Method in Oracle

Go to any OM Super User responsibility
Navigate to

Setup àShipping àFreight Carriers, Cost Types àFreight Carriers

Shipping method is combination of 3 basic properties

• Carriers
• Service Level
• Mode

So to define a shipping method, you can use either existing carrier and service level or you can create a new one in this form

Lets Create a new one here

For creating new Carrier, enter the carrier name and Short name as you need

For creating a new service level, click on the Define Service Levels button

Define the details and Save.

Close the form and add the same service level in the Carriers form which you have created (you can use any service level as you need from the LOV as well)

Select the Mode of transport from the LOV. Say for example TL (TL for Truck)

When you enter the Mode and hit Tab, system will generate a shipping method considering the 3 properties as in this case, Test Carrier-TL-Test Service Level (Carrier – Mode – Service Level)

But you can rename the shipping method as per your need and save

As in this case, I have added, TEST at the end

Once you save the Shipping Method, here, it will create a record in in the SHIP_METHOD quick code in  the Inventory application.

Now you can assign this ship method to any inventory orgs by clicking on the button Organization Assignments in this form only

Click the assigned check box and click on Done to assign the shipping method to required org.

You can see this ship method in the SHIP_METHOD quick code in Inv responsibility, if you need to add any DFF details.

To do this, go to any INV Super user responsibility
Navigate to

Setup àOrganizations àShipping Methods

Here it will show all the shipping methods defined in system

So query the one you have created now by entering the shipping method name in the Meaning field

Now setup the DFF as you need and save.

Shipping method is ready to be used.