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.

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

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers  

---

What is the difference between recovery and restoring of the oracle database?

0 Answers  

---

What is cardinality?

4 Answers  

---

Explain how to close periods in ar. : oracle accounts receivable

0 Answers  

---

whats the difference between join command and Cartesian product using example?

1 Answers  

---

How client makes connection with server in client/server architecture?

1 Answers   CA,

---

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers  

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

0 Answers   Accenture,

---

What view would you use to determine free space in a tablespace?

0 Answers  

---