OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » List of KeyFlexfields in Oracle Apps

Home » Applications » Oracle Fusion Apps & E-Business Suite » List of KeyFlexfields in Oracle Apps

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

List of KeyFlexfields in Oracle Apps [message #208953]

Tue, 12 December 2006 12:49

sanjayapps
Messages: 49
Registered: May 2005
Location: Richmond

Member

Friends,

Please find the attachment listing all the Keyflexfields in Oracle Apps.

Attachment: Key Flexfields in Oracle Apps.pdf
(Size: 11.44KB, Downloaded 1987 times)

Report message to a moderator

Re: List of KeyFlexfields in Oracle Apps [message #208997 is a reply to message #208953]

Tue, 12 December 2006 21:59

merlinrajesh
Messages: 105
Registered: November 2006
Location: Chennai

Senior Member

Dear Sanjay

I am not able to download the attachement. Acrobat reader is showing some error.

Thanks & Regards
Merlin Rajesh

Report message to a moderator

Re: List of KeyFlexfields in Oracle Apps [message #208999 is a reply to message #208953]

Tue, 12 December 2006 22:02

ravichandrabhat
Messages: 6
Registered: December 2006

Junior Member

Hi Sanjay,

What about Oracle Projects, is there any Key Flexifield...

Thanks
Ravi

Report message to a moderator

Re: List of KeyFlexfields in Oracle Apps [message #209038 is a reply to message #208953]

Wed, 13 December 2006 00:53

rkreddy
Messages: 19
Registered: December 2006

Junior Member

hi ..

nice doc .. u hav not mentioned ..few modules .. OM,AP,AR

ok bye
reddy

Report message to a moderator

Re: List of KeyFlexfields in Oracle Apps [message #209128 is a reply to message #209038]

Wed, 13 December 2006 07:38

sanjayapps
Messages: 49
Registered: May 2005
Location: Richmond

Member

Hi Guys,

I am attaching the Excel sheet with all the Key Flexfields that I know. If I miss anything, feel free to update and upload.

Attachment: Key Flexfields in Oracle Apps.xls
(Size: 21.00KB, Downloaded 1439 times)

Report message to a moderator

Re: List of KeyFlexfields in Oracle Apps [message #209181 is a reply to message #209128]

Wed, 13 December 2006 11:10

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

Senior Member

Sanjay,

The query below will return all key flexfields defined in your instance of the Oracle E-Business Suite:

SELECT fa.application_short_name
     , fat.application_name
     , fif.id_flex_code
     , fif.id_flex_name
  FROM fnd_id_flexs fif
  JOIN fnd_application fa
    ON fa.application_id = fif.application_id
  JOIN fnd_application_tl fat
    ON fat.application_id = fa.application_id
 WHERE fat.language = 'US'
 ORDER BY fat.application_name
     , fif.id_flex_name;

The result is as follows:

Assets: Asset Key Flexfield
Assets: Category Flexfield
Assets: Location Flexfield
Capital Resource Logistics - Assets: Group Asset
Capital Resource Logistics - Assets: Super Group
Common Modules-AK: FWK Item Flexfield
Complex Maintenance Repair and Overhaul: AHL Operation
Complex Maintenance Repair and Overhaul: AHL Route
Financial Intelligence: Management Flexfield
General Ledger: Accounting Flexfield
General Ledger: Reporting Attributes:Accountin
Human Resources: CAGR Flexfield
Human Resources: Competence Flexfield
Human Resources: Grade Flexfield
Human Resources: Item Contexts Keyflex
Human Resources: Job Flexfield
Human Resources: Personal Analysis Flexfield
Human Resources: Position Flexfield
Human Resources: Soft Coded KeyFlexfield
Inventory: Account Aliases
Inventory: Item Catalogs
Inventory: Item Categories
Inventory: Sales Orders
Inventory: Service Items
Inventory: Stock Locators
Inventory: System Items
Learning Management: Training Resources
Payroll: Bank Details KeyFlexField
Payroll: Cost Allocation Flexfield
Payroll: People Group Flexfield
Public Sector Budgeting: PSB Position Flexfield
Receivables: ARTA-Receipt Prof Ident
Receivables: Sales Tax Location Flexfield
Receivables: Territory Flexfield

--
Aleksander Dragnes

Report message to a moderator

Re: List of KeyFlexfields in Oracle Apps [message #209231 is a reply to message #209181]

Wed, 13 December 2006 22:18

merlinrajesh
Messages: 105
Registered: November 2006
Location: Chennai

Senior Member

Nice Job buddy...

Merlin Rajesh

Report message to a moderator

Previous Topic:	Very Urgent - plz help.............
Next Topic:	FAQ - Oracle project

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 17:53:13 CDT 2024