New and Enhanced Features in Oracle R12

New and Enhanced
Features in Oracle
R12
GL changes in Terminology
Release 11i Release 12
Global Accounting Engine Sub-ledger Accounting
Global intercompany system (GIS) Advanced Global Intercompany system

(AGIS)
Inter company accounts Intra – Company balancing
MRC Primary Set of Books Primary Ledger
MRC Reporting Set of Books Reporting Currency
Multiple Reporting SOB Secondary Ledgers
Set of books Ledger

SLA Accounting Engine
What is Accounting Setup Manager
Accounting Setup Manager is a new feature that streamlines the setup and
implementation of Oracle Financial Applications. The Accounting Setup Manager will
facilitate the setup required for simultaneous accounting for multiple reporting
requirements.
With the Accounting Setup Manager, you can perform and maintain the following
common setup components from a central location:
Legal Entities
Ledgers, primary and secondary
Operating Units, which are assigned to primary ledgers
Reporting Currencies
Intercompany Accounts and Balancing Rules
Accounting and Reporting Sequencing
Both Intercompany and Sequencing

Data Access to Multiple Legal Entities and Ledgers
You no longer have to constantly switch responsibilities in order to access the data in a
different ledger. You can access multiple ledgers from a single responsibility as long as all
ledgers share the same chart of accounts and calendar.
Simultaneous Opening and Closing of Periods for Multiple Ledgers

You no longer have to open and close periods for each ledger separately. You can now open
and close periods across multiple ledgers simultaneously by submitting Open and Close
Periods programs from the Submit Request form.
Simultaneous Currency Translation of Multiple Ledgers

You can run the Translation program for multiple ledgers simultaneously, if you are managing
multiple ledgers.
Financial Reporting for Multiple Ledgers

Now with this feature you can run Financial Statement Generator (FSG) reports for multiple
ledgers simultaneously. This is useful if you manage multiple ledgers and want to run a
balance sheet or income statement report for all of your ledgers at the same time.
Cross-Ledger and Foreign Currency Allocations
You are able to allocate financial data from one or more ledgers to a different target ledger.
This enables you to perform cross-ledger allocations, which is useful for purposes such as
allocating corporate or regional expenses to local subsidiaries when each entity has its own
ledger
Journal Copy
Now we can now copy entire journal batches. You can copy journal batches with any status.
The system will create a new journal batch containing the same journal entries.You may
also change the batch name, period, and/or effective date while copying the journal batch.
After copying the journal batch, you may modify the unposted journals in the same manner
as any manually created journals.
Streamlined Consolidation Mappings

You are able to define Chart of Accounts Mappings (formerly known as Consolidation
Mappings) between two charts of accounts.
The enhancement in R12 allows you to define mappings between charts of accounts
instead of between sets of books, so that they can be shared across multiple Consolidation
Definitions. You can also secure access to chart of accounts mappings using definition
access set security. This allows you to secure which users can view, modify, and/or use chart
of account mappings in consolidation definitions.
Replacement for Disabled Accounts
Normally when an account is disabled, you can prevent transactions that include the
account from erroring during journal import by defining a replacement account for the
disabled account. Journal import replaces the disabled account with the replacement
account and continue the journal import process if the replacement account is valid.
Data Access Security for Legal Entities and Ledgers

In R12, since you can access multiple legal entities and ledgers when you log into Oracle
General Ledger using a single responsibility, Oracle General Ledger provides you with
flexible ways to secure your data by legal entity, ledger, or even balancing segment values
or management segment values. You are able to control whether a user can only view data,
or whether they can also enter and modify data for a legal entity, ledger, balancing
segment value or management segment value.
Management Reporting and Security

This can be best understood as: You can designate any segment (except the natural account
segment) of your chart of accounts to be your management segment and use Oracle GL
security model to secure the management segment for reporting and entry of
management adjustments.
Sequence for Reporting

Maintaining two sequnces have been introduced, accounting and reporting sequencing.
Multi Org
In Release 11i, a user assigned to an Operating Unit (OU) would process data from the
products deployed in that OU. To process data for another OU, a user would log out of the
first and into the second.
In Release 12.0, by contrast, users can be assigned to multiple operating units, and are
supported by processes and transactions that can span operating units. Their data is book-
kept according to rules stored in a single accounting engine,and the accounting is stored in
subledger tables that are standard across all products.
New Features in Accounts
Payable
Supplier
We have seen in 11i
Suppliers defined in AP.
Supplier contacts replicated for
each supplier site.
Where as in R12
Supplier becomes as TCA Party.
Suppliers Sites as TCA Party
Site for each distinct address.
Contacts for each supplier/address , it

means Single supplier address and
contact can be leveraged by multiple
sites, for each OU
A single change to an address can be
seen instantly by all OUs
No longer need to manually 'push'
updates across OUs
Replacement for Disabled Accounts
Normally when an account is disabled, you can prevent transactions that include the
account from erroring during journal import by defining a replacement account for the
disabled account. Journal import replaces the disabled account with the replacement
account and continue the journal import process if the replacement account is valid.
Data Access Security for Legal Entities and Ledgers

In R12, since you can access multiple legal entities and ledgers when you log into Oracle
General Ledger using a single responsibility, Oracle General Ledger provides you with
flexible ways to secure your data by legal entity, ledger, or even balancing segment values
or management segment values. You are able to control whether a user can only view data,
or whether they can also enter and modify data for a legal entity, ledger, balancing
segment value or management segment value.
Management Reporting and Security

This can be best understood as: You can designate any segment (except the natural account
segment) of your chart of accounts to be your management segment and use Oracle GL
security model to secure the management segment for reporting and entry of
management adjustments.
Sequence for Reporting

Maintaining two sequnces have been introduced, accounting and reporting sequencing.
Invoice
Till 11i version, we have seen invoices:
Had only distributions line.
Allocation of freight and special charges are captured at the distribution level only
But in R12,
1. Invoice Lines as a new additional line accommodated in Invoice data model.
Because of introduction of invoice line there is significant improvement of data flow

Fixed Asset - Asset Tracking
Business Tax -Tax line
Payment - Payment
SubLedger Accounting - Accounting
2. Allocate freight and special charges are captured to the lines on the invoice
3. Invoice distributions created at the maximum level of detail similar to 11i.
4. Core functionality
Integration with Oracle E-Business Tax
In 11i
Oracle standard functionality was based out of User which determines tax by assigning Tax
Codes at line level of invoice and Tax rules was controlled at underline code.
There was global descriptive flex fields were captured for country-specific tax attributes.
More importance most of the setup performed at OU level.
In R12
A new module eBusinessTax determines tax based on facts about each transaction, this is
reason why Oracle has introduced additional line information at invoice level.
The module "ebusiness Tax" set and configure Tax rules which can be viewed
Tax attributes collected in fields on key entities
Configure tax rules once per regime and share with your legal entities
Differences In Assets
Added new Modules
E-business suite Tax
I-setups
Legal entity configurator

New and Enhanced Features in Oracle R12

Uploaded by

Copyright:

Available Formats

New and Enhanced Features in Oracle R12

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

New and Enhanced Features in Oracle R12

Uploaded by

Copyright:

Available Formats

New and Enhanced

Global Accounting Engine Sub-ledger Accounting

Global intercompany system (GIS) Advanced Global Intercompany system

MRC Primary Set of Books Primary Ledger

MRC Reporting Set of Books Reporting Currency

Multiple Reporting SOB Secondary Ledgers

Set of books Ledger

Ledgers, primary and secondary

Operating Units, which are assigned to primary ledgers

Intercompany Accounts and Balancing Rules

Accounting and Reporting Sequencing

Both Intercompany and Sequencing

Simultaneous Opening and Closing of Periods for Multiple Ledgers

Simultaneous Currency Translation of Multiple Ledgers

Financial Reporting for Multiple Ledgers

Streamlined Consolidation Mappings

Data Access Security for Legal Entities and Ledgers

Management Reporting and Security

Sequence for Reporting

Contacts for each supplier/address , it

Data Access Security for Legal Entities and Ledgers

Management Reporting and Security

Sequence for Reporting

Because of introduction of invoice line there is significant improvement of data flow

Added new Modules

E-business suite Tax

Legal entity configurator

You might also like