Thursday, June 10, 2010

Chart of Accounts Implementation in Oracle Apps R12 (Part 2)

Steps in Detail:

1. Value Set Definition:

The value set is the group of values that determine the attributes of the segment. The definition of value set decides whether the value entered for the corresponding segment is acceptable or not. We have to define the value sets for each segment we planned to have in Account combination.

Navigation: General Ledger Super User Responsibility 
Setup à Financials à Flexifeilds à Validation à Sets

 2. Defining Accounting Flexifield Structure

Define an accounting flexfield structure using the Key Flexfield Segments form.

Caution 1:
Once we freeze our account structure in the Key Flexfield Segments window and begin using account numbers in data entry, we should not modify the flexfield definition. Changing the existing flexfield structure after flexfield data has been created can cause serious data inconsistencies. Modifying your existing structures may also adversely affect the behavior of cross–validation rules and shorthand aliases.

Caution 2:
Once you are done entering the segment information, click on flexfield qualifier and designate one of your segments as the natural account segment and another as the balancing segment. You can optionally designate a cost center segment and/or intercompany segment. This is the most important step.

Navigation: General Ledger Super User Responsibility 
Setup à Financials à Flexfield à Keyà Segments

 3:  Entering Segment Values

We enter segment values which is valid for our application or organization. The valid value can be a phrase, word, abbreviation or numeric code. The valid value must conform to the criteria defined for the respective valid set.

Caution :
If you plan on defining summary accounts or reporting hierarchies, you must define parent values as well as child or detail values.
You can set up hierarchy structures for your segment values. Define parent values that include child values. You can view a segment value’s hierarchy structure as well as move the child ranges from one parent value to another. 

Navigation: General Ledger Super User Responsibility 
Setup à Financials à Flexfield à Keyà Values


4. Entering Account Combinations

This step is optional. Account combinations are part of Journal Transactions.
We can manually enter the new account combinations in a chart of accounts of a company using GL Accounts form. Anyhow, if we have checked the “Allow dynamic inserts” check box in segments for then we don’t need to worry about this step.

Navigation: General Ledger Super User Responsibility 
Setup à Account à Combinations


5. Creation of Account Alias:
This step is again optional. For input or Retrieve data about a transaction in Oracle General Ledger requires the complete Account Combination. But generally the account combination is large and very difficult to remember. Hence we define a short name (Alias) for the Account combination which we use widely.

Detail Explanation of this step is available in another article. Please click the below link

6. Define Flexfield Security Rules

This step is to prevent group of users from accessing specific segment values while data entry and in report parameters. This maintains the integrity of accounting data. The flexfield security rule is effective only when assigned to an appropriate responsibility.
However to restrict all the users from accessing the particular segment value we need to disable them in segment s form.

Navigation: General Ledger Super User Responsibility 
Setup à Financials à Flexfield à Keyà Security à Define


7. Define Cross Validation Rules

This step is required to maintain a consistent and valid set of account combination based on our business requirements. Cross validation rule prevent users from entering invalid account combinations. Cross validation rules validate only new account combinations hence it needs to be implemented before entering the chart of accounts.

Navigation: General Ledger Super User Responsibility 
Setup à Financials à Flexfield à Keyà Rules 


Part1 of this Post contains the below,

  1. Definition of Chart of Accounts
  2. Overview
  3. Graphical Representation 

9 Responses to “Chart of Accounts Implementation in Oracle Apps R12 (Part 2)”

ram said...
August 8, 2020 at 6:13 AM

good information
oracle training in chennai

ram said...
August 8, 2020 at 6:13 AM

good information
oracle training in chennai

siva said...
November 21, 2020 at 2:17 AM

Pretty blog, i found some useful information from this blog, thanks for sharing the great information.
why seo is important
how to improve pronunciation
advantages of html
automation testing tools selenium
salesforce interview questions
salesforce developer interview questions

zasma yasmin dawood said...
February 24, 2021 at 8:57 AM

click here: accounting ratios

zasma yasmin dawood said...
March 26, 2021 at 7:09 AM

Thanks for sharing this update. To avail accounting golden rules service please reach vakilsearch.

Unknown said...
July 8, 2021 at 5:12 AM

Grab Data Science Certification in Chennai for skyrocketing your career with Infycle Technologies, the best Software Training & Placement institutes in and around Chennai. In addition to the Certification, Infycle also gives the best placement training for personality tests, interview preparation, and mock interviews for leveling up the candidate's grades to a professional level.

Devi said...
July 10, 2021 at 8:49 AM

Learn Oracle DBA for making your career towards a sky-high with Infycle Technologies. Infycle Technologies provides the top Oracle DBA Training in Chennai and offering programs in Oracle such as Oracle PL/SQL, Oracle Programming, etc., in the 200% hands-on practical training with professional specialists in the field. In addition to that, the interviews will be arranged for the candidates to set their careers without any struggle. Of all that, Cen percent placement assurance will be given here. To have the best job for your life, call 7502633633 to Infycle Technologies and grab a free demo to know more.No.1 Oracle DBA Training in Chennai | Infycle Technologies

ram said...
October 5, 2021 at 5:24 AM

Infycle Technologies, the No.1 software training institute in Chennai offers the No.1 Big Data Hadoop Training in Chennai | Infycle Technologies for students, freshers, and tech professionals. Infycle also offers other professional courses such as DevOps, Artificial Intelligence, Cyber Security, Python, Oracle, Java, Power BI, Selenium Testing, Digital Marketing, Data Science, etc., which will be trained with 200% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7502633633 to get more info and a free demo.

October 24, 2021 at 7:31 AM

Grab the Digital Marketing Training in Chennai from Infycle Technologies, the best software training institute, and Placement center in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Cyber Security, Big Data, Java, Hadoop, Selenium, Android, and iOS Development, DevOps, Oracle, etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career.

Post a Comment


The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.