INTERVIEW QUESTIONS ORACLE APPS AOL DETAILS

Question: What is '$flex$ and '$profile$, Waht is the use of '$flex$'?

Answer: $Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .

For Ex . $Flex$.<Valueset name> would return the value held by that valueset .

$profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment.

Ex. $profiles$.org_id would return the operating unit which is active at that time for the user.

$Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .

For Ex . $Flex$.<Valueset name> would return the value held by that valueset .

$profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment.

Ex. $profiles$.org_id would return the operating unit which is active at that time for the user. Source: CoolInterview.com

:$FLEX$
=======
:$Flex$.<valueset_name> is used to get the previous parameter value to the current parameter. And it is a reserved word.

Can be used at 2 locations in oracle applications.
1. Value set where/order by field.

If we want to select statement in application>validation>sets instead of tablename it should be select caluse and in parathesis.

eg: create a value set by name DPTNO datatype number(5)
validation type TABLE
click EDIT INFORMATION
in table place (select distinct deptno from emp)

create another value set by name JOB datatype CHAR(20)
validation type TABLE
click EDIT INFORMATION
table name (SELECT DISTINCT DEPTNO,JOB FROM EMP)
JOB CHAR 20
where/order by WHERE DEPTNO=:$FLEX$.DPTNO

and mention this valueset in the concurrent >program>define>parameter form.

2. Default value field in concurrent progrm form.

first create an value set of DTNO of Table validation type
click EDIT INFORMATION
at table name (SELECT DISTINCT DEPTNO FROM EMP)
in the concurrent>program>define>parameter form
you can even specify as

mention Parameter name as JOB

default type -SQL STATEMENT
default value - SELECT DISTINCT DEPTNO,JOB FROM EMP WHERE DEPTNO=:$FLEX$.DTNO



:$PROFILE$
==========
used to get current profile value to the current parameter.

1. Value set where/order by field.
create a value set by Name as
XX_ORG_ID
datatype CHAR(240)
validation type TABLE
click EDIT INFORMATION
table name HR_OPERATING_UNITS
table columns
NAME CHAR 240
ORGANIZATION_ID NUMBER 15
where/order by ORGANIZATION_ID= :$profiles$.org_id

and mention this valueset in the concurrent >program>define>parameter form.

2. Default value field in concurrent progrm form.

concurrent>program>define>parameter form
you can even specify as

mention Parameter name as P_ORG_ID
default type -SQL STATEMENT
default value - SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID=:$PROFILE$.ORG_ID
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question