Hello folks
I know about the Accounting flex filed and it's use.


My question is other than accounting flex filed used for what.

Here is the following Flex Filed used in HRMS.

1.we already have accounting flex filed for balance sheet and income statement.
The below flex filed also can define as part of accounting flex filed instead of that why created as separate flex filed.

2.There is any link between the below flex fields with accounting flex filed.

3.How this will look like in balance sheet or not used in balance sheet?

Pls let me know.


There are 7 key Flex fields in oracle HRMS. They are
1. Job Flex field
2. Grade Flex field
3. Position Flex field
4. People Group Flex field
5. Competence Flex field
6. Collective agreement grade Flex field
7. Cost Allocation Flex field


Thanks, RAP

Hi Ragu,

Here goes the definition for KFF and DFF

DFF --> collect user-defined additional information related to entities.
KFF --> Collect user-defined unique identifies for entities like Item codes & Account codes.


one key thing to note is that, KFF can be used across modules and stores info. in segment columns.


HRMS uses KFFs to capture some manditory info. to build an organization.

Infact there are 8 Key FlexFields in Oracle Apps(HRMS Module).

They are broadly classified as

1.Oracle Payroll
2.Oracle Core HR

Under Oracle Payroll the flex fields are :
:People Group
:Cost Allocation
:Bank Details
Under Oracle Core HR the flex fields are :
:Job
:Position
:Grade
:Competency
:Personal Analysis

Let me explain the concept behind this KFF with an example.

You are suppose to capture some additional fields related to PO, AP and GL.

company name : HOE
Cost center : IT
Project : OFP


If you had only DFFs you will end up designing like this. Data will be spread across tables as it's required at different places in differet modules.
Data would be duplicated across many tables and many records in each such table.

PO_DISTRIBUTIONS_ALL
********************
ATTRIBUTE1 : HOE
ATTRIBUTE2 : IT
ATTRIBUTE3: OFP

AP_INVOICE_DISTRIBUTIONS_ALL
****************************
ATTRIBUTE1 : HOE
ATTRIBUTE2 : IT
ATTRIBUTE3: OFP

GL_JE_LINES
************
ATTRIBUTE1 : HOE
ATTRIBUTE2 : IT
ATTRIBUTE3: OFP

Instead, create a table named HOE_CODE_COMBINATIONs with the following columns:
(for more clarity I am populating sample data here)

COLUMN VALUE
******* *****
CODE_COMBINATION_ID 50493 <-- Unique number
SEGMENT1 HOE
SEGMENT2 IT
SEGMENT3 OFP

Now this combination can be uniquely identified by 50493

Now in PO_DISTRIBUTIONS_ALL --> have a column named CODE_COMBINATION_ID with value 50493 that refers to unique key combination in KFF table.

In AP_INVOICE_DISTRIBUTIONS_ALL --> have a column named CODE_COMBINATION_ID with value 50493 that refers to unique key combination in KFF table.


This concept of having a unique ID that maps to a combination of other values is called key flex fields.

Here are the answers to your questions:


1.we already have accounting flex filed for balance sheet and income statement.
The below flex filed also can define as part of accounting flex filed instead of that why created as separate flex filed.

>> If I understand your question right, the fields exposed in each KFF should have some meaning and all should be related to some common idea like fields related to Job, related to position etc.

2.There is any link between the below flex fields with accounting flex filed.

>> There is no link

3.How this will look like in balance sheet or not used in balance sheet

>> They are not used in Balance Sheet

Kindly let me know if you need more clarity.

Cheers!
Shanmuga

Thanks Shanmuga,

I thought the key flex field used to create a journal entry.
But your explanation clearly state that, it can be used for unique or hierarchy identification purpose. Pls let me know my understanding is correct or not.

Thanks, Rap.K

Shanmuga,

What a detailed reply! Thanks. It was very informative.

RAP,

I am not sure if you already know this or not but I just want to refresh your memory on this point:

Each KEY flexfield has a unique purpose in Oracle Applications. For example accounting flexfield (also known as chart of account) is used in GL for capturing account combinations. It cannot be used for some other purpose like capturing Asset Categories.
Each module comes with predefined KEY flexfields categories. All you do is you create your own structures under the predefined categories. Some modules do not use any key flexfields at all.

Thanks Shamuga!