Scheduling Concurrent Programs

We can submit the Concurrent program in future date or date by using the schedule button in SRS window.

As soon as possible: This is default option whenever we submit the request it will submit the as soon as possible.

Once: It will submit the rest only once for future date.

Periodically: We can specify the from_date and to_date to submit program periodically no of. Days months, hours, minutes and so on.

Specific Days: If we want submit concurrent program in the specific days we write select this option.

Save this Schedule: This check box will be used to save the schedule and apply same schedule to other concurrent programs by selecting the button called ‘Apply save schedule’.

Note: After schedule the Concurrent program we can also cancel by selecting the cancel button.

Active Responsibility List with Active User Count

SELECT

       fat.application_name         "Application Name",

       frv.responsibility_name      "Active Responsibility Name",

       COUNT(fu.user_name)          "Active User Count"

  FROM

       fnd_user                     fu,

       fnd_user_resp_groups_direct  furgd,

       fnd_responsibility_vl        frv,

       fnd_application_tl           fat

 WHERE

       1=1

   --

   AND furgd.end_date IS NULL

   --

   AND TRUNC(SYSDATE) BETWEEN

          TRUNC(furgd.start_date) AND TRUNC(NVL(furgd.end_date, SYSDATE+1))

   AND TRUNC(SYSDATE) BETWEEN

          TRUNC(frv.start_date)   AND TRUNC(NVL(frv.end_date, SYSDATE+1))

   AND TRUNC(SYSDATE) BETWEEN

          TRUNC(fu.start_date)    AND TRUNC(NVL(fu.end_date, SYSDATE+1))

   --

   AND fat.application_id       =  frv.application_id

   --

   AND furgd.responsibility_id  =  frv.responsibility_id

   AND furgd.user_id            =  fu.user_id

   --

 GROUP BY fat.application_name, frv.responsibility_name

 ORDER BY fat.application_name, frv.responsibility_name;

Profile to Change the color of Concurrent manager - Status

On concurrent manager screen normally along with default form color we see Red, Yellow and Green color for Error, Warning and Pending respectively. Recently I came across a profile that would change this normal behavior and hide these colors.

The profile name is FND: Indicator Colors. The profile also affects the behavior of required parameter which is normally displayed in yellow.
Another point to note is that by setting this profile to No only concurrent manager screen is affected and other forms behave normally.

Dependent Parameters in CCP using Value Set

ependent Parameters in Oracle Applications
Requirement:
Say there is a concurrent program that lets you retrieve employee details based on employee name or employee number.
The concurrent program has 3 parameters:
1.Search Criteria is a value set containing “Employee Name” and “Employee Number” as values
2.Employee Name
3.Employee Number
When the user wants to search employee based on Employee number, he selects Employee Number in the parameter “Search Criteria”.
Automatically Employee name parameter should be disabled so that user can enter only number in the parameter Employee number to search that employee.
Similarly if the users wants to to search employee based on Employee name, Employee number parameter should be disabled thus preventing the users to search based on Employee number.

As seen in the above screenshot, say there is a Concurrent program which has 3 parameters defined:
1. Select Parameter to Disable
2. Parameter – 1
3. Parameter – 2
And Parameter “Select Parameter to Disable” is a value set that has values –
PARAM-1, PARAM-2
The requirement here is if the user selects PARAM-1 as the value for the parameter “Select Parameter to Disable”, then the Parameter “Parameter – 1” should be disabled meaning the user should not be able to enter any information for that parameter.
If user selects PARAM-2 as the value for the parameter “Select Parameter to Disable”, then the Parameter “Parameter – 2” should be disabled.
Steps to implement the above requirement:
1. Create the below Value Sets:
I. Value Set “ERPS_SP_VS_PARA_DEMO”:
· Navigation: System Administrator responsibility>Application>Validation>Set
· Enter the details as shown in screenshot below and save your work.

· Navigation: System Administrator responsibility>Application>Validation>Values
· Give the name as “ERPS_SP_VS_PARA_DEMO” and click on Find.

· Enter Values as PARAM-1 and PARAM-2 as shown bin the below screenshot and save your work.

II. Value Set “ERPS_SP_VS_PAR1_DUMMY”:
· Navigation: System Administrator responsibility>Application>Validation>Set
· Enter the details as shown in screenshot below and save your work.

III. Value Set ERPS_SP_VS_PAR2_DUMMY
· Navigation: System Administrator responsibility>Application>Validation>Set
· Enter the details as shown in screenshot below

IV. Create Value Set ERPS_SP_VS_PAR1
· Navigation: System Administrator responsibility>Application>Validation>Set
· Enter the details as shown in screenshot below.
· Click “Edit Information” button.

· Select Event as Validate and add the below code in the Function textbox
FND PLSQL”BEGIN
IF :$FLEX$.ERPS_SP_VS_PAR1_DUMMY <> 1 THEN
NULL;
END IF;
END;
”
· Save your work

V. Create Value Set ERPS_SP_VS_PAR2
· Navigation: System Administrator responsibility>Application>Validation>Set
· Enter the details as shown in screenshot below.
· Click “Edit Information” button.

· Select Event as Validate and add the below code in the Function textbox
FND PLSQL”BEGIN
IF :$FLEX$.ERPS_SP_VS_PAR2_DUMMY <> 1 THEN
NULL;
END;
”

· Save your work
2. Define Executable for the concurrent program
· Navigation: System Administrator responsibility>Concurrent>Program>Executable
· Enter the details as shown in screenshot below.
· Save your work

3. Define the concurrent program:
· Navigation: System Administrator responsibility>Concurrent>Program>Define
· Enter the details as shown in screenshot below.
· Save your work

4. Define Parameters for the concurrent program:
· Click on “Parameters” button and enter the below details
A. Seq: 10
B. Parameter: Enter Parameter Num to Disable
C. Value Set: ERPS_SP_VS_PARA_DEMO
D. Prompt: Select Parameter to Disable

A. Seq:15
B. Parameter: Parameter – 1 Dummy
C. Value Set: ERPS_SP_VS_PAR1_DUMMY
D. Default Type: SQL Statement
E. Default Value: select 1 from Dual where :$FLEX$.ERPS_SP_VS_PARA_DEMO != ‘PARAM-1′
F. Uncheck the Display Checkbox

A. Seq:20
B. Parameter: Parameter – 1
C. Value Set: ERPS_SP_VS_PAR1

A. Seq:25
B. Parameter: Parameter – 2 Dummy
C. Value Set: ERPS_SP_VS_PAR2_DUMMY
D. Default Type: SQL Statement
E. Default Value: select 1 from Dual where :$FLEX$.ERPS_SP_VS_PARA_DEMO != ‘PARAM-2′
F. Uncheck the Display Checkbox

A. Seq:30
B. Parameter: Parameter – 2
C. Value Set: ERPS_SP_VS_PAR2
D. Save the work.

Assign this concurrent program to the desired responsibility and check the result.

Launch CCP from Menu

Normally we assign any concurrent program to a request group corresponding to the responsibility from which we want to run our concurrent program. What in case if user want to launch concurrent program directly from a menu.

To assign a concurrent program to a menu follow the steps

• Create a new function of form type and name it as your concurrent program
  
• In the parameter field pass a parameter Program=
  
• Assign this function to a responsibility menu from which you want to run this concurrent program.
  

Now go to that responsibility and click on the function. It will directly launch the concurrent program.

Advantage: User can directly launch the concurrent program instead of navigating to view >> Requests >> Submit

Disadvantage: If you create a function for each concurrent program then in each responsibility you will have around 100 functions which look weird.