Interested to Buy Any Domain ? << Click Here >> for more details...
What is $FLEX$ and $PROFILES$?
- 2 Answers
- 7694 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 |
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
What is Tax Categories?
WHAT IS CARTESIAN PRODUCT?
How client makes connection with server in client/server architecture?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What do you mean by Oracle MEDIA RECOVERY?
How would you go about generating an EXPLAIN plan?
Explain the difference between a data block, an extent and a segment.
what are the tools used for oracle 10g in real time.
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
Oracle General 
