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

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---

as a technical developer in oracle applications which type errors feced in your experience sofar

1 Answers   HCL,

---

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1 Answers  

---

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

---

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

1 Answers  

---

deference between & and &&

2 Answers   Mphasis,

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1 Answers  

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1 Answers  

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1 Answers  

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1 Answers   TCS,

---