Exforsys

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i

Ads


Home arrow Technical Training arrow Oracle Apps 11i

Oracle Apps 11i: Setting up Chart Of Accounts (COA) Page - 3

Page 3 of 3
Author : Exforsys Inc.     Published on: 14th Aug 2005

Oracle Apps 11i: Setting up Chart Of Accounts (COA)

.

.

.

Ads

See the figure below:

Fig 7

-- Save the record.

-- A message will be shown for compiling the flexfield definition. Click OK. See figure below.

Fig 8

-- Another message will be displayed saying that a request to generate flexfield view has been submitted and the view name.

With this step we are done with creating the chart of accounts.

2. Enter the valid Accounting Flexfield Segment values:

Now we need to enter valid values for the accounting flexfield segments. There may be a certain range of values that your value set definition permits. But there may be just a few of these permitted values that you may want to use. These valid values are entered for each segment in this step.

The steps are:

-- Navigate to N>Financials>Flexfields>Key>Values.

Fig 9

-- Make sure that in the ‘Find Values By:’ region, ‘Key Flexfield’ option is selected.

-- Click in the ‘Structure’ field and click on the LOV. In the Find box enter the name of your accounting flexfield structure and click FIND. Click OK when you have selected your AFF structure. Click on FIND in the ‘Find Key Flexfield Segment’ window.

-- Click on ‘Values, Hierarchy, qualifiers’ tab.

-- Enter the values that you want to use for each segment and their meaning in the description (the segment name is shown in the block above the current block).

Fig 10


*1 - You can enter the valid account code combinations through the ‘GL Accounts Form’ (N>Setup>Accounts>Combinations). But since we have enabled the ‘Allow Dynamic Inserts’ option on the ‘Key Flexfield Segments’ window, we do not need to enter valid account combinations in this window before we use them. Whenever such a combination is used, it will be defined dynamically.

Frequently Asked Questions

1. What is a COA?
2. What is a value set?
3. What are dependant and independent value sets?
4. What are Special and pair value sets?
5. Explain the various security types related to value sets.
6. What is the significance of the ‘Allow Dynamic Inserts’ option on the ‘Key Flexfield Segments’ window?
7. What is a pop list?
8. Explain the various flexfield qualifiers.
9. How do you enable the cross validation rules to be applied to this flexfield?
10. Which form can be used to enter the valid account code combinations?



 
This tutorial is part of a Oracle Apps 11i tutorial series. Read it from the beginning and learn yourself.

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i
 

Comments