Home » Applications » Oracle Fusion Apps & E-Business Suite » List of KeyFlexfields in Oracle Apps
List of KeyFlexfields in Oracle Apps [message #208953] Tue, 12 December 2006 12:49 Go to next message
sanjayapps
Messages: 49
Registered: May 2005
Location: Richmond
Member

Friends,

Please find the attachment listing all the Keyflexfields in Oracle Apps.
Re: List of KeyFlexfields in Oracle Apps [message #208997 is a reply to message #208953] Tue, 12 December 2006 21:59 Go to previous messageGo to next message
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
Re: List of KeyFlexfields in Oracle Apps [message #208999 is a reply to message #208953] Tue, 12 December 2006 22:02 Go to previous messageGo to next message
ravichandrabhat
Messages: 6
Registered: December 2006
Junior Member
Hi Sanjay,

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

Thanks
Ravi
Re: List of KeyFlexfields in Oracle Apps [message #209038 is a reply to message #208953] Wed, 13 December 2006 00:53 Go to previous messageGo to next message
rkreddy
Messages: 19
Registered: December 2006
Junior Member
hi ..


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



ok bye
reddy
Re: List of KeyFlexfields in Oracle Apps [message #209128 is a reply to message #209038] Wed, 13 December 2006 07:38 Go to previous messageGo to next message
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.
Re: List of KeyFlexfields in Oracle Apps [message #209181 is a reply to message #209128] Wed, 13 December 2006 11:10 Go to previous messageGo to next message
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:
  1. Assets: Asset Key Flexfield
  2. Assets: Category Flexfield
  3. Assets: Location Flexfield
  4. Capital Resource Logistics - Assets: Group Asset
  5. Capital Resource Logistics - Assets: Super Group
  6. Common Modules-AK: FWK Item Flexfield
  7. Complex Maintenance Repair and Overhaul: AHL Operation
  8. Complex Maintenance Repair and Overhaul: AHL Route
  9. Financial Intelligence: Management Flexfield
  10. General Ledger: Accounting Flexfield
  11. General Ledger: Reporting Attributes:Accountin
  12. Human Resources: CAGR Flexfield
  13. Human Resources: Competence Flexfield
  14. Human Resources: Grade Flexfield
  15. Human Resources: Item Contexts Keyflex
  16. Human Resources: Job Flexfield
  17. Human Resources: Personal Analysis Flexfield
  18. Human Resources: Position Flexfield
  19. Human Resources: Soft Coded KeyFlexfield
  20. Inventory: Account Aliases
  21. Inventory: Item Catalogs
  22. Inventory: Item Categories
  23. Inventory: Sales Orders
  24. Inventory: Service Items
  25. Inventory: Stock Locators
  26. Inventory: System Items
  27. Learning Management: Training Resources
  28. Payroll: Bank Details KeyFlexField
  29. Payroll: Cost Allocation Flexfield
  30. Payroll: People Group Flexfield
  31. Public Sector Budgeting: PSB Position Flexfield
  32. Receivables: ARTA-Receipt Prof Ident
  33. Receivables: Sales Tax Location Flexfield
  34. Receivables: Territory Flexfield

--
Aleksander Dragnes
Re: List of KeyFlexfields in Oracle Apps [message #209231 is a reply to message #209181] Wed, 13 December 2006 22:18 Go to previous message
merlinrajesh
Messages: 105
Registered: November 2006
Location: Chennai
Senior Member

Nice Job buddy...

Merlin Rajesh
Previous Topic: Very Urgent - plz help.............
Next Topic: FAQ - Oracle project
Goto Forum:
  


Current Time: Mon Dec 05 20:58:52 CST 2016

Total time taken to generate the page: 0.08769 seconds