Answer Posted / srinivas dama
$FLEX$ and $PROFILES$ are Special Variables in oracle Apps
environment and are used to hold values at runtime.
-->Every Oracle Apps technical consultant will be familiar
with the term $FLEX$ and $PROFILES$. Whenever we are working
with value sets, we will be using both of these for
modifying the data fetched, for basing the values of a
parameter on the other parameter and also fetching the
Profile Option values.
To segregate this based on the functionality
-->$FLEX$: Used for basing the value of a parameter on
another parameter.
-->$PROFILES$: used for fetching the data stored in the
specified profile option value which is currently active.
Where is it used?
Both these variables are used in the Parameter form of a
Concurrent Program and are used at the Where Clause window
in the value set ofTable type.
Syntax:
:$FLEX$.previous_value_set_name
Important:
• $FLEX$ must always be in capitals.
• A ‘:’ must precede the declaration of $FLEX$.
• The previous value set name must have already been
assigned and saved on a different parameter.
:$PROFILES$.Profile_option_name
Important:
• $PROFILES$ must be always in capitals.
• ‘:’ must always precede the declaration.
• Profile option name is the Profile Name and not to
be confused with the User profile Name.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Where in the Oracle directory tree structure are audit traces placed?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
How do you create a credit note against an invoice? : oracle accounts receivable
key flexfield structure
Explain prerequisites and post activities of oracle database installation
How would you determine what sessions are connected and what resources they are waiting for?
What is chargeback invoice? How do we create it? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
