OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » KEY FLEXIFIELDS..?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

KEY FLEXIFIELDS..? [message #162617]

Sun, 12 March 2006 05:43

kartik.of
Messages: 11
Registered: October 2005
Location: hyderabad

Junior Member

Hai all..

Can anybody give me the information regarding flexifields

In E-business suite Financial how many key flexifields are there..?

Plese give the information group by module wise.

Thanks in advance

Regards,
KARTIK.

Report message to a moderator

Re: KEY FLEXIFIELDS..? [message #162622 is a reply to message #162617]

Sun, 12 March 2006 07:32

singhar
Messages: 13
Registered: March 2006

Junior Member

I can give you for Inventory.There are 6.
System Items,Item category,Account alias,stock locators,Item catalog,sales order.
As far as I know There is only one KFF in finance and none in O.M.

Report message to a moderator

Re: KEY FLEXIFIELDS..? [message #162692 is a reply to message #162617]

Mon, 13 March 2006 02:06

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

I cannot imagine what you need this information for, a game of Oracle Trivia? When working with the E-Business Suite you usually know what applications to implement and given that information you know what key flexfields you have to worry about from the implementation guides.

Anyway, the following query will give you the number of key flexfields per application:

SELECT fat.application_name
     , COUNT(*)
  FROM fnd_id_flexs fif
  JOIN fnd_application_tl fat
    ON fat.application_id = fif.application_id
   AND fat.language = 'US'
 GROUP BY fat.application_name
 ORDER BY fat.application_name;

For the 11.5.10 installation I currently am working on the result is:

APPLICATION_NAME                         COUNT(*)
---------------------------------------  --------
Assets                                          3
Capital Resource Logistics - Assets             2
Common Modules-AK                               1
Complex Maintenance Repair and Overhaul         2
Financial Intelligence                          1
General Ledger                                  2
Human Resources                                 8
Inventory                                       7
Learning Management                             1
Payroll                                         3
Public Sector Budgeting                         1
Receivables                                     3
Service                                         1

--
Aleksander Dragnes

Report message to a moderator

Re: KEY FLEXIFIELDS..? [message #163502 is a reply to message #162617]

Fri, 17 March 2006 00:01

shashidhar.k
Messages: 127
Registered: January 2006
Location: India

Senior Member

hi kartik..

"FLEXIFIELD" is a flexble data field., where u r can store information. in Oracle Application there are 2 types of FF .

Key Flexifield ---- combination of segments ., which u can store key information (defining KFF mandatoury)

Descriptive Flexfield --- combination of Attributes ., which u can store additional information (its not mandatoury)...

i guess in entire Oralce application there are 22 KFF . see the below list

FLEXIFIELD ==================== OWNING APPLICATION
________________________________________________________________

Account Aliases --------------- oracle inventory
Accounting --------------- Oracle Genral ledger
Asset Key --------------- Oracle Assets
Bank details Key----------- Oracle Payroll
Category --------------- Oracle Assets
Cost Allocation --------------- Oracle Payroll
Grade --------------- Oracle Human resources
item catalogs --------------- Oracle Inventory
item categories --------------- Oracle Inventory
Job --------------- Oracle Human Resources
Location --------------- Oracle Assets
People Group --------------- Oracle payroll
Personal Analysis ---------------Oracle Human Resources
Position --------------- Oracle Human Resources
Sales Tax location --------------Oracle Receivables
Sales Orders --------------- Oracle Inventory
Soft Coded key --------------- Oracle Human Resources
Stock Locators --------------- Oracle Inventory
System items --------------- Oracle Inventory
Training Resources---------------Oracle Training Adminstration
Territory --------------- Oracle Receivables

Thanks
shashidhar K

[Updated on: Fri, 17 March 2006 00:06]

Report message to a moderator

Previous Topic:	Oracle Heding Process
Next Topic:	what is the navigation for interface in inventory?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 16:14:09 CDT 2024