Tutorials
Oracle Apps
Oracle Apps 11i: Setting up Chart Of Accounts (COA)
Oracle Apps 11i: Setting up Chart Of Accounts (COA) - Page 2
Oracle Apps 11i: Setting up Chart Of Accounts (COA) - Page 3.
.
.
-- Navigate to the structure lines and click on the ‘New’ button on the tool bar.
-- Enter the ‘Code’, ‘Title’ and ‘Description’ for your accounting structure.
The controls on this form are discussed in explanation for fig 6, 7 and 8.
-- Check the Cross-Validate Segments checkbox and the Allow Dynamic Inserts checkbox.

Fig 4
-- Click on the ‘Segments’ button. Enter the segments that you intend to be in your account structure. E.g. Company_id, Department_id etc.
-- Enter the (Serial) Number, (Segment) Name, Window prompt, Column (this is the column in the table GL.GL_CODE_COMBINATIONS to which this segment is mapped) and Value Set (for validation).
-- Also select the Displayed and Enabled check boxes for these segments. The form may look like this:

Fig 5
-- Navigate to each segment and for each segment, click the Flexfield qualifiers button.
-- The flexfield qualifiers window displays 4 qualifiers that can be attached to the segment. Click any one of the segment qualifiers and to attach it to the selected segment, check the enabled check box. Of these Oracle GL requires the following 3 segments identified:
Apart for these the 4th segment is:
See the figure below:

Fig 6
-- Once you have specified the Flexfield qualifiers for each of the segments, close the Flexfield qualifiers and the segment summary windows.
-- Selecting the ‘Enabled’ check box enables the flexfield on the form.
-- Selecting the ‘Cross-Validate Segments’ check box enables the cross validation rules to be applied to this flexfield.
-- Selecting the ‘Allow Dynamic Inserts’ check box eliminates the need to enter the valid account combinations before using them. The effect is that you don’t have to use the ‘GL Accounts’ form (see *1 at the end).
-- On the Key Flexfield Segments window, check the ‘Freeze Flexfield Definition’ check box. A message will appear warning that you must be done with making changes to your flexfield definition before freezing. Click OK. Selecting this check box makes the flexfield definition non updateable (unless you uncheck it again).
Next Page: Oracle Apps 11i: Setting up Chart Of Accounts (COA) - Page 3
|
This site is great. I am going thru each lessons. Please update. After 2nd Sep, I didn\'t find any updates. Good Work ... Didn\'t find in any other site stuffs like. Want to write comments for every lesson.... Once Again .. Thanks for who all are working on this site.. Sheeba. |
| A great article.A must read for every Oracle Applications user. |
|
Hi, Here Creating Chart of Accounts is excellent, I want to learn total GL Module. vijay bhaskar, hyd |
|
this site is really helpful for beginners... thanx to the developers. |
|
Great article ,KIndly update the article regading OM ,AR,INV & Apps Techinicals we will be thankful for you if you post this articles. |
| This site is very Good for learners.i am following this site regularly.please give FAQ's with answers. |
|
Really good for learners, Please provide information on modules like OM(Order Management) for creating orders,deliveries etc... Thanks Phani |
|
I was run into this site by the chance. I m gonna advise my friends they are involved in oracle applications. I think u should give answer FAQs it s gonna be easy to reach them |
| Excellent one for learners. |
| I think this site very good for students . |
|
I was run into this site by the chance , this site is great and it will be very good for students and employees |