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

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers  

---

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

1 Answers   Oracle,

---

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

0 Answers  

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

What is the importance of batch source set up in ar? : oracle accounts receivable

0 Answers  

---

What is the use of lockboxes? : oracle accounts receivable

0 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers  

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

---

what is sql*loader parameters and where we will use it.

1 Answers   Accenture,

---