raghuk2 (User)
Senior Boarder
Posts: 65
|
Accounting vs HRMS Flex Fields 14 Years, 3 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
raja (User)
Junior Boarder
Posts: 39
|
Re:Accounting vs HRMS Flex Fields 14 Years, 3 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
raghuk2 (User)
Senior Boarder
Posts: 65
|
Re:Accounting vs HRMS Flex Fields 14 Years, 3 Months ago
|
|
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
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Accounting vs HRMS Flex Fields 14 Years, 3 Months ago
|
|
Shanmuga,
What a detailed reply! Thanks. It was very informative.
|
|
|
|
|
The administrator has disabled public write access.
|
|
Re:Accounting vs HRMS Flex Fields 14 Years, 3 Months ago
|
|
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.
|
|
|
|
|
The administrator has disabled public write access.
|
raghuk2 (User)
Senior Boarder
Posts: 65
|
Re:Accounting vs HRMS Flex Fields 14 Years, 3 Months ago
|
|
Thanks Shamuga!
|
|
|
|
|
The administrator has disabled public write access.
|
|