Interested to Buy Any Domain ? << Click Here >> for more details...
What is $FLEX$ and $PROFILES$?
- 2 Answers
- 7515 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ramesh
IN reports we are using both param
$Flex$ is used ,when we wnt to join with other tables
$profile$ is used to when we are using profile values ....
don't write big stories yaaar it is waste of time to read
and understand
| Is This Answer Correct ? | 1 Yes | 3 No |
What background process refreshes materialized views?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?
8. Supporting AP, AR and GL?
How would you determine who has added a row to a table?
How would you go about increasing the buffer cache hit ratio?
how to create an user in oracle 10g.please give me an example..
WHAT IS CARTESIAN PRODUCT?
Explain the process of recievables in oracle financials. : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is db_recovery_file_dest in oracle? When do you need to set this value?
Oracle General 
