ERPstuff - Oracle EBS Community

what are the key flefields avalible in oracle applications

Pls elaborate your question. Do you want to know module wise....


Thx,
Raj

hi
module wise how many flexfields in oracle application wwith detials

Hello muthyala..Below are the key flexfiled in Apps. For detail on this you can go through the flexfiled user guide.


Owner Key Flexfield Name Flexfield Code
Oracle Assets Asset Key Flexfield KEY#
Oracle Assets Category Flexfield CAT#
Oracle Assets Location Flexfield LOC#
Oracle General Ledger Accounting Flexfield GL#
Oracle Human Resources Grade Flexfield GRD
Oracle Human Resources Job Flexfield JOB
Oracle Human Resources Personal Analysis Flexfield PEA
Oracle Human Resources Position Flexfield POS
Oracle Human Resources Soft Coded KeyFlexfield SCL
Oracle Inventory Account Aliases MDSP
Oracle Inventory Item Catalogs MICG
Oracle Inventory Item Categories MCAT
Oracle Inventory SalesOrders RLOC
Oracle Inventory Stock Locators MTLL
Oracle Inventory System Items MSTK
Oracle Payroll Bank Details KeyFlexField BANK
Oracle Payroll Cost Allocation Flexfield COST
Oracle Payroll People Group Flexfield GRP
Oracle Receivables Sales Tax Location Flexfield MKTS
Oracle Receivables Territory Flexfield CT#
Oracle Service Oracle Service Item Flexfield SERV
Oracle Training Administration Training Resources RES

Hi,
I heard that there are about 228 Flexfields available in Apps, but need to check it up.

Admin, Is it right 228 Flexfields ????


Thanks

Thank u uma

Rgds
muthyala

Use following queries

SELECT count(*) FROM FND_ID_FLEXS

SELECT count(*) FROM FND_ID_FLEX_STRUCTURES

Hi Admin,

In Vision instance for the given queries,

SELECT count(*) FROM FND_ID_FLEXS
Answer is 35

That means number of flex fields in the application is only 35 Is it so????

SELECT count(*) FROM FND_ID_FLEX_STRUCTURES

628

This means there are 628 structures available for the above 35 flexfields ???

Am I correct with the assumption ??

Thanks

Yes but don't compare the vision count with test/prod instances and on those instance the structures will vary. As on vision there are many KFF's are defined/created by oracle. thanks

Is there any restriction on the no of flex flields or no of structures per flex feild in Apps?

Thanks,
Ritz

<b>Name , Code , Owning Application</b>
Account Aliases, MDSP, Oracle Inventory
Accounting Flexfield, GL# ,Oracle General Ledger
Activity Flexfield, FEAC ,Enterprise Performance Foundation
Asset Key Flexfield, KEY# ,Oracle Assets
Bank Details KeyFlexField ,BANK ,Oracle Payroll
CAGR Flexfield, CAGR ,Oracle Human Resources
Category Flexfield, CAT# ,Oracle Assets
Competence Flexfield,CMP, Oracle Human Resources
Cost Allocation Flexfield, COST, Oracle Payroll
Grade Flexfield GRD Oracle Human Resources
Item Catalogs, MICG, Oracle Inventory
Item Categories, MCAT, Oracle Inventory
Job Flexfield, JOB, Oracle Human Resources
Location Flexfield ,LOC# ,Oracle Assets
Oracle Service Item Flexfield ,SERV ,Oracle Inventory
People Group Flexfield ,GRP ,Oracle Payroll
Personal Analysis Flexfield ,PEA ,Oracle Human Resources
Position Flexfield ,POS ,Oracle Human Resources
Public Sector Budgeting ,BPS ,Oracle Public Sector Budgeting
Sales Orders, MKTS, Oracle Inventory
Sales Tax Location Flexfield, RLOC, Oracle Receivables
Soft Coded KeyFlexfield ,SCL ,Oracle Human Resources
Stock Locators,MTLL,Oracle Inventory
System Items,MSTK,Oracle Inventory
Territory Flexfield,CT#,Oracle Receivables
Training Resources,RES,Oracle Training Administration


You use the flexfield code and the owning application to identify a flexfield when you call it from a custom form.
Note that the following flexfields are single-structure seeded key flexfields: Account Aliases, Item Catalogs, Oracle Service Item Flexfield, Stock Locators, and System Items.


[quote]what are the key flefields avalible in oracle applications

<i><div align="right">Originally posted by muthyala