Oracle e-Business Financial

Mahmoud Elemam – blog

R12: What are Ledger Sets, when they are used and how to define them?

Posted by Mahmoud Elemam on January 9, 2011

What are Ledger sets?
Ledgers sets allow you to group multiple ledgers together to achieve processing efficiencies. For example, you can open or close periods for multiple ledgers simultaneously, translate balances for all ledgers in a ledger set, run recurring journals that update balances for multiple ledgers, or run consolidated financial reports that summarize balances across multiple ledgers in a ledger set.

All ledgers in a ledger set must share the same chart of accounts and accounting calendar/period type combination. They do not have to share the same currency. This allows you to group the primary or secondary ledgers with their associated reporting currencies to reduce maintenance efforts and streamline processing.

Note: Both the source ledger and its reporting currency (Journal and Subledger level) must have the same open periods to prevent problems during posting in General Ledger.

When Ledger Sets are used?
Some of the General Ledger features that benefit from the use of ledger sets are as follows:
• Translation and Revaluation: Translate balances and run revaluation across multiple ledgers in a ledger set.

• Open and Close Periods: Open and close periods for multiple ledgers within a ledger set from a single operation.
• Reporting: Submit standard reports and Financial Statement Generator (FSG) reports across multiple ledgers in a ledger set.
The added benefit of using ledger sets in FSG reports is to aggregate data and create summarized balances across multiple ledgers in a ledger set.
• Inquiry: Perform online inquiry on account balances or journals across multiple ledgers in a ledger set from a single view; drill down to the journal details and subledger transaction for each ledger.

How to define Ledger Sets?
To define a ledger set:
1. Navigate to the Ledger Set window.
2. Enter a name for the Ledger Set, a Short Name for the ledger set,(Optional) Enter a Description for the ledger set.
3. Choose a Chart of Accounts.
4. Choose a Calendar and Period Type.
5. (Optional) Specify a default ledger. The default ledger automatically defaults in all windows where the Ledger field is required.
Note: A Default Ledger is required for Financial Statement Generator (FSG).
6. (Optional) Select the Enable Security checkbox to secure the Ledger Set definition. If you do not enable security, all users who have access to this definition will be able to use, view, and modify the ledger set definition.
If the Assign Access function is available for your responsibility, the Assign Access button will be enabled once you select the Enable Security checkbox. Choose the Assign Access button to assign the definition to one or more Definition Access Sets with the desired privileges. For more information, see Definition Access Sets, page 1-136.
If the Assign Access function has been excluded from your responsibility, you will be unable to view the Assign Access button in the Ledger Sets window. You can still secure the Ledger Set definition by selecting the Enable Security checkbox, but only Definition Access Sets that are AutoAssigned will be automatically assigned to this Ledger Set. See your System Administrator for more information on Function Security.
7. In the Ledger/Ledger Set column, choose the ledgers and/or ledger sets to be included in the ledger set. Only those ledgers and ledger sets that share the same chart of accounts, calendar, and period type specified for the ledger set definition will be available.
If you use reporting currencies (journal or subledger level), you can choose reporting currencies to be included in the ledger set. Only those reporting currencies that share the same chart of accounts, calendar, and period type specified for the ledger set definition will be available
8. Save your work. The General Ledger Accounting Setup Program will be submitted.
Ensure this program completes successfully. Once saved, a ledger set cannot be deleted. You can only add or remove ledgers and ledger sets from ledger sets.

Note: You must have at least one ledger or ledger set assigned to a ledger



38 Responses to “R12: What are Ledger Sets, when they are used and how to define them?”

  1. Hi,

    First I would like to thanks for inputs on Ledgerset. I have quick in this regard.

    1) As per your explanation the usage of ledger set we can run reports or Open periods. But while trying open periods , I am not able to see the ledger set name. I am able to see the only vision operation ledger name. I am in GL Vision operations. is I need to setup any profile options ? please help me by providng the information to my email id which mentioned in the above.

  2. Trading Point…

    […]R12: What are Ledger Sets, when they are used and how to define them? « Oracle Application Financial[…]…

  3. Your site is really interesting to me and your topics are very relevant. I was browsing around and came across something you might find interesting. I was guilty of 3 of them with my sites. “99% of site owners are doing these five HUGE mistakes”. You will be suprised how simple they are to fix.

  4. click here said

    This blog site has got some extremely helpful info on it! Cheers for informing me!

  5. Oracle world said

    Very good stuff…a follow up question ~ say your client wants to “reduce” the amount of ledgers (and corresponding OU’s) in the process….what is the steps to do manage to such a project. In essesnce: to go from 14 “ledgers” to 1 or 2 ledgers”in R12

  6. Diana said

    Hi mahmoud

    your site is very interesting,, I want make sure your statement above “All ledgers in a ledger set must share the same chart of accounts and accounting calendar/period type combination” so it can’t use for difference chart of account? any idea to run FSG cross ledger??
    My company have 3 ledger which account segment is sharing for all ledger, just intercompany segment that difference. Could you help me to create FSG cross ledger so I just make one row set for three ledger in one time??


  7. Anand Patil said

    Thanks for the information. I have defined a Ledger Set, now how do I open the period for all the Ledgers included in that set. Can you help me out in doing this.

    When i click on open period, it just shows me the individual ledgers not the Ledger Set. Is there any other form to do this.

    Waiting for your response.


  8. seo said

    Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

  9. click here said

    now I clearly understand ecommerce

  10. Martin said

    whoah this weblog is fantastic i really like studying your articles.
    Keep up the good work! You know, a lot of persons are searching around for
    this information, you could aid them greatly.

  11. I have read so many articles concerning the blogger lovers however this article is really a pleasant paragraph, keep it up.

  12. wonderful issues altogether, you just won a new reader.
    What may you recommend about your post that you simply made some
    days ago? Any positive?

  13. Do you mind if I quote a few of your articles as long as I provide
    credit and sources back to your site? My website is in the exact same area of interest as yours and my visitors would really benefit from
    a lot of the information you present here.
    Please let me know if this alright with you. Regards!

  14. propecia said

    I want to to thank you for this excellent read!! I absolutely enjoyed every bit of it.
    I’ve got you book marked to look at new things
    you post…

  15. Cleveland said

    Hi there! This article could not be written any better!
    Looking at this post reminds me of my previous roommate!
    He continually kept talking about this. I am going to forward
    this post to him. Pretty sure he’ll have a very good read.

    I appreciate you for sharing!

  16. Loreal said

    Wonderful post! We will be linking to this particularly great article on our
    website. Keep up the great writing.

  17. Oh my goodness! Amazing article dude! Thank
    you so much, However I am having troubles with your RSS.

    I don’t know the reason why I cannot subscribe to it.
    Is there anyone else having similar RSS issues?
    Anybody who knows the solution can you kindly respond? Thanks!!

  18. I need to to thank you for this great read!! I certainly enjoyed every little bit of it.

    I have you saved as a favorite to check out new stuff you post…

  19. Hi I am so thrilled I found your weblog, I really
    found you by accident, while I was looking on Bing for something else, Regardless I am here now and would just like to
    say thanks for a fantastic post and a all round interesting blog (I also love the theme/design),
    I don’t have time to read through it all at the moment but I have
    bookmarked it and also added your RSS feeds, so when I have time I will be
    back to read much more, Please do keep up the awesome work.

  20. Useful information. Fortunate me I found your site by chance, and I’m surprised
    why this coincidence didn’t took place in advance!
    I bookmarked it.

  21. An intriguing discussion is worth comment. I believe that you should publish more on this subject, it might not be
    a taboo subject but generally people do not talk about these issues.
    To the next! Kind regards!!

  22. I was curious if you ever thought of changing the structure of your blog?
    Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content
    so people could connect with it better. Youve got an awful lot of text for only having one or
    2 images. Maybe you could space it out better?

  23. Do you mind if I quote a few of your posts as long as I provide credit and
    sources back to your site? My blog site is in the exact same niche as yours and my users would truly benefit from
    some of the information you present here. Please let me know if this alright with you.

  24. Thanks a bunch for sharing this with all folks you really realize what you’re talking
    about! Bookmarked. Kindly also talk over with my website =).

    We will have a hyperlink trade agreement among us

  25. I was suggested this web site by my cousin.
    I’m not sure whether this post is written by him as nobody else
    know such detailed about my problem. You’re incredible!

  26. sildenafil said

    Great weblog here! Also your site quite a bit up fast!

    What host are you using? Can I get your
    associate link in your host? I desire my site loaded up as quickly as yours lol

  27. Pretty! This has been an incredibly wonderful post.

    Thanks for providing this information.

  28. hair loss said

    Hi there it’s me, I am also visiting this web site on a regular basis, this web site is really
    good and the users are actually sharing pleasant thoughts.

  29. champix said

    This site certainly has all of the information and facts I wanted concerning this subject and
    didn’t know who to ask.

  30. levitra UK said

    Hi to all, the contents existing at this website are genuinely awesome for
    people experience, well, keep up the nice work fellows.

  31. Howdy, I believe your website might be having web browser compatibility problems.
    Whenever I look at your site in Safari, it looks fine however, when opening in I.E., it has some overlapping issues.
    I just wanted to give you a quick heads up! Besides that, wonderful site!

  32. You really make it seem so easy along with your presentation
    but I in finding this matter to be really something which I feel I might by
    no means understand. It kind of feels too complicated and very
    vast for me. I’m looking ahead on your subsequent post,
    I’ll try to get the hang of it!

  33. Wow, fantastic weblog format! How lengthy have you been blogging for?

    you made blogging glance easy. The entire glance of your web site is magnificent, let alone the content material!

  34. Your mode of telling everything in this piece of writing is genuinely
    fastidious, all can easily understand it, Thanks a

  35. I like the valuable information you provide in your
    articles. I’ll bookmark your blog and check
    again here regularly. I am quite sure I’ll learn plenty of new stuff right
    here! Best of luck for the next!

  36. BATH ROOM said

    Hello! I could have sworn I’ve been to this website before but after going
    through a few of the posts I realized it’s new to me. Anyhow,
    I’m certainly delighted I stumbled upon it and I’ll be bookmarking
    it and checking back regularly!

  37. ftvgirls password

    R12: What are Ledger Sets, when they are used and how to define them? « Oracle e-Business Financial

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: