Fetching Flexfield Description

[code]
CREATE OR REPLACE FUNCTION APPS.GET_FLEX_VS_DESC (P_VALUE_SET_NAME VARCHAR2, P_FLEX_VALUE VARCHAR2, P_PARENT_FLEX_VALUE VARCHAR2)
RETURN VARCHAR2 IS
DESCRIP VARCHAR2(50);
BEGIN
IF P_PARENT_FLEX_VALUE IS NULL
THEN
/*** In case the value set is independent ***/
SELECT DISTINCT DESCRIPTION
INTO DESCRIP
FROM FND_FLEX_VALUES_VL
WHERE FLEX_VALUE_SET_ID =
(
SELECT FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME
AND FLEX_VALUE = P_FLEX_VALUE
--AND PARENT_FLEX_VALUE_LOW = P_PARENT_FLEX_VALUE
);
ELSE
/*** If the value set is dependent on another value set ***/
SELECT DISTINCT DESCRIPTION
INTO DESCRIP
FROM FND_FLEX_VALUES_VL
WHERE FLEX_VALUE_SET_ID =
(
SELECT FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME = P_VALUE_SET_NAME
AND FLEX_VALUE = P_FLEX_VALUE
AND PARENT_FLEX_VALUE_LOW = P_PARENT_FLEX_VALUE
);
END IF;
RETURN NVL(DESCRIP, 'ERROR');
END;
/
[/code]

Shameem Bauccha

19 October 2009

Key Flexfields

Platform: 11.5.10, R12


Key Flexfield Architecture

Key Flexfield is a very important concept in Oracle. It allows you to define Key Structures in each Module. This gives you the flexibility to model your objects according to your requirements. Some examples of flexfields are as follow:

Accounting Flexfield in General Ledger.

Job, Position and Grade Key Flexfield in Human Resources.

[caption id="" align="alignnone" width="572" caption="Key Flexfield Architecture"][/caption]

A flexfield is a structure that you define for a Flexfield Title. The Flexfield Structures are registered within an application.

A structure will compose of one or more segments. Each segment will be attached to a value set which you would have defined. If required you will qualify the segment in question.

Define Key Flexfield Structure

System Administrator --> Flexfield --> Segments

Note: KFFs are accessible from other Modules as well.

[caption id="" align="alignnone" width="756" caption="Key Flexfield Segments"][/caption]

Query for the Key Flexfield in question. As an example I have queried the 'Training Resources' KFF.

[caption id="" align="alignnone" width="756" caption="Training Resources KFF"][/caption]

Add your structure, then click on ‘Segments’ to define the segments.

[caption id="" align="alignnone" width="755" caption="Segments Summary"][/caption]

Click on ‘Value Set’. Define your value set. The Value Set determines what values will be available for the segment in question. Specify the ‘Value Validation’.  Save the value set, close the form and attach it to the segment as shown above.

We have various ways of validating the values.

(Detailed document to follow on Value Sets)

Define Value Sets

[caption id="" align="alignnone" width="755" caption="Define Value Sets"][/caption]

In this case, the validation is based on a table. Click on ‘Edit Information’ to define it.

[caption id="" align="alignnone" width="755" caption="Validation Table Information"][/caption]

When you are done, click on ‘Open’ on the ‘Segment Summary’ Form. Specify whether it is required. By default all segments are marked as required.

[caption id="" align="alignnone" width="755" caption="Segments"][/caption]

Flexfield Qualifiers

Click on ‘Flexfield Qualifiers’ to qualify the segment. This is not valid for all Key Flexfields. Accounting Flexfield has Flexfield Qualifiers and is illustrated below.

[caption id="" align="alignnone" width="620" caption="Flexfield Qualifiers"][/caption]

Once you are done with all the segments close the ‘Segments Summary’ Form to return to the ‘Key Flexfield Segments’ window.

Compile Key Flexfield Structure

[caption id="" align="alignnone" width="740" caption="Compile KFF"][/caption]

To be able to use the KFF, you need to freeze the structure. To freeze the structure, check the ‘Freeze Flexfield Definition’ and click on ‘Compile’. A request is launched to compile the structure. The structure is now available in your application.

Note: The ‘Allow Dynamic Inserts’ checkbox enables KFF values to be generated while using the application. If you don’t allow dynamic insert, then you need to define all the valid value combinations for your structure before you can use these values in your application.

Shameem Bauccha

24 June 2009

Define System Profile Values

Introduction

System profiles direct how your application behaves, what default values it takes or what restrictions are in place.

Each module has its list of profile options which you have to define for your application to work properly.

You can specify the options at various levels. It is important to identify correctly at which level to set the profile value.  See the precedence pyramid below:

[caption id="" align="alignnone" width="496" caption="System Profile Precedence Pyramid"][/caption]

A profile set at user level will take priority over the same profile set at responsibility level or site level for example. Be cautious when setting profile options as site level as in this may affect other people who may be working on the same instance.

Define Profile Values

System Administrator --> Profile --> System





[caption id="" align="alignnone" width="576" caption="Find System Profile Values"][/caption]

The 'Site' and 'Profiles with No Values' check boxes on the Profile page are selected by default. Therefore, when a search is performed and a profile option is selected, the system lists the values defined only at site level. To see the values defined at all the levels, uncheck these checkboxes before performing a search and selecting a profile option.



Choose the ‘Levels’, specify the ‘Profile’ you wish to set and click on ‘Find’.

[caption id="" align="alignnone" width="996" caption="System Profile Values"][/caption]

In case the profile cannot be set at certain level, it will be greyed out even if you specify a profile option for it.

Type in or lookup up the appropriate option and save.

That’s it, your profile option value is set!



Shameem Bauccha

22 June 2009

Oracle Apps - Clear Cache

Clearing the cache from front-end

Functional Administrator --> Core Services --> Caching Framework --> Global Configuration

[caption id="attachment_22" align="aligncenter" width="1024" caption="Caching Framework"][/caption]




Click on Clear Cache.

Click on Apply.