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:
This post is aimed at helping in enabling/disabling concurrent program parameters. This solution focuses on below requirements:
- 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.
- Whenever users choose concurrent program(View - Requests - Submit a New Request - Single Request), both fields must be enabled initially.
- 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:
- Create a new concurrent program(let's name it as "XX: AR Update Parties Attributes")
- 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.
