oracle e-business suite r12.1 general ledger overview...

<Insert Picture Here>

-1-For Oracle employees and authorized partners only. Do not distribute to third parties.

© 2009 Oracle Corporation – Proprietary and Confidential

Oracle E-Business Suite R12.1 General Ledger Overview Training Courseware

The following is intended to outline our general

product direction. It is intended for information

purposes only, and may not be incorporated into any

contract. It is not a commitment to deliver any

material, code, or functionality, and should not be

relied upon in making purchasing decisions.

Safe Harbor Statement



For Oracle employees and authorized partners only. Do not distribute to third parties.


relied upon in making purchasing decisions.

The development, release, and timing of any

features or functionality described for Oracle’s

products remains at the sole discretion of Oracle.

Use of this Site (“Site”) or Materials constitutes agreement with the following terms and conditions:

1. Oracle Corporation (“Oracle”) is pleased to allow its business partner (“Partner”) to download and

copy the information, documents, and the online training courses (collectively, “Materials") found on this

Site. The use of the Materials is restricted to the non-commercial, internal training of the Partner’s

employees only. The Materials may not be used for training, promotion, or sales to customers or other

partners or third parties.

2. All the Materials are trademarks of Oracle and are proprietary information of Oracle. Partner or other

third party at no time has any right to resell, redistribute or create derivative works from the Materials.

Oracle Training Materials – Usage Agreement



For Oracle employees and authorized partners only. Do not distribute to third parties.


3. Oracle disclaims any warranties or representations as to the accuracy or completeness of any

Materials. Materials are provided "as is" without warranty of any kind, either express or implied,

including without limitation warranties of merchantability, fitness for a particular purpose, and non-

infringement.

4. Under no circumstances shall Oracle or the Oracle Authorized Delivery Partner be liable for any loss,

damage, liability or expense incurred or suffered which is claimed to have resulted from use of this Site

of Materials. As a condition of use of the Materials, Partner agrees to indemnify Oracle from and against

any and all actions, claims, losses, damages, liabilities and expenses (including reasonable attorneys'

fees) arising out of Partner’s use of the Materials.

5. Reference materials including but not limited to those identified in the Boot Camp manifest can not be

redistributed in any format without Oracle written consent.

Key Content Contributors

Contributing Companies





R12.1: Oracle Financials

Oracle General Ledger Process

Accounting Setup Manager

Ledger

Basic Journal Entries

Accounting Setups

Summary Accounts

Advanced Journal Entries

Bootcamp Objectives



Advanced Journal Entries

Advanced Security

Financial Budgeting

Multi-Currency

Consolidations

Period Close

Financial Reporting

Data Access Security for Legal Entities and Ledgers

Explain key Advanced Security setups and process

Manage Data Access Sets

Control security of Management Reporting

Section Objectives




Access to Full Ledger

Ledger

Legal Entities

Access Level Read-Only to Full Ledger

US Corporate Ledger ($)

US East US West US South

Data Access Security for LE & Ledgers



(BSVs)

Actions:

Journals

Balances

Reports

• View Journals

• View Balances

• View Reports

US East(01)

US West

(02)

US South(03)


US Corporate Ledger ($)

US East US West US South

Access to BSVs

Read-Only Read/Write

Ledger

Legal Entities

Access Level



US East(01)

US West

(02)

US South(03)

• View, Create, Post Journals

• View and Update Balances

• View and Run Reports

• View Journals

• View Balances

• View Reports

(BSVs)

Actions:

Journals

Balances

Reports


Italy Statutory

Access to Multiple Ledgers

EMEA Corporate

Read-Write to Parts of Multiple Ledgers

Ledger

Legal Entities

Access Level



• View, Create and Post Journals

• View and Update Balances

• View and Run Reports

UK(11)

Italy

(12)

Italy(12)

(BSVs)

Actions:

Journals

Balances

Reports

Data Access Set - Journals Example

• Creating a Journal

–Create a journal for any ledger in your Data Access Set

• Viewing or Modifying a Journal

Data Access to Multiple LE & Ledgers



• Viewing or Modifying a Journal

–View or modify a journal for any ledger in your Data Access Set

•Modifying a Journal Batch

–Modify a journal batch if you have access to all ledgers used in the batch in

your Data Access Set





Section Objectives




Data Access Sets: Concept

• Specify read and write privileges to:– Entire Ledgers

– Specific Balancing Segment Values (a.k.a Legal Entities if BSVs assigned to Legal

Entities)

– Specific Management Segment Values

• Access multiple legal entities and ledgers from a single GL

responsibility



APAC Ledger

Ledger

Legal Entities

Access Level

EMEA Ledger

UK(11)

Italy(12)

China(21)

Single Responsibility

Data Access Set: Setup

Ledgers must share same COA/Calendar

combination

Assign ledgers and/or

COA must have management segment to use



Assign ledgers and/or ledger sets

Specify Read Only or Read/Write Access

Ledger Sets: Concept

• A ledger set is a group of ledgers that share the same chart of

accounts and calendar/period type combination.

• Ledger sets allow you to run processes and reports for multiple

ledgers simultaneously.

• Perform the following across ledgers:–Create Reports

• Report on One or All Ledgers in a Ledger Set Ledger 1



• Report on One or All Ledgers in a Ledger Set

–Open/Close Periods

• Open/Close Periods Independently or Simultaneously

–Create Journals• Allocations Across Ledgers

• Recurring Journals for All Ledgers

–Translate Balances• Translate Balances for All Ledgers

–View Information• No Changing Responsibilities

• View Journals and Account Balances

•

Ledger 2

Ledger SetLedger Set

Ledger 1

Ledger 4

Ledger 3

Ledger Sets: Setup







Section Objectives





By default the Data Access Set is created while the setup of Ledger is

completed and attached to GL Ledger Profile Option.

Data Access Set can be tailored as per the business needs which can

be based on

1.Complete Ledger Access

2. Specific BSV Access



3. Specific Management Segment Access with Read, Write and Full

Access.

GL: Data Access Set Profile option need to be updated while there is

a change in the Data Access Set.





Section Objectives




Management Reporting & Security

•Management Segment

–Optionally qualify a segment as the management segment to perform management

reporting

–Secure read and write access to Ledger/Management Segment Value combinations

using Data Access Sets



Management

Co CC Acct I/C

Balancing Cost Center Natural Account

Intercompany

Management Reporting & Security

Co CC Acct I/C

Primary Ledger

LE



OU97

OS69

OX53

Co CC Acct I/C

–Managers enter adjustments using their management

segment value

–Data access set security ensures managers only

update/view info. for their area of responsibility

oracle e-business suite r12.1 general ledger overview...

Documents