Enable/Disable Concurrent Program Parameters

EBS Release : Oracle Applications : 12.1.3

This post is aimed at helping in enabling/disabling concurrent program parameters. This solution focuses on below requirements:

1. There are two concurrent program parameters, one which has list of values as associated value set attached, whereas second parameter is such that it is free NUMBER type field.
2. Whenever users choose concurrent program(View - Requests - Submit a New Request - Single Request), both fields must be enabled initially.
3. Whenever users populate first parameter, second parameter should become disabled.

Let us consider a use case scenario. Suppose you are required to update attributes of HZ_PARTIES table based upon certain logic. So, you can either required to pass unique value to update attributes for that particular PARTY_NUMBER or you can update for all. But Business has advised that due to huge amount of data, they like to have parameter such that number records can be restricted. A new concurrent program has to be created to do the same.

Here is synopsis of the solution:

1. Create a new concurrent program(let's name it as "XX: AR Update Parties Attributes")
2. Two concurrent program parameters viz. "Party Number" and "Number of Records to Process"

Step1:

Create required value sets

Navigate to responsibility: System Administrator

Application - Validation - Set

Define Value set "XX_AR_PARTIES_VS" as defined in below screenshots:

Define value set "XX_DUMMY_VS" as define in below screenshots:

Define value set "XX_ENABLE_DISABLE_SPECIAL_NUMBER_VS" as defined in below screenshots:

Add below in Event as "Validate"

FND PLSQL "BEGIN

IF ':$FLEX$.XX_DUMMY_VS' IS NOT NULL THEN

NULL;

END IF;

END;"

Step2:

Create executable, concurrent program, parameters and attach value sets to parameters.

Navigate to responsibility: System Administrator

Concurrent - Program - Executable

Please do not worry about execution file name or logic of program. This has been created only for the name sake. We are only interested in behavior of concurrent program parameters when viewed from SRS(Standard Request Submission Form)

Navigate to responsibility: System Administrator

Concurrent - Program - Define

Value entered in as Default Value "SELECT 'N' from dual where :$FLEX$.XX_AR_PARTIES_VS:NULL IS NULL"

While saving record, click on OK for the error message

Register concurrent program to appropriate request group(Navigate to responsibility: System Administrator, Security - Responsibility - Request)

Navigate to responsibility, where you have registered concurrent program

View - Requests - Submit a New Request - Single Request - Choose concurrent program "XX: AR Update Parties Attributes"

Enter value for "Party Number"

Now, clear the value for Party Number, it should enable Number of Records to Process parameter

You have just learned how to enable/disable concurrent program parameters.