Interested to Buy Any Domain ? << Click Here >> for more details...
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
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How would you determine what sessions are connected and what resources they are waiting for?
can we use lexical perameter in oracle plsql if yes how
What is the disk migration? what is the steps involved in oracle disk migration?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is an Oracle database Partial Backup?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is an Oracle database Full Backup?
