March 6, 2010

Valuesets

What is $FLEX$ and $PROFILES$?


$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$.
 
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.

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.
at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
  • Wip Move Transaction Migration
    WIP Migration: Create a job in Work in Process 1.        Create a job with item which is billable on and define routing sequence for the ...