R12 Financials Overview

PDFPrintE-mail

There are many differences not only in the way that R12 handles your business, but also in the underlying structures of the Financials. Essentially, R12 was designed to accommodate global companies with different accounting requirements who need to allow their data to be shared among different entities. The most significant of these changes is that in R12, there is no concept of Sets of Books. Ledger and Ledger Sets together replace Sets of Books. The data of a Set of Books is contained in a ledger. The management of the set of books (open and closing, reporting, allocating, etc.) is now at the Ledger Set level A ledger and is defined by the 4 Cs: Calendar, Currency, Chart of Accounts (these should be familiar as the definition of a set of books), and Convention.

Convention refers to the Accounting Method (e.g. GAAP, IAS) used. From a single transaction ledger, you can generate rules that will populate different subledgers. For example, if you have different tax jurisdictions, you would have a ledger that would track the accounting and reporting necessary for each of the jurisdictions. You would only enter the transaction one time, and then populate that transaction to different ledgers depending on the rules that you create. Detailed transaction information is captured in the subledgers and periodically posted (in summary or detail form) to the ledger. Within the ledgers, you define accounting rules to comply with Sarbanes Oxley, providing an audit trail and easier reconciliation. You can balance at the subledger level.

Subledger Accounting allows you to define centralized rules and provides multiple accounting representations of a single transaction in multiple currencies. One of the main advantages is to be able to create a single payment transaction for different legal entities or different operating units and create a rule that allows that transaction to be credited and debited correctly without creating overrides and adjusting entries. A ledger owner might be a legal entity or a group of companies in a common legal environment, or a foreign branch. Ledgers are also used to consolidate financial transactions. Accounting entries can account for themselves in ledgers that are prepared under different conventions with different charts of accounts, and value transactions in different currencies. One of the ledgers is the primary ledger. A ledger set is a collection of ledgers that you wish to manage as though they were one ledger.

Many functions are available across ledgers:

  • Open/Close Periods
  • Create Journals
  • Translate and Revalue Balances
  • View Information
  • Submit Standard Reports
  • Submit Financial Statements

Another major change is the Multi-Org Access Control (MOAC). MOAC allows you to perform functions across operating units without changing responsibilities. A responsibility is no-longer tied to a single operating unit. Instead, from within HR, you can assign a list of operating units to a responsibility and assign security to that operating unit through a security profile. By setting the operating unit to null, you can import all transactions for all operating units through the open interface programs at the same time. You can also create and report on transactions that cross operating units or operate a shared services center with centralized processing.

In R12, the concept of legal entity has been enhanced. A legal entity exists in the outside world and may be regulated by different governing bodies (i.e. country, state, tax authority). A legal entity pays taxes, has bank accounts, and complies with different regulatory agencies. Transactions that occur between and across legal entities are intercompany transactions. Bank accounts are now associated with legal entities rather than with operating units, allowing for a single bank account to serve multiple operating units. Income statements and balance sheets are generated along with tax forms for every legal entity. In HR, there is the Government Reporting Legal Entity (GRLE) which represents the registered legal entity who is the employer in HR.

Add comment


Security code
Refresh

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Enter your email address to sign up for our Newsletter

Sign up now

captcha
TEChanges - Agility by Design

May Puzzle

David is often referred to as Rainman due to his peculiar ability to effortlessly figure out a certain date's day of the week. He recently displayed this talent when I asked him if there was a conflict with the upcoming Fuzzy Dice Conference and our weekly court-ordered community service. He asked the date of the convention. It was April 20th, 2012.

"Oh, that’s a Friday," he said, effortlessly. "And your sentences have you committed for the next few dozen Wednesdays so you'll be able to go." And of course he was right.

One day a few weeks ago I asked out loud in the office about the date June 5th. And of all people, my brother Tommy piped up and said "Oh, that's a Tuesday."

"That's right," said David.

Well how about Otcober 3rd?

"That's a Wednesday," said Tommy. Then I asked about Christmas Day 2012.

"Oh, that's a Tuesday." David nodded in agreement.

Do we now have two rainmen? Or had Tommy figured something out?

Show solution...

Solution

Here's what was going on. Tommy was using something called anchor dates. And these dates apply to each and every year. April 4th, or 4/4 we’ll call it from now on, June 6th or 6/6, 8/8, 10/10, 12/12, are all the same day of the week, each and every year.

So too are 5/9 and 9/5, May 9th and September 5th. So too are 7/11 and 11/7, and all the above dates are the same day of the week, as is the last day in February, Leap Year or not. And they’re all the same day as January 4th, it would otherwise be January 3rd, but this was a leap year, and that’s changes the anchor day from January 3rd to January 4th.

Tommy also knew that New Year's Day was a Sunday. He was sobered up by then. And he knew it was a Sunday because Christmas was a Sunday in 2011, so New Year's Day is a Sunday, so the Anchor Day for 2012, January 4th, has to be a Wednesday!

So if that's a Wednesday, then 4/4, 6/6, 8/8, 10/10, 12/12, 5/9, 9/5, 7/11, 11/7, and February 29th are all the same day of the week, and they're all Wednesdays. So when I ask for example, about October 3rd, he knew October 10th was a Wednesday, 10/10. So 10/3 must also be a Wednesday. 12/12 is a Wednesday in 2012, so it’s 12/26, which is two weeks later. So 12/25, or Christmas Day, must be a Tuesday.

Success Tips for Oracle Project Management

  • Create a standard for documentation at the beginning of your project, and hold team members accountable for completing documentation requirements as well as keeping them at and above the standards required.
  • Before promulgating user documentation or training, it’s also a good idea to choose a representative from the among the business users base to review materials first.
  • If you are not sure about the resources and budget required, obtain several estimates from people that have experience with the same size and scope of your project.
  • Be explicit, before beginning the project, what internal resources are required for execution. This includes people, infrastructure, hardware, and software.
  • Help the project champion understand the impact your project will have on the organization and how its successful completion will make him or her an internal hero or heroine for supporting it.
  • Break up your project into smaller projects (try for projects that can be completed in 4-6 months, especially early on) to get success and demonstrate momentum.
  • Make sure that your testing includes reports, upstream and downstream interfaces, customizations, enhancements, and workflows.
  • Ensure that comprehensive transition reports and meetings between departing and incoming personnel are completed.
  • Instead of spending time and resources implementing third-party reporting, consider consolidating multiple instances, moving to a global chart of accounts (CoA), and/or standardizing on a consistent calendar.
  • Include governance, risk, and compliance management as part of the project plan.
  • Finally, celebrate the successes. Too many projects focus on defects, failures, or small cost over-runs without looking at the big picture and what was accomplished.

The Analyst Corner

John Van Decker, Research VP of Gartner, states:

"A single chart of accounts allows consistency in financial reporting across the enterprise by standardizing on common metrics and reporting structures, reduces dependencies on a separate financial consolidation system, and significantly reduces the costs incurred with ongoing, complex conversions and translations."