Wednesday, 15 June 2011

Chart of Accounts Implementation in Oracle Apps R12

Chart of Accounts Implementation in Oracle Apps R12 

Part of this Post contains the below,

  1. Definition of Chart of Accounts
  2. Overview
  3. Graphical Representation 
Definition from Wikipedia:
Chart of accounts (COA) is a list of the accounts used by an organization. The list can be numerical, alphabetic, or alpha-numeric. The structure and headings of accounts should assist in consistent posting of transactions. Each nominal ledger account is unique to allow its ledger to be located. The list is typically arranged in the order of the customary appearance of accounts in the financial statements, profit and loss accounts followed by balance sheet accounts. 

This post will introduce the process flow for creating a chart of accounts. The chart of Accounts defines the accounting structure of the organization. This structure includes every aspects of the business like business units, accounts, products, services, geographical locations etc. Further COA also tells us about how the elements of the structure combined to form the account combination.

  1. Accounting combinations defined in Chart of Accounts is used to various transactions happening in the organization.
  2. Helps in generating account balances.
  3. Helps in Reporting
  4. Helps in Analyzing financial information
  5. Many more … 

Basic Steps Involved in Implementation:

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

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.

Let us see how we can create Account alias for the combination
“Vision Distribution.0110.000.100300.0000.00000.00000.0110” as “FuelAcc”

1. Navigation:

2. Shortand Alias Form

3. Click the Find icon in the toolbar to choose the Accounting Flexi field 


This will automatically populate the Application, structure, flexifield title, descriptin fields as below.

 4. Next populate the Shorthand related specifications like below,

 5. Next populate the tab “Aliases, Description” as below,

 6. Next we need to populate the tab “Aliases,Effective” as below


7. Next Step is to save and Transaction. While saving we will be shown  a note window to recompile the flexifield using segments form. This is an important step to see our changes

 All the above information is stored in database table named FND_SHORTHAND_FLEX_ALIASES

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 


post signature


Anonymous said...

I just could not go away your site before suggesting
that I really loved the standard info a person provide for your guests?

Is gonna be back ceaselessly in order to inspect new posts

Feel free to visit my blog post: know more

Anonymous said...

For the reason that the admin of this site is working, no doubt very soon it will be
well-known, due to its quality contents.

Check out my web site: home inspection Gauteng

Anonymous said...

Hello! Do you know if they make any plugins to safeguard against hackers?
I'm kinda paranoid about losing everything I've worked hard on.
Any recommendations?

Here is my web-site :: paint protection Cape Town
My web page :: paint protection Cape Town

Anonymous said...

I don't know whether it's just me or if perhaps everybody else experiencing
problems with your website. It looks like some of the written text on your posts
are running off the screen. Can somebody else please provide feedback and let me know if
this is happening to them as well? This could be a problem with my browser because I've had this happen previously. Thanks

Here is my blog - newborn photography West Midlands

Anonymous said...

Thanks for sharing your thoughts about corporate travel agencies.

Feel free to surf to my web site ... more information

Anonymous said...

You are so cool! I do not think I've truly read anything like that before. So nice to discover another person with unique thoughts on this topic. Seriously.. many thanks for starting this up. This web site is something that is required on the web, someone with a little originality!

My web site - Visit Link

Anonymous said...

Hey there! I'm at work surfing around your blog from my new iphone 3gs! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the fantastic work!

Feel free to visit my website ... more information

Anonymous said...

Hi there colleagues, its wonderful post regarding educationand entirely explained,
keep it up all the time.

Feel free to visit my homepage :: Visit link

Anonymous said...

Ahaa, its nice conversation on the topic of this article here at this web site, I have read all that, so at this time me also commenting at this place.

Anonymous said...

Thanks for a marvelous posting! I definitely enjoyed reading it, you will be a great author.
I will always bookmark your blog and will often come back at some point.
I want to encourage continue your great posts, have a nice holiday weekend!

Feel free to surf to my homepage ... site

Anonymous said...

Havе you ever сonsidered аbout including a little
bit morе than juѕt your articles?
I mean, whаt уou sаy iѕ important
and all. Hoωеѵer thinκ about if you added ѕome gгeat picturеs or ѵideos to give
your postѕ more, "pop"! Υоur
content is excellent but with imаgeѕ and ѵiԁeos, this
blog could cеrtainlу be оnе оf the very best in
іts niche. Great blog!

My blog ...

Anonymous said...

Cаn I juѕt ѕay what а relief to find
an inԁivіԁual who rеally understands
whаt thеy're discussing on the net. You certainly know how to bring an issue to light and make it important. More people should check this out and understand this side of your story. I can't believe you
aгen't more popular because you most certainly possess the gift.

Feel free to surf to my web site; Ipad Repair Pulau Pinang

Anonymous said...

It's very easy to find out any matter on net as compared to textbooks, as I found this paragraph at this web site.

my web-site iphone repair selangor

Anonymous said...

At thiѕ moment I am gоing awaу to ԁο
my brеаκfast, once haνing mу brеаkfаst сoming οver agaіn to
read other nеws.

my page :: Price cut Charges Inns in Bali

Anonymous said...

Wow, incгeԁible blog format! How long have you eveг
been blogging for? you make blogging glance eаsy.

The whole glаnсе οf your web site is great, let alone the cοntent!

Μy wеb site: Best spots inside European countries regarding class ski getaways

Anonymous said...

ӏ rеally like уour blog.. very nice cοlors & thеme.
Did you сreate thiѕ websitе уourself οr did уou hire someone to
do it for уou? Plz аnsωer back аs I'm looking to design my own blog and would like to know where u got this from. cheers

my webpage ... compare most Inexpensive hotel premiums

Anonymous said...

Everуthіng is very open ωith a very clear
ԁеscription of thе challenges. It was truly informatiѵе.

Your ѕіte is eхtгemely helpful.
Thаnks for shaгing!

My blοg - Last minute Hotel Reservations

Anonymous said...

Wow, this post is good, my sister is аnalyzing ѕuch things, therefore I аm going to
infоrm her.

Неrе is my website: Accomodations For Guests And Travelers For You To Morocco Mole

Anonymous said...

Everything is very open with a clear description of
the challenges. It was definitely informative.

Your website is very helpful. Thanks for sharing!

My blog post: prom hairstyles

Anonymous said...

I need to to thank you for this wonderful read!! I absolutely enjoyed every little bit of it.

I have you book-marked to check out new things
you post…

Here is my site forex trading online :: ::

Anonymous said...

Hello there! Do you use Twitter? I'd like to follow you if that would be okay. I'm
definitely enjoying your blog and look forward to new updates.

Feel free to visit my web-site; herbal hair loss treatments

Anonymous said...

We stumbled οѵer hеre from a diffeгent web
page and thought I shоuld сhecκ thіngs
out. I lіke ωhat I seе ѕo i am just follοwing you.
Look forward to еxplоring youг ωеb ρаge for a sеconԁ

My web ѕіte ... Traveling Miami - We Have The Best Cheap Hotels

Anonymous said...

Hi to every body, it's my first pay a visit of this web site; this website consists of remarkable and in fact excellent material for readers.

Also visit my webpage ... top web hosting services ()

Anonymous said...

Hi there, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam
remarks? If so how do you stop it, any plugin
or anything you can advise? I get so much lately it's driving me insane so any help is very much appreciated.

Also visit my homepage milky way hair

Anonymous said...

I do not even know the way I finished up here, but I
assumed this put up was good. I do not realize who you're but definitely you are going to a well-known blogger when you are not already. Cheers!

Feel free to surf to my web-site :: fap turbo forum

Anonymous said...

Use social media buttons on all your web pages connecting to
the social media pages. Content in the form of blogs, audio, video, comparisons, reviews, tweets and
messages help to share information in a less formal way that builds knowledge
and confidence and ultimately influence decision-making.

Let's imagine that you're being really pro-active and trying to
save time, so you find a tool like Hoot - Suite that makes it so you
can post to all of your networks at once. If customer send and ask you in a
post, do not forget to answer it. It the Prince and Princess had announced their plans in advance, we wouldn't have cared so much and there wouldn't have been so much speculation.

They will claim to provide you a front page ranking inside
a few days or a week.

my weblog ... buy instagram followers

Anonymous said...

Perhaps in the future, as Viddy continues to grow, its cloud server will be able to accommodate longer video uploads.
I was excited to go everywhere and meet my
fans and experience different places. I have always liked to flick through portfolios of
wedding photographers every now and then out of professional curiosity.
He's done his best to show everyone that he's a big kid now by dating slightly older
star Selena Gomez, whom he has been on plenty
of overnight trips with, and by collaborating with older musicians like Chris Brown.
Mc - Carron and girlfriend Katherine Webb smile happily as they pose together.
Offer incentives to customers who send referrals-Referrals
can be your greatest source for new customer acquisition.

Feel free to visit my webpage: buy instagram followers

Anonymous said...

If some one needs expert view concerning running a blog after
that i recommend him/her to pay a visit this webpage, Keep
up the pleasant work.

Feel free to visit my web site; bad hair **