GL_Training_Presentation_01010101010.ppt

Oracle General Ledger
General Ledger
Oracle Applications
R12 General Ledger Functional Training

Oracle General Ledger
Agenda
•Overview on Oracle General Ledger
•Chart of Account Structure
•Calendar
•Currency
•Ledger
•Data Access Set
•Definition Access Set
•Summary Accounts
•Rollup Groups
•Flexfiled Security Rules
•Cross Validation Rules
•Cross Validation Rules (VS) Flexfiled Security Rules
•Journals
•Recurring Journals
•Mass Allocation
•Intracompany and Intercompany Journals

Oracle General Ledger
Agenda
•Journal Approval
•Budgets
•Revaluation
•Translation
•Multiple Reporting Currency
•Consolidation
•Financial Statement Generator (FSG)
•Standard Reports and Listings
•Period and Year-End Closing Process

Oracle General Ledger
Overview on Oracle General Ledger

Oracle General Ledger
WHAT IS GENERAL LEDGER?
Oracle General Ledger (GL) is:
The central repository of all financial transactions.
At the heart of any accounting system.
A tool, for integrating sub-ledger activity, consolidating group-wide accounts and releasing
statutory/analytical financial reports.
A comprehensive financial management solution that enhances financial controls, data collection,
information access, financial reporting and analysis throughout an enterprise.
Enables rapid implementation, easy adoption from legacy systems, accurate and timely transaction
processing, improved enterprise decision support and increased operational efficiency with quick
closing procedures.
In a nutshell, the data recorded in GL is reviewed, manipulated and analysed.

Oracle General Ledger
Overview of General Ledger
Oracle General Ledger is a comprehensive financial management solution that facilitates the
following tasks:

Oracle General Ledger
Overview of General Ledger

Oracle General Ledger
Overview of General Ledger Integration

Oracle General Ledger
Integration with Subledgers

Oracle General Ledger
GL Integration With Other Oracle Financials Suite
Assets, Payables and Receivables handle money and generate GL
transactions. These are closely integrated with GL.
Purchasing, Order Entry and Inventory generate transactions with financials
implication and are integrated with other three modules.
For example:
To purchase office equipment, a PO is raised in Oracle Purchasing.
When the equipment arrives and the invoice is received, the PO is closed and a liability is recorded in
Oracle Accounts Payable.
Oracle Payables sends information to Oracle Assets on the asset purchased. The asset is recorded
in Oracle Assets where all the asset details are captured and depreciation is initiated.
Payment for the equipment purchased is recorded in Payables, which knocks off the liability.
The data recorded in all these sub-ledgers is transferred to GL
The events or financial transactions are entered only once whether in GL or in sub-ledgers.

Oracle General Ledger

Chart of Account Structure

Oracle General Ledger
CHART OF ACCOUNTS
Chart of accounts: -
Chart of accounts uses Key Flexfield (Accounting Flexfield) that, comprises
Segments, Value sets, Values and Code Combination ID.

What is a Flexfield?
All the forms and reports are designed to be flexible and to accommodate many
kinds of business rules for a wide variety of situations. Along with the innumerable
predetermined fields that appear on each screen, most screens can accommodate
the entry of additional information through the use of flexfields.
A flexfield is a field made up of sub–fields, or segments. A flexfield appears on
your form as a pop–up window that contains a prompt for each segment. Each
segment has a name and a set of valid values.
The following terms are used for both key and descriptive flexfields:
. Segment
. Value, Validation (Validate), Value set
. Structure

Oracle General Ledger
DEFINING CHART OF ACCOUNTS
Defining the Chart of accounts:
•Planning the Chart of accounts structure is the most important activity involving the
structure, segments, segment Validation and additional features.
•Analyze the organizational structure and the dimensions of the business before designing
the Chart of accounts. By carefully evaluating the business needs, design the chart of
accounts to take advantage of General Ledger’s flexible tools for recording and reporting
the accounting information.

Oracle General Ledger
The account structure can comprise 30 segments with a maximum character length of 275 for the entire String.
Each string of multiple-segments is called a code combination and stores a code combination ID based on which
balances are maintained in GL. An accounting chart normally consists of Company code, Line of Business,
Cost center, Natural Account, Intercompany and Future.
Defining Key Flexfield Structures
Define descriptive information and validation information for each segment.
Determine the appearance of your key flexfield window, the number and order of the segments, and the segment
descriptions and default values.
Freeze flexfield definition and save the changes once set up or when the structures/segments are
modified. On saving, Flexfield compiles automatically to improve on–line performance.
Compile the flexfield every time when the changes are made to this form, including enabling or disabling
 cross–validation rules and when the changes are made to the shorthand aliases window.
Oracle Applications submits one or two Concurrent requests to generate database views of the flexfield combinations
table.
The flexfield changes immediately after freezing and recompiling. However, the changes affect other users
only after they change responsibilities or exit the application and sign back on.
DEFINING CHART OF ACCOUNTS

Oracle General Ledger
To Determine the Account Structure That Best Suits Your Organization:
Examine the organization structure to identify how performance and profitability are
normally measured.
Also multiple organizational structures may be needed to allow views of the organization
from multiple perspectives. Summary accounts can be used to roll up details.
Visualize each segment of the account as a unit dimension of the business. Combine units
that are based on similar dimensions to avoid using multiple segments that measure the
same dimension.
Identify the functions, products, programs, funding sources, regions, or any other business
dimensions that are to be tracked
Determine the reporting needs.
Defining Chart of Accounts

Oracle General Ledger
Consider the following questions before defining the account structure:
What information will better help one to manage one’s organization?
What are the different ways in which one can look at one’s operations?
What kinds of reports do managers ask for?
What reports one prepares now with some difficulty?
What reports are provided by other financial information systems?
What statistical reporting does one want to perform?
Is project reporting needed?
At what levels of detail does one produce reports?
Defining Chart of Accounts

Oracle General Ledger
Steps to Define a Accounting Flexfield
 Plan the flexfield.
Structure, Value sets, segments, prompts, order.
 Define and set up the value sets.
Check to see if there is a value set already defined that would meet
your needs.
 Define and set up the structure and the segments.

Example : Operations Accounting flexifield

Oracle General Ledger
 Make sure that the flexfield is enabled.
 Choose a segment separator.
 Decide if Cross-Validation will be used on this flexfield.
 Click the Freeze Rollup Groups check box.
 Click the Allow Dynamic Inserts check box.
 Freeze and compile the flexfield
 Define the values for the value sets, if appropriate.
Steps to Define a Accounting Flexfield

Oracle General Ledger
2. Defining Value Sets
•Use value sets to control the format and characteristics of the
Accounting Flexfield segment.
Balancing Segment
Format:
Char
Maximum
size: 3
Validation:
Independent
Value_
Set 2
Cost Center Natural
Account
Format:
Char
Maximum
size: 4
Validation:
Independent
Value_
Set 3
Format:
Char
Maximum
size: 2
Validation:
Independent
Value_
Set 1
Format:
Char
Maximum
size: 2
Validation:
Independent
Value_
Set 1
Intercompany
Segment
The same value set can be used more than once in
the same Accounting Flexfield structure.

Oracle General Ledger
DEFINING VALUE SET
Enter the Value
Set Name
Enter the
segment name
(N): Setup > Financials > Validation > Sets

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Select the List
Type
List of Values- User
will not see a poplist
Long List of Values
-Requires the user to
enter a partial
segment value
before the list of
values retrieves all
available values.
User will not see a
poplist.
Poplist-
To provide a poplist
Guidelines for the
List Type:
Poplist:
<= 10 values
List of Values:
> 10 and <= 200
values
Long List of
Values:
> 200 values

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Select the Security
Type / No Security
Hierarchical
Security:
If the security is
defined at the Parent
level, then all the Child
Values under that
Parent are also
secured.
Non-Hierarchical
Security:
Security rule that
applies to a parent
value does not
"cascade down" to its
child values.

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Select the
Format Type

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Choosing Format Types:-
Since a value set is primarily a ”container” for the values, value sets are to be defined in such a way that it
can control the types of values that are allowed into the value set. The format type is the format for the
segment or parameter value. The format type of an existing value set cannot be changed. All of these
format options affect both the values that are entered in the Segment Values windows and the values that
are entered in flexfield segments and report parameters.
The valid format types are:
Format TypeDescription
Character Used for alphanumeric and special characters; even numbers and date behave as characters/text
Date Time Enforces a date-time format depending on the maximum value set size; treated and sorted as
date-time values. Format: DD-MON-RR-HH24:MI / DD-MON-RR-HH24:MI:SS
DD-MON-YYYY-HH24:MI / DD-MON-YYYY-HH24:MI:SS
Number Only numeric value; all leading zeroes and plus signs are suppressed;behaves as a
number;different than numbers only option for Character.
Standard Date
Time
User defined
Time Enforces a time format depending on the maximum value set size; treated and sorted as time
values.Format: HH24:MI/HH24:MI:SS
Date Enforces a date format depending on the maximum value set size; treated and sorted as time
values.Format: DD-MON-RR / DD-MON-YYYY
Standard Time User defined
Standard Date User defined

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Select Numbers
Only if
Alphanumeric is
not to be allowed
Select Uppercase only
for allowing
Alphanumeric
Select Right-justify & Zero-fill
Numbers for uniformity in
numbers
Select the Maximum &
Minimum Values for
Defining a Range
Restriction
Select the Maximum
Size of the Values
under the Value Set
Enter the No of
Decimal Places
Required (Only for
Format Type
Numbers)
The Value Set Size
must be less than or
equal to the size of the
underlying segment
column in the flexfield
table. Values never
change, but descriptions
can.

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Select the Validation
Type for the Value Set
For Dependent,Translatable
Dependent, Table, Special or
Pair value set, choose the Edit
Information button to open the
appropriate window; Enter any
further information required for
your validation type

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Value Set Options Format Options Validation Type
Name Format Type Independent (requires Predefined Independent Values; list of values)
Description Maximum Length (maximum length upto
which the user can enter the value)
Dependent (requires predefined values that are dependent on an independent
value selected in the prior segment of the flexfield; list of values)
No Security/
Hierarchical Security /
Non-Hierarchical
Security
Precision (No of decimals required) None (user enterable values)
List of Values / Long
List / Pop List
Numbers Only? (Only 0-9, +, -) Table (Predefined Values read from an application table; list of values)
Uppercase Only? (Alphabets in upper
case only)
Special
Right-justify and Zero-fill Numbers?
(Applicable only to numeric values; used
only for sorting and ordering numbers or
to ensure that all numeric values have
the same no of characters)
Pair (requires high and low pair of values; list of values)
Minimum Value (Both min and max
values are used to define the range of
values beyond which the user cannot
enter values)
Translatable Independent (Same as independent but translated value can be
used; values security, roll up groups cannot be defined)
Maximum Value Translatable Dependent (Same as dependent but translated value can be used;
values security, roll up groups cannot be defined)

Oracle General Ledger
DEFINING FLEXFIELD STRUCTURE
Select
Application
Select
Title

Oracle General Ledger
DEFINING FLEXFIELD STRUCTURE (CONTD…)
To
Freeze/Unfreeze
the Flexfield
To Enable Cross
Validation rules
To Enable
Dynamic Insert
To
Freeze/Unfreeze
Rollup Groups
Enter Short
Name, Title and
Description
To Compile Each
Time Changes
Are Made to the
Structure

Oracle General Ledger
DEFINING FLEXFIELD STRUCTURE (CONTD…)
Select or Enter the
Custom Segment
Separator
Click on Segments to Open the
Segments Window

Oracle General Ledger
DEFINING SEGMENTS
Enter the Order of
the Segments
(Sequential Only)
Enter the
Segment Name
Enter Window
Prompt (Form)
Select the Column
(Out of 30)
Select the
Value Set
Click Here to Define
the Value Set
Click Here to Add
further Features to
the Value Set
Your segment name
should begin with a
letter and use only
letters, numbers,
spaces or underscores
( _ ).

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Enter the
Segment
Description
Enter the Display
Size and Prompt
Information here
This Field Should be
Checked if the Value
Set is Mandatory
Indicate that this flexfield
segment is to be used by
checking the Enabled
check box. Flexfield does
not display disabled
segments.
Indicate whether you
want this segment to
appear in the flexfield
window. If your segment
is not displayed, you
should provide a default
type and value
Decide whether you
should check the Indexed
check box. GL uses the
Indexed field for the
Optimization feature
This Field should
be Checked to
Enable the
Security Rules

Oracle General Ledger
DEFINING VALUE SET (CONTD…)
Select the Default
Type and Value if the
Enabled check is off.
Enter the
Default Value
Based on the
Default Type
Selected
To allow the flexfield to
validate this segment value
against another segment value
in this structure, choose either
Low or High in the Range
field. Segments with a range
type of Low must appear before
segments with a range type of
High (the low segment must
have a lower number than the
high segment). If one chooses
Low for one segment, then one
must also choose High for
another segment in that
structure (and vice versa).
Otherwise you cannot compile
your flexfield.
Click Here to Enter
the Flexfield Qualifier
Segment:The default value is the value entered in a prior
segment of the same flexfield window.
Constant: The default value can be any literal value.
Field: The default value is the current value in the field
you designate in the Default Value field. The field must
be in the same form as the flexfield.
Profile: The default value is the current value of the user
profile option defined in the Default Value field.
SQL Statement: The default value is determined by the
SQL statement you define in the Default Value field.

Oracle General Ledger
DEFINING VALUE SET (CONTD…FLEXFIELD QUALIFIER)
Check These
Boxes Based
on the Qualifier
to be Attached
to the Segment
Cost Center Segment: To be checked against the
segment defined for capturing Cost Centers
Natural Account Segment: To be checked against
the segment defined for capturing Natural Accounts
Balancing Segment: To be checked against the
segment at which a Balanced Trial Balance needs
to be generated
Intercompany Segment: To be checked against
the segment defined for ensuring that Balancing
Segment is balanced.

Oracle General Ledger
DEFINING VALUES
Select the
Options Which
You Want to
Use for Finding
and Entering
the Values
Enter the
Parameters
Here
Enter the
Parameters
Here
Click on Find
to Search

Oracle General Ledger
DEFINING VALUES (CONTD…)
Enter the Valid Value
Here –
Could be
numbers,words,
abbreviation etc.Once
saved these can’t be
deleted
Enter the Value
Description Here
To be Checked for
Enabling / Disabling
the Value.
Enter the Journal
Effective Dates for
Which the Value
Needs to be
Enabled
Click here for
Finding Further
Values
For value set type Translatable
Independent or Translatable Dependent,
the Translated Value field is enabled. The
value from the previous step defaults in.
Translated Value for all installed
languages can be updated using the
Translation icon in the Toolbar.

Oracle General Ledger
DEFINING VALUES (CONTD…)
Check for all
Parent Values
Select Whether
Budgeting and Posting
are to be allowed. –
Yes / No
For Defining Child
Ranges under
Each Parent
For Moving Child
Ranges between
Parents
For Viewing
Hierarchies based
on Parent-Child
Relationship
Some key flexfields
use segment
qualifiers to hold
extra information
about individual key
segment values.
ex the Accounting
Flexfield uses
segment qualifiers to
determine the
account type of an
account value or

Oracle General Ledger
DEFINING VALUES (CONTD…PARENT-CHILD RELATIONSHIP)
Enter the
Range of
Values
Select Whether the
Range to Include
Child Values or Parent
Values Only

Oracle General Ledger
DEFINING VALUES (CONTD…NATURAL ACCOUNTS)
Select the Roll Up
Values here
Select the Natural
Account Qualifier
Select Whether
Budgeting and Posting
are to be allowed. –
Yes / No
Types of Natural
Account Qualifier
Select Whether the
Account is to be
Reconciled or a Control
Account– Yes / No

Oracle General Ledger
Parent Values
Total Assets
Child/
Parent Values Fixed Assets Current Assets
Land Buildings Cash Bank Stock
Child Values
COA - Parent and Child Values
Define account hierarchies for reporting and analysis

Oracle General Ledger
Defining Calendar

Oracle General Ledger
Accounting Calendar
We need to create a calendar to define an accounting year and the periods it contains.

Oracle General Ledger
Defining the Accounting Calendar:
Create a calendar to define an accounting year and the periods it contains.
One should set up one year at a time, specifying the types of accounting periods to include in each
year.Defining one year at a time helps in more accuracy and reduces the amount of period
maintenance done at the start of each accounting period.
One should define the calendar at least one year before the current fiscal year.
One can define multiple calendars and assign a different calendar to each set of books. Calendars
created are validated online. Full calendar validation is launched whenever you exit the Accounting
Calendar window.
Carefully consider the type of calendar for the organization, since it can be difficult to change
your calendar once you’ve used it to enter accounting data.
Accounting Calendar

Oracle General Ledger
An Accounting Calendar consists of Accounting Periods associated with a Period Type.
 Period types control the number of Accounting Periods per fiscal year. Period types could be
Month, Quarter, Year etc.,
Accounting Calendar
Name Type Year Period Qtr From To
Jan-08 Month 2008 1 1 01-Jan-0831-Jan-08
Feb-08 Month 2008 2 1 01-Feb-0828-Feb-08
Mar-08 Month 2008 3 1 01-Mar-0831-Mar-08
Apr-08 Month 2008 4 2 01-Apr-0830-Apr-08
May-08 Month 2008 5 2 01-May-0831-May-08
Dec-08 Month 2008 12 4 01-Dec-0831-Dec-08
Accounting Calendar

Oracle General Ledger
Before you can enter journal entries, you must maintain your calendar flow. Each accounting
period has one of the following five statuses.
Open PeriodOpen Period
Closed PeriodClosed Period
Permanently Permanently
Closed PeriodClosed Period
Never Never
OpenedOpened
Future Future
EnterableEnterable
Accounting Calendar

Oracle General Ledger
Defining Calendar- Period Type
Enter the Period Type
Name – This is What
Picked up when defining
Accounting Calendar
Enter the Year Type
to specify whether
the period is part of
a fiscal
or calendar year.
Enter the
Period
Description
Enter the No of Periods
Per Year – 4,12,52,366
etc.
General Ledger uses the year type to
assign a year
in the accounting period system name
when you set up your calendar.
Calendar: to use the year in which an
accounting period begins for the system
name.
Fiscal: to use the year in which your fiscal
year ends for the system name.

Oracle General Ledger
Defining Calendar- Accounting Calendar
Enter Number of the
Period in the Year.
Ex. Jan – 1, Feb –2, Mar
–3 etc.
Check if Any Period
has been Defined as
an Adjusted Period.
(ex. 13 Periods: 12
periods + 1 Adjusted
Period)
Enter the From and
To Date for each
Period
Enter the Quarter
No in Which the
Period Falls
Ex. Jan- Mar – 1,
Apr-Jun –2 etc.
Enter the
Year
Select the Period
Type from the Period
Types defined earlier
Enter the
Period Name
Prefix
Enter the
Calendar Name
and Description
Assigned automatically;
The Period Name =
Prefix + Fiscal/Calendar
Year (YY)
Adjusted Period is
normally the Period
where all year end
accounting
adjustments are
passed before year
closure. Normally this
Period will have the last
date of the Fiscal year
as the From and to
Date.

Oracle General Ledger

Define and Maintain Currencies

Oracle General Ledger
Defining Currencies
You can define and enable a variety of currencies to allow you to enter transactions in
multiple currencies.
You can Define unlimited number of Currencies.
SGD Francs
Yen Pounds

Oracle General Ledger
Defining Currencies
Enter the Unique
Currency Code for the
Currency
Enter the Name and
Description for the
Currency
Select the Currency
Issuing Authority
Precision:
to designate the
number of digits to
the right of the
decimal point used in
regular currency
transactions.
Extended Precision:
to designate the
number of digits to
the right of the
decimal point used in
calculations for this
currency.
Enter the Currency
Symbol

Oracle General Ledger
Defining Currency (Contd…)
Enter Effective Dates for the
currency. Only transactions
denominated in this currency for
dates within the range can be
entered. If start date is blank, the
currency is valid immediately. If end
date is blank , the currency is valid
indefinitely.
Enable the Currency
to Start Using the
Same.

Oracle General Ledger
Rate Types
Predefined Rate Types:
Oracle General Ledger provides the following predefined daily conversion rate types.
•Spot
•Corporate
•User
New Conversion Rate Types:
Use the Conversion Rate Types window to define a new conversion rate type.

Oracle General Ledger
Rate Types
(N): Setup > Currencies > Rates > Types

Oracle General Ledger

Accounting Setup Manager Concepts

Oracle General Ledger
ACCOUNTING SETUP MANAGER CONCEPTS
Main, record-keeping ledger
Defined by 4Cs:
›Chart of accounts
›Accounting calendar
›Primary currency
›Sub ledger Accounting Method
Optional, additional accounting
representations of your primary
ledger
Can differ in one or more of the
following from the primary
ledger:
›Chart of accounts
›Accounting calendar
›Primary currency
›Subledger Accounting Method

Oracle General Ledger
ACCOUNTING SETUP MANAGER CONCEPTS
SLA
Transaction
Accounting
Subledger Transactions
SLA
Corporate Ledger
(Primary Ledger)
Local Statutory Ledger
(Secondary Ledger)
AP AR FA
Other
Subledgers
Legal Entity
Maintaining Multiple Accounting Representations with Secondary Ledgers

Oracle General Ledger
If difference is
only currency,
ACCOUNTING SETUP MANAGER CONCEPTS – REPORTING CURRENCY

Business Learning Center
Use a Secondary Ledger
CurrencyCorporate
Chart of accounts
Monthly
Calendar
Accounting
Method
US GAAP
Accrual
Use Reporting
Currencies

Oracle General Ledger
Ledger Architecture
A ledger provides balanced ledger accounting for the accounting entity and serves as the
repository of financial information.
A ledger determines the currency, chart of accounts, accounting calendar, ledger
processing options and subledger accounting method.
Support for multiple reporting requirements for global companies.
Cross/Multiple-Ledger Operations and Reporting.
•Share data and perform operations across multiple legal entities/ledgers
•When security and independence is preferred, secure data and allow certain
processes to be performed independently.
Management Reporting Efficiency.
There are two types of ledgers:
 Primary
 Secondary.

Oracle General Ledger
Overview of Primary Ledger
The primary ledger acts as the main record-keeping ledger.
Primary ledger is defined with the chart of accounts, accounting calendar, and currency
that is suited for the business need.
The Ledger represent the core
of a company’s records where
transaction flows through

Oracle General Ledger
The secondary ledger is an optional, additional ledger that is associated with the primary
ledger for an accounting setup.
Secondary ledgers can be used to represent your primary ledger's accounting data in
another accounting representation that differs in one or more of the following from the
primary ledger:
• Chart of accounts
• Accounting calendar/period type combination
• Currency
• Subledger accounting method
• Ledger processing options
Secondary ledgers can be used in many ways. For example, If a legal entity is a
subsidiary of a parent company and must produce its financial results according to
the parent company's reporting requirements in addition to its own local reporting
requirements, then a secondary ledger may be used to satisfy the additional
reporting requirement.
Overview of Secondary Ledger

Oracle General Ledger
Secondary ledgers can be maintained at the following data conversion levels:
Secondary Ledger

Oracle General Ledger
Overview of Ledger Sets
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.
You can group all types of ledgers in a ledger set , such as
•Primary ledger,
•Secondary ledgers, and
•Reporting currencies (journal and sub ledger levels).
as long as they share the same
chart of accounts and
calendar/period type combination.
The same ledger can belong to multiple ledger sets, and ledger sets can contain other ledger
sets.

Oracle General Ledger
•Open/Close Periods
•Create Journals
•Translate and Revalue Balances
•View Journals and Account Balances Across
Ledgers
•Submit Standard Reports
•Submit Financial Statements
Overview of Ledger Sets

Oracle General Ledger
Ledger Set Benefits
1.Shorter Close Process.
Run month-end close processes across multiple ledgers simultaneously.
2.Greater flexibility to decentralize/centralize accounting functions.
The corporate office can control the period status for multiple subsidiaries at once.
3.Real-Time Enterprise-Wide Visibility.
Quickly report across the entire enterprise in real-time because no transfer of data
is required
Reported results are accurate and timely because they are based on the
transactional system, not a data warehouse.
4.More Efficient Access to Ledger Data.
No need to change responsibilities to access data in different ledgers.

Oracle General Ledger
4.Processing Efficiency.
Essentially treats multiple ledgers as one and eliminates the overhead of having a
high number of ledgers defined.
Reduces the number of repetitive tasks that offer limited value and allows you to
spend more time on value-added tasks.
5. Reporting Efficiency.
Obtain “flash” reports throughout the accounting cycle to proactively manage the
business instead of waiting until the end of the month when the data collected is
backward looking.
Ledger Set Benefits

Oracle General Ledger
Ledger Set
Grouping of ledgers with the same chart of accounts and calendar/period type
combination
Essentially treats multiple ledgers as one

Oracle General Ledger

Data Access Set

Oracle General Ledger
Data Access Sets
Data access sets control which ledgers can be accessed by different responsibilities.
Data access sets can also limit a user from accessing certain balancing segment values or
management segment values or grant read–only or read and write access to data in a
ledger. The ledgers and ledger sets assigned to a data access set must share the same chart
of accounts, calendar, and period type.

Oracle General Ledger
Ledgers must share
same COA/Calendar
combination
Assign ledgers and/or
ledger sets
Specify Read Only or
Read/Write Access
Data Access Sets

Oracle General Ledger
Definition Access Set

Oracle General Ledger
Definition Access Sets allows you to secure shared General Ledger definitions such as
MassAllocations, Recurring Journal Formulas, and Financial Statement Generator (FSG)
components.
Definition Access Sets allow you to:
• Assign a user or group of users access to specific definitions.
• Specify what actions can be performed on secured definitions for a user or group of
users.
• Grant one or more of the following privileges to responsibilities
View Access: Allows you to view or query a definition in the Define form, but you
cannot modify the definition
Modify Access: Allows you to view and modify a definition in the Define form.
You
can also change the definition access set security for that definition.

Use Access: Allows you to use a definition.

Definition Access Sets

Oracle General Ledger
Definition Access Set

Oracle General Ledger
Ledger & Ledger Set
Definition Access Set
Solution
Data Access Set
New Architecture Summary in R12
• Reporting Across Entities
• Efficient Processing
• Access to Multiple Ledgers
• Setup & Maintenance
• Definition Security
• Independent Open/Close
• Read/Write Access
• Access to Multiple Ledgers
Issue

Oracle General Ledger
Key GL Setups

Oracle General Ledger
Defining Journal Sources
If journal approval is enabled
for the set of books and one
enters a journal whose journal
source requires journal
approval, the batch must be
approved before it can be
posted.
If this is checked, journals from this
source cannot be changed in the Enter
Journals window. If one subsequently
unmark this checkbox, one can make
changes to journals from this source.
Choose whether to Import
Journal References from
feeder systems to maintain a
mapping of summarized
transactions if summary
journal option is used at the
time of running Journal
Import.
Enter the Source
Name and Description
(Average Balance Processing
only) select an Effective Date
Rule for this journal source:
•Fail: Journal Import will reject
transactions when the
effective date is not a valid
business day. No posting
takes place.
•Leave Alone: Journal import
will accept all transactions
regardless of the effective
date.
•Roll Date: Journal Import will
accept the transaction, but roll
the effective date back to the
nearest valid business day
within the same period. If there
is no prior valid business day
within the same period, the
effective date is rolled forward.
Source appears in the
Journal Header to identify the
JV to a feeder system / sub-
ledger

Oracle General Ledger
Defining Journal Categories
Enter the Category
Name and Description
Category appears
in the Journal
Header to
segregate JVs
based on the
nature of JV
ex. Year End,
Provisions,
Adjustments etc.

Oracle General Ledger
Flexfield Additional Features – Shorthand Aliases
Shorthand flexfield entry allows to enter key flexfield data quickly by using shorthand aliases to represent valid
flexfield combinations or patterns of valid segment values. A shorthand alias is a word or code that represents a
complete or partial key flexfield combination.
Shorthand flexfield entry helps you satisfy the following data entry needs:
Enter key flexfield data quickly by associating shorthand aliases with frequently–used sets of valid key flexfield
segment values.
Associate either complete or partial flexfield combinations with shorthand aliases.
For each key flexfield structure, one can define as many shorthand aliases as one needs.
If the shorthand aliases are changed, they take effect immediately.
If Shorthand Flexfield Entry is enabled and the Flexfields:Shorthand Entry profile option is set to an appropriate value,
the shorthand window allows to enter an alias before the flexfield window opens. The combination/partial combination
defined for the alias is entered into flexfield window.
Invalid values cannot be entered into a single segment of a shorthand alias, but the Shorthand Aliases window does
not identify invalid combinations of segment values in an alias. If one defines aliases that contain values that become
invalid later, the flexfield detects these invalid values at the time the alias is used in the flexfield window.Flexfield then
does not allow to enter the invalid values.
Flexfield also checks the alias against security and cross–validation rules.
Changing your key flexfield structure after defining aliases
If the key flexfield structure is changed after defining aliases, the existing aliases have to be changed to match the
new structure.
Changes that make existing aliases invalid include: changing the order of segments, adding/disabling/changing
segment lengths
Whenever one enables or disables shorthand entry, the key flexfield should be recompiled. Shorthand flexfield entry
can be enabled/disabled user-wise by setting user profile option Flexfield: Shorthand Entry to an appropriate value.

Oracle General Ledger
Flexfield Additional Features – Shorthand Aliases (Contd...)
Enable and enter the
Window Prompt. Enter the
maximum alias size,
which determines the
maximum length of the
shorthand aliases.
Select the Application, Flexfield
Title and Structure Name
(COA)
Give the Alias Name,
Account Details in the
Shorthand Template
and Alias Description.
One can define the
complete or partial set of
key flexfield segment
values (the template) that
each shorthand alias
represents. These values
can be valid flexfield
combinations or different
patterns of valid segment
values.

Oracle General Ledger
Flexfield Additional Features – Shorthand Aliases (Contd...)
If the alias is to be effective for
a limited time, one can enter a
start date and/or an end date
for the alias. The alias is valid
for the time including the From
and To dates.
Uncheck the Enabled check box,
or set either From to a date later
than today or To to the date of
the
last day the alias should be valid.
If the Enabled check box is
unchecked, the alias is disabled
regardless of the effective dates
given. This can be enabled
again.

Oracle General Ledger
Summary Accounts

Oracle General Ledger
SUMMARY ACCOUNTS
A summary account is an account whose balance is the sum of balances from multiple detail
accounts. Use summary accounts to Perform online summary inquiries, as well as speed the
processing of financial reports, Mass Allocations, and recurring journal formulas.
Planning your summary accounts:
Determine the summary account needs and Plan the summary account structure to meet those
needs.
Plan the parent segment values and rollup groups needed for summary accounts.
Plan summary account templates to generate multiple summary accounts.

Oracle General Ledger
Determining summary account needs:
Consider the summary information needed for reports. One can use summary accounts for faster access
to summarized balances.
Identify the summary balances needed for online inquiries.
Consider how to use summary accounts in formulas and allocations:
•Use summary accounts to reference summary balances in a recurring journal formula.
•Use summary accounts to reference summary budget balances in a budget formula.
•Use summary accounts when entering budgets with budget rules.
•Use summary accounts to indicate the total amount to allocate when defining allocation formulas.
Also, use summary accounts to help calculate the allocation ratios to use in allocation formulas.
Choose ways to summarize accounting information depending on the structure of account and
informational needs.
For any organizational dimension one wants to summarize, determine how many summarization levels
are needed within that dimension. After considering how to summarize within each of the organizational
dimensions, think about how to combine the summary views across different organizational dimensions.
Consider whether to create these summary relationships with summary accounts, or with reporting
hierarchies. One can achieve the benefits of summary reporting with reporting hierarchies instead of
summary accounts.To define parents for each of the account segments, organize the account structure to
use ranges to easily define the children for the parent values.
SUMMARY ACCOUNTS

Oracle General Ledger
Determining the parent values and rollup groups:
Plan the parent segment values. When determining the values of parents for each account
segment, consider the structure of values within that segment.
If the segment values are logically organized and the child values for parent are all in a contiguous range, a
logical value for the parent is the first or last value in the range; reserve the first or last value in the ranges for
a summary value.
If the segment values do not follow a particular structure, and allows alphabetic characters, one can use
alphabetic characters for parent values. The alphabetic characters not only distinguish the parent values from
detail values, but they can also provide some description for the parent value.
Define the parent segment values, and enter meaningful segment value descriptions.
Choose a naming or numbering method for rollup groups that is similar for all segments to establish
a more memorable and logical rollup group structure. This consistent rollup group structure helps
you know the approximate level of detail the parents in rollup groups provide.
Planning Summary Account Templates
Set up templates to define and maintain summary accounts. One can enhance the speed of
summarizations by controlling the number of summary accounts created by the template, which
depends on the template segment values.
SUMMARY ACCOUNTS

Oracle General Ledger
Entering Summary Account Templates
From the Summary Accounts window, enter the summary account Template using one of the
following values for each segment:
D: Template creates and maintains a summary account for every detail segment value. This value
creates the most summary accounts of any
template value.
T: Template creates and maintains a summary account that sums balances of all detail segment
values. This value creates the fewest summary
accounts of any template value. If one enters T for a segment, all summary accounts created by the
template will have the value T for the segment.
Therefore, the value T must be defined and enabled for the segment. Also, the segment value must
be a parent and detail posting and budgeting
are not allowed.
[Rollup Group Name]: The template creates and maintains a summary account for each parent
segment value assigned to the rollup group
specified. The more parent segment values in a given rollup group, the more summary accounts your
template creates.
If one make changes to the flexfield hierarchies that affect summary accounts, run the Incremental
Add/Delete Summary Templates program to
update the summary account balances else the changes to the account hierarchies and rollup group
assignments are ignored.
Maintain Summary Templates Program Use this program to ensure that summary account
balances reflect new detail accounts that may have
been added to that summary account.
SUMMARY ACCOUNTS

Oracle General Ledger
GL submits a concurrent
request to add the
summary accounts, and
displays the Status of the
summary template.
Current: The summary
accounts are active.
Adding: The concurrent
request to create
summary accounts is
pending or running.
Deleting: The concurrent
request to delete summary
accounts is
pending or running.
Enter the Summary Account
Name, Template definition and
Description
Enter Earliest Period from
which the Summary Template
is to be used. GL maintains
summary account balances for
this accounting period and for
subsequent periods.
SUMMARY ACCOUNTS

Oracle General Ledger
Overview on Summary Accounts
By using Summary accounts you can view the balances at Parent Account level
Summary accounts store the sum of the balances of groups of detail accounts.
Define Rollup Groups to capture different summary levels for each Parent and Child Segments.
Detailed Revenue Account A…..10,000
Detailed Revenue Account B…….3,000
Detailed Revenue Account C…….2,000
}
Summary Revenue Account……….15,000

Oracle General Ledger
Detail vs Summary Accounts
–Detail Accounts:
•allow direct posting of business transactions and journals.
–Summary Accounts:
•are updated when journals are posted to a corresponding detail account.
•enable online summary inquiries, including account inquiry on the detail
accounts that compose the summary amount.
•speed concurrent processing, eliminating the need to sum the account
balances of groups of detail accounts during runtime.

Oracle General Ledger
Rollup Groups

Oracle General Ledger
FLEXFIELD ADDITIONAL FEATURES – ROLL UP GROUPS
Select the Value Set Name for
which Roll Group is to be
defined
Enter the Roll Up Group
Code, Name and
Description; The Code is
what is to be Selected
against each Parent Value.
A rollup group is used to
identify a group of
parent values for
reporting or other
application purposes.
Key flexfield segment
values are assigned to
rollup groups using the
Segment Values window.
Rollup groups are used
to create summary
accounts for reporting
purposes.

Oracle General Ledger
Rollup Groups
Rollup Group Rollup Group Level 1
Level 2
Rollup Group
Child Values
Level 2.1 Level 2.2
Child Child
Child Child
Example
Total Assets
Fixed Assets Current Assets
Cash Buildings Land Bank

Oracle General Ledger

Flexfiled Security Rules

Oracle General Ledger
FLEXFIELD ADDITIONAL FEATURES – SECURITY RULES
Select the Application
and the Responsibility
to which the Rule is to
be assigned
Select the Security
Rule Name defined
earlier.

Oracle General Ledger
Flexfield Security Rules
Restrict a responsibilities data entry and online inquiry to specific values by using flexfield security
rules.
Include
Exclude
Available
Values
Unavailable
Values
#’s 0000 to 9999
#’s 1000 to 3999
0000 to 0999 4000 to 9999
1000 to 3999
Account Segment

Oracle General Ledger
Defining Flexfield Security Rules

Oracle General Ledger
Cross Validation Rules

Oracle General Ledger
FLEXFIELD ADDITIONAL FEATURES – CROSS VALIDATION RULES
What is Cross–Validation?
A cross–validation rule (CVR) defines whether a value of a particular segment can be combined with
specific values of other segments.
CVR is used to prevent the creation of combinations that should never exist. A key flexfield can perform
automatic cross–validation of segment values according to the rules an organization defines for
customizing the key flexfield.
CVR can be used to closely control the creation of new key flexfield combinations, and for maintaining
a consistent and logical set of key flexfield combinations.
When a user finishes entering segment values in a flexfield pop–up window, the flexfield checks
whether the values make up a valid combination before updating the database. If the user entered an
invalid combination, a diagnostic error message appears, and the cursor returns to the first segment
assumed to contain an invalid value.
CVR controls combinations of values within a particular key flexfield structure. CVR applies to
combinations users attempt to create using either the combinations form or foreign key forms (using
dynamic inserts).

Oracle General Ledger
CVR and Existing Combinations
CVR has no effect on existing combinations and continues to treat them as valid since the existing
combinations pre–date the rule. However, if end user tries to create a new combination that violates
the new CVR, the flexfield returns an error message and rejects the combination.If previously–
existing combinations are no longer valid according to the CVR, one can always manually disable
those combinations using the combinations form.
Changing an existing key flexfield structure may adversely affect the behavior of any CVR one has
for that structure.One should be sure to manually disable or redefine any CVR to reflect the changed
structure.
Each CVR contains one or more rule elements, where each element is a key flexfield range that
specifies low and high values for each segment. One identifies a rule element as either Include or
Exclude.
Include means include all values in the specified segment ranges,and Exclude means exclude all
values in the specified segment ranges. Every cross–validation rule must contain at least one Include
rule element. Exclude rule elements override Include rule elements.
Determine in which segment the cursor should be placed when a key flexfield combination fails a
validation rule. Choose the segment that will most likely be in error. The error message and the
segment to which the cursor returns should correspond.
Avoid rules that control cross–validation across more than two segments, where possible.
FLEXFIELD ADDITIONAL FEATURES – CROSS VALIDATION RULES

Oracle General Ledger
Flexfield Additional Features – Cross Validation Rules (Contd...)
Select the Application, Title
Name and Structure Name
Enter the CVR
Name, Description
and Enable the
same
Enter the Error
Message, Error
Segment and The
CVR Effective dates
Enter the Include /
Exclude Rule Elements
and the Low/High
Range of values

Oracle General Ledger

Cross Validation Rules (VS) Flexfiled Security Rules

Oracle General Ledger
Cross-Validation Rules (VS) Flexfield Security Rules
Cross Validation Rules
•Specific to Code Combination.
•Chart of Account Specific.
•Can View Data.
•Appears in List of Values.
•Block the creation of Account
Code Combination.
Flexfield Security Rules
•Specific to Segment Value.
•Responsibility Specific.
•Cannot View that particular
Segment Data.
•Does not appears in List of Values.
•Operational Hierarchy.

Oracle General Ledger
Process Journals

Oracle General Ledger
Journals
1.Overview on Journals
2.Types of Journals
3.Journal Creation Methods
4.Journal Components
5.Journal Batch
6.Manual Journals
7.Reversing Journal Entries
•Overview on Reversing Journal Entries
•Journal Reversal Prerequisites
•Automatic Journal Reversal
•Assigning a Reversal Period to a Journal Entry

Oracle General Ledger
Overview on Journals
General Ledger supports a variety of journal entry types to meet your business and accounting
requirements.
In General Ledger, there are four basic journal entry types. Each journal entry type has expanded
functionality we will explore in this presentation.
•Manual Journals
•Reversing Journal Entry
•Recurring Journal Entry
•Mass Allocations

Oracle General Ledger
Journal entries with common attributes can be organized into batches.
There can be multiple journals in one batch, or separate batch for each journal entry.
All journal entries in a batch must share the same period.
A journal batch can be created for any Open or Future Enterable Accounting period, but
journal batches in Open accounting periods can only be posted.
Journals can be entered directly also without the Batch mode. GL will create a batch for
the entry automatically.
Overview on Journals

Oracle General Ledger
Types of Journals
Manual Journal Entry
Reversing Journal Entry
Used for most accounting transactions. Examples
include Revenues, Expenses, Adjustments, and
Reclassifications
Created by reversing an existing journal entry.
You can reverse any journal entry and post it to
the current or any future open accounting period.

Oracle General Ledger
Types of Journals
Recurring Entries
Mass Allocations
Defined once then generated for each subsequent
accounting period. You can use recurring journal entries
to define automatic consolidating and eliminating
entries.
Journal entries that utilize a single journal entry formula to
allocate revenues and expenses across a group of cost
centers, departments, divisions, and so on.

Oracle General Ledger
Journal Creation Methods
Manual
Entries
Reversing
Entries
Recurring
Entries
Mass
Allocations
Create adjusting journals and
accruals
Reverse an error, revaluation,
encumbrance journal, and
accruals
Create journals using fixed
accounts and amounts and
complex formulas. Create
multiple journals with the
same/similar information.
Allocate from one account to
many using a single formula
Enter debits and credits
manually
Reverse the journal amounts
of a pre-existing entry
Create journals using a
skeleton template, standard
template, or formula
Calculate journals using an
allocation formula

Oracle General Ledger
Journal Creation Methods
Journal Wizard
Journal Import
Integrate General
Ledger with an Excel
Spreadsheet for
journal creation
Upload journal entries
from an Excel
spreadsheet
Integrate General
Ledger with other
applications
Import journal
information from
feeder systems

Oracle General Ledger
Journal Components
Journal information is stored in three Oracle General Ledger tables.
Enter JournalsEnter Journals
GL_JE_BATCHESGL_JE_BATCHES GL_JE_HEADERSGL_JE_HEADERS GL_JE_LINESGL_JE_LINES

Oracle General Ledger
Journal Batch
You can organize journal entries with common attributes into batches. Examples of
common attribute groupings include:
•Journal type
•Journal date
•Journal preparer
The use of journal batches is optional. You can enter a journal directly.
Batches can contain an unlimited number of journal entries
All journal entries in a batch must share the same period

Oracle General Ledger
Manual Journals
A Manual Journal Entry is a journal entry that you enter directly into Oracle General Ledger.
Manual journal entries can include the following
•Standard Journal.
•Foreign currency entries
•Statistical entries
•Tax Journal Entries

Oracle General Ledger
Manual Journals – Standard
Journal Header
Journal Lines

Oracle General Ledger
Manual Journals – Standard

Oracle General Ledger
Journal Entry
Click Here
To Enter A
New Journal
Or Batch
Click Here To Find
An Existing Journal
Or Batch Based On
The Parameters
Entered Above
Enter The
Parameters Here
To Find An Existing
Journal Quickly.

Oracle General Ledger
Journal Entry
Enter the Unique Journal Name,
Journal Header Description,
Select the Period and Enter the
Effective Date
Select the Category.
Source will be
Manual as the JV is
being created
Manually
Balance Type:
A: Actual
B: Budget
Here the Budget
Name Needs to be
Selected
Click here to
enter the
Code
Combination
Enter the JV
Line Nos
Here the Transaction
Currency has to be
entered. If it is not
the SOB currency,
then the Conversion
Rate type and the
Conversion Rate
needs to Captured
Enter the Debit /
Credit Amounts here
Enter the JV Line
Description here
Enter the DFF here
Click here to Post, Change
Period/Currency or Reverse
a posted Journal

Oracle General Ledger
Journal Entry
Select the
Short Hand
Account Alias

Oracle General Ledger
Journal Entry
Select the Code
Combination

Oracle General Ledger
Journal Entry
Click here to
Reverse the
Posted
Journal
A Posted JV
can only be
Reversed
Once.
Click here to
Post the
Journal
Click here to Change
the Period of
Unposted Journal

Oracle General Ledger
Journal Entry
Click here to Select the
two options of Reversing -
Switch Dr/Cr or Change
the Signs
This shows
the Status of
the Reversal
Click here to Reverse the
Posted Journal and Select
the Period of Reversal

Oracle General Ledger
Journal Entry - Posting
Select the Batch for
Posting
Click here to Review the
Batch before Posting and
Enter Additional JVs under
this Batch
Click here to Post the
Selected Batch

Oracle General Ledger
Journal Entry – Posting
Click here to Review the
Journals before Posting and
Enter Additional JVs Click here to Post the
Batch/Change Period
This shows the
Batch Details

Oracle General Ledger
Manual Journals - Foreign currency entries

Oracle General Ledger
Manual Journals - Statistical entries

Oracle General Ledger
Manual Journals - Tax Journal Entries

Oracle General Ledger
Overview on Reversing Journal Entries
You can use reversing journal entries to reverse accruals, estimates, errors, or temporary
adjustments and reclassifications.
First period:
Amounts are added.
Next period:
Amounts are subtracted.

Oracle General Ledger
Dr. Rent Expense…….…10,000 functional dollars
Cr. Cash…………….10,000 functional dollars
CreateCreate
ReversalReversal
Dr. Cash…….…...10,000 functional dollars
Cr. Rent Expense……...10,000 functional dollars
Creating Reversing Journals
Generate a reversal of any journal entry.

Oracle General Ledger
Automatic Journal Reversal
•Use Automatic Journal Reversal if you routinely generate and post large numbers of journal
entries, such as for month end closing and opening procedures.
•Automatic Journal Reversal saves time by automatically generate and post reversal journals.
•(N) Reports > Request > Standard
•Define auto reverse criteria by journal category
•Enter Actual journals with journal categories that have auto reverse criteria defined
Methods to Auto Reverse Journals
Navigate to the Submit Request window and submit the Automatic Reversal program
Set the profile option GL: Launch Auto Reverse After Open Period, to Yes and open the next
period
Navigate to the Reverse Journals window to launch the Automatic Reversal program

Oracle General Ledger
Automatic Journal Reversal

Oracle General Ledger
Assigning a Reversal Period to a Journal Entry

Oracle General Ledger
Journal Entry Reports
Entered Currency Journals Report
Journals Reports
General Journals Reports
Journal Batch Summary Report
Journal Entry Report
Journals Line Report
Journals by Document Number Report
Tax Journals Report

Oracle General Ledger
Importing Journals
Journal Import can be used to integrate information from other applications such as payroll, AR, AP and FA
with GL.
For each accounting period, one can import accounting data from these feeder systems, then review, update
and post the journal entries.
One can also use Journal Import to import historical data from previous accounting system.
GL_INTERFACE Table
The GL_INTERFACE table is where Journal Import receives accounting data that is imported from other systems.
An import program can be defined to import data from a non–Oracle system, or to import historical data from
previous Accounting system. The import program should convert data from the feeder system into a standard data
format that Journal Import can read from the GL_INTERFACE table.
When Journal Import receives this data, it validates and converts the import data into journal entries within GL.
The GL_INTERFACE table is organized by columns in which GL categorizes and stores specific accounting data.
Multi–Table Journal Import
GL allows to import data from multiple interface tables which can be customized to meet specific data requirements.
Using alternative tables can help improve performance since Journal Import more efficiently processes high volumes of
data from multiple tables than from the single GL_INTERFACE table.
Professionals creating data load routines can choose which interface table to put the data in, and whether the table
should be dropped when Journal Import completes successfully. If Journal Import fails, the data can be corrected or
Deleted. Once data is corrected, Journal Import can be run again.
Journal Import creates journal entries from accounting data imported from Oracle and non–Oracle feeder systems. One
can review, change and post imported journal entries the same as any other journal entry.
Journal Import supports multiple charts of accounts, as well as foreign currency, intercompany, statistical, budget, and
encumbrance journals.
Oracle feeder systems automatically populate this GL_Interface table. If a non–Oracle feeder system is used, then this
table must be populated by the user themselves.

Oracle General Ledger
Importing Journals
Validation:
Journal Import validates all data before it creates journal entries. Journal Import also prints error lines in
the Journal Import Execution Report.
Batch Level Validation:-
Journal Import validates the following attributes to ensure that a batch with the same name does not already
exist for the same SOB and period: SOB, Period name, Batch name.
Journal Import also checks to ensure that more than one journal entry with the same name does not exist for a
batch.
Journal Level Validation:-
Journal Import validates the following attributes to ensure that the journals contain the appropriate accounting
data: SOB, Period name, Source name, Journal entry name, Currency code, Category name, Actual flag,
Encumbrance type ID, User conversion type, Accounting date, Budget version ID, Reversal period.
Journal Entry Line Level Validation:-
Journal Import validates the following attributes to ensure that your journal entry lines contain the appropriate
accounting data:
Account Validation, Effective Date Validation, Descriptive Flexfield Validation, USSGL Transaction Code.

Oracle General Ledger
Import Journals - Run
Select the Source
for Importing
Run Options:
If Suspense Posting is allowed in the SOB, one
can Post Errors to Suspense. With this option,
Journal Import creates journal entries with
suspense journal lines for account errors in the
source data. Else Journal Import rejects any
source/group ID combination that contains
account errors.
Create Summary Journals to summarize all
transactions for the same account, period, and
currency into one debit or credit journal line.
One can import data for the same
or different sources in parallel by
specifying a unique Group ID for
each request.
Else, GL imports all data from the
specified source.
Choose whether to Import DFF .
One can import DFF With Validation
and generate journals only when
validation succeeds. Or, Without
Validation and generate all journals.
Enter a Date Range to import
only journals
with accounting dates in that
range. If date range is blank
GL imports all journals data.

Oracle General Ledger
Import Journals - Correct
If Journal Import
run resulted in
relatively few
errors, the data
rejected by Journal
Import can be
corrected. After
making the
corrections, Journal
Import can be rerun
to create journals
from the corrected
accounting data.
Enter the parameters
here to search the
Journal Import batch
to be corrected.
Batches/Journals to correct journal batch and
journal entry data.
Accounts to correct the account segment values.
Journal Lines to correct journal entry line data,
including the Value-Added Tax DFF.
DFF to correct segment values for the DFF.
References to correct reference information for the
Journal Import data.

Oracle General Ledger
Import Journals - Delete
If there are many Journal
Import errors for a specific
journal entry source and
group ID, one can delete all
erroneous data for the
source and group ID from the
GL_INTERFACE. One can
then repopulate the import
table with corrected data and
rerun Journal Import.
Enter the Parameters
here to search the
Journal Import Batch
and Click on Delete.

Oracle General Ledger
Recurring Journals

Oracle General Ledger
Recurring Journals
Defined once then generated for each subsequent accounting period. You can use recurring
journal entries to define automatic consolidating and eliminating entries.
There are three major types of recurring journals.
 Skeleton
 Standard
 Formula

Oracle General Ledger
Recurring Journals
Define recurring journal formulas for transactions that are repeated every accounting period, such as accruals,
depreciation charges, and allocations. Each formula can use fixed amounts and/or account balances, including
standard, end–of–day, or average balances, actual or budget amounts, statistics, and period–to–date or year–to–date
balances from the current period, prior period, or same period last year.
Recurring journal formulas can be defined for functional currency, foreign currencies which have a fixed relationship
with your functional currency, and statistical currency.
Recurring journals are used to create three types of journal entries:
Skeleton Journal Entries:
Skeleton entries affect the same accounts each period, but have different posting amounts. After generating
skeleton journal entries, one can edit the unposted journal batch. Skeleton journal entries are useful with
statistical information whenever one wants to record journals for actual transactions based on statistical
amounts, such as headcount, units sold, inflation rates, or other growth factors.
Standard Recurring Journal Entries:
Standard recurring journal entries use the same accounts and amounts each period.
Recurring Journal Formula Entries:
Formula entries use formulas to calculate journal amounts that vary from period to period.

Oracle General Ledger
Standard Recurring Journal
Standard recurring journal entries use the same accounts and amounts each period.
For example, record monthly auto lease expenses with constant amounts charged to the same
account.
Dr. Auto Lease Expense……. . . .<Constant Amount>
Cr. Accounts Payable……..<Constant Amount>

Oracle General Ledger
Skeleton entries affect the same accounts each period, but have different posting amounts.
You define a recurring journal entry without amounts, then enter the appropriate amounts
each accounting period
There are no formulas to enter, only account combinations
For example, record depreciation in the same account combinations every month, but with
different amounts due to additions and retirements
Dr. Temporary Labor………………<No Amount>
Cr. Salaries Payable………………..<No Amount>
Skeleton Recurring Journal

Oracle General Ledger
Formula : Formula entries use formulas to calculate journal amounts that vary
from period to period.
For example, calculate rent expense based on end-of-month headcount.
Formula Recurring Journals
Dr. Rent Expense……………. . . .<Variable Amount>
Cr. Rent Payable……..<Variable Amount>

Oracle General Ledger
Defining Recurring Journals
Follow a four-step process to create recurring journal entries.
1.Create Recurring journal definition.
2.Generate Recurring journals
3.Review journal entries
4.Post journals

Oracle General Ledger
Defining Recurring JVs
Enter the JV name, Select
Category and Currency
Enter the Batch name
and Header Description
Auto Copy JV Details
from an existing JV to
this JV
Click to Generate and
Schedule the Batch
Enter a range of Effective
Dates that includes only those
periods for which the recurring
JV is to be used.
Choose Lines to enter
the GL accounts as
well as the formula to
be used.

Oracle General Ledger
Defining Recurring JVs
Specify the type of calculation
to perform by entering a
mathematical Operator for the
formula step. The valid
operators are based on
EasyCalc – a GL mathematical
notation feature.
Enter a Step number to
specify the order in which to
process the steps in formula.
Enter a factor for the
formula step.
1. Enter a fixed
Amount.
2. Specify an Account
to use a balance in the
formula calculation.
Enter the JV Line No to set the
order of recurring JV lines; enter
Account Code Combination and
Line Description Choose the foll:
Balance Type:
Actual or Budget.
Amount Types –
PTD/YTD/PATD/YAT
D/EOD.
Period types:
Current Period,
Previous Period or
Same Period a Year
Ago.
Currency Type:
Monetary or Stat

Oracle General Ledger
Generating Recurring JVs
Select the Recurring JV, the
Period for which the JV has to
be generated and the Budget
for which this JV is to be run.
Click to Submit the
JV

Oracle General Ledger

Mass Allocation

Oracle General Ledger
Mass Allocation
A single journal entry formula that allocate amounts across a group of balancing segment values,
departments, and so on.
Singapore
UK
USA
Allocate total rent expense.
Dept BDept A Dept C

Oracle General Ledger
Mass Allocation
Use Mass Allocation to allocate revenues and expenses across a group of cost centers, departments, divisions, and so
on. By including parent values in allocation formulas, one can allocate to the child values referenced by the parent without
having to enumerate each child separately.
Mass Allocation Steps:
I.Creating Mass Allocation Batches
II.Creating Mass Allocation Formulas
III.Entering Mass Allocation Formula Lines:
All Mass Allocation formulas use the following equation to determine allocation amounts:
COST POOL * (USAGE FACTOR / TOTAL USAGE)
GL uses the following format to represent the equation. Each factor in this equation relates to a separate formula line.
A * B / C.
One can enter any combination of fixed amounts and accounts in formula lines A, B, or C.
Formula Line Steps are as under:
1)Enter the account for the A, B, or C line of your formula.
2)Enter accounts with parent segment values to create a formula that references accounts with the corresponding child
segment values.
3)Assign a segment Type for each account segment. The combination of parent/child segment values and types tells GL
which related accounts are affected or used by that portion of the formula. One can assign one the following segment
types to each segment:
Looping (L): Assign this type to only a parent segment value to include each child value assigned to the parent value
in the formula.
Summing (S): Assign this type only to a parent segment value to sum the account balances of all the child segment
values assigned to a parent.
Constant (C): Assign this type to a child segment value to use the detail account balance associated with the child.
4)Enter the Amount Type you want to use: PTD, QTD, YTD, Project–to–Date, PATD, QATD, YATD, EOD
5)Enter the Relative Period for the account balance you want to use: Current Period, Previous Period, Same Period A Year
Ago
6)Enter the account Balance Type to use for the formula line: Actual, Budget or Encumbrance.

Oracle General Ledger
Mass Allocation
7) Enter the Currency. For Allocation generally A,T and O will be the functional currency, B and C will be Statistical Currency.
The allocation values say area occupied etc are captured via Recurring JVs with Currency being Stat.
8) Once A, B, and C formula lines have been entered, enter the Target and Offset accounts
 Entering a Target Account:
Enter an account in the Target line to specify the destination for allocations.
 When the result of the allocation formula is a positive number, the resulting journal entry debits the target account and
credits the offset account.
 When the result of the allocation formula is a negative number, the resulting journal entry credits the target account and
debits the offset account.
 Entering an Offsetting Account:
Enter an account in the Offset line to specify the account to use for the offsetting debit or credit from the allocation.
The Offset account is usually the same account as formula line A to reduce the cost pool by the allocated amount.
 When the result of the allocation formula is a positive number, the resulting journal entry debits the target accounts and
credits the Offset account.
 When the result of the allocation formula is a negative number, the resulting journal entry credits the target accounts and
debits the offset account.
IV. Validating Mass Allocation and Mass Budget Batches:
After defining a new allocation batch, or change an allocation formula, one must validate the batch by running the Mass
Allocation/ Mass Budget Validation program. The program verifies that the allocation formulas conform to the allocation
formula definition rules.
V. Generating Mass Allocation Journals

Oracle General Ledger
Mass Allocation Example
You want to redistribute the monthly rent expense to each department based on the
amount of space each department occupies.
The organization spends 10,000 dollars for rent.
Rent Expense for Each Department =Rent Expense for Each Department =
Total Rent Expense X Area Used by Department / Total AreaTotal Rent Expense X Area Used by Department / Total Area
Dr. Total rent expenseDr. Total rent expense10,000 functional dollars10,000 functional dollars
Cr. Rents payableCr. Rents payable 10,000 functional dollars 10,000 functional dollars

Oracle General Ledger
You want to allocate rent to three departments:
The rent expense is redistributed using the following journal entry:
Human ResourcesHuman Resources 45% of total floor space45% of total floor space
ResearchResearch 30% of total floor space30% of total floor space
FinanceFinance 25% of total floor space25% of total floor space
Dr. Human ResourcesDr. Human Resources 4,500 functional dollars4,500 functional dollars
Dr. Research rentDr. Research rent 3,000 functional dollars3,000 functional dollars
Dr. Finance rent expenseDr. Finance rent expense 2,500 functional dollars2,500 functional dollars
Cr. Total Rent Expense 10,000 functional dollars Cr. Total Rent Expense 10,000 functional dollars
Mass Allocation Example

Oracle General Ledger
•Create MassAllocation formulas.
•All MassAllocation formulas use the following equation to determine allocation amounts:
•Oracle General Ledger uses the following format to represent the equation. Each factor in this
equation relates to a separate formula line:
•You can enter any combination of fixed amounts and account combinations in formula lines
A, B, or C.
Cost Pool * (Usage Factor/Total Usage)
A * B/C
Defining Mass Allocation Journals

Oracle General Ledger
Defining Mass Allocation Journals
The same four steps used to create Recurring journals also apply to Mass Allocation journals
Create Mass Allocation Journal Formula.
Generate recurring journals.
Review entries.
Post entries.
1
2
3
4

Oracle General Ledger
Defining Mass Allocation

Oracle General Ledger
Defining formula for Mass Allocation

Oracle General Ledger
Generate Mass Allocation

Oracle General Ledger

Journal Approval

Oracle General Ledger
Journal Approval
Use General Ledger's Journal Approval feature to ensure that journal entries and
batches are approved by appropriate management personnel before the journals can
be posted to your account balances.
Journal Approval uses Oracle Workflow to control and monitor the approval process,
sending notifications to journal batch preparers and approvers when needed.
You will not be able to post your batch to the general ledger until you receive this
approval. After submitting your journal batch for approval, you will receive a message
indicating the result of your request.
The message indicates one of the following
journal batch statuses:
• batch was self-approved, if you are authorized to approve your own journal batches
• batch has been sent to an approver
• batch was invalid
Invalid batches must be corrected and resubmitted for approval

Oracle General Ledger
Journal Approval

Oracle General Ledger
Auto Posting Process

Oracle General Ledger
Overview on Auto Post Program
You can automatically post journal batches that meet specific criteria that you have defined in an
AutoPost criteria set.
Can define multiple criteria sets that include a range of journal effective dates and multiple
AutoPost priorities. AutoPost priorities include combinations of ledger or ledger set, journal source,
journal category, balance type, and period.
Auto Post priorities include combinations of journal source, category, balance type, and period.
Run or schedule Auto Post to select and post any journal batches that meet the criteria in a
criteria set.
Review the AutoPost Execution Report after the program completes successfully. Use this report
to review the journal batches selected for posting.

Oracle General Ledger
Scheduling Auto Posting of Journal

Oracle General Ledger
Inquiring Accounts

Oracle General Ledger
Inquiry
Perform an Account Inquiry and drill down to the Detail Balances window to review detailed
information about journals.
Account inquiry
Subledger detail
Drill down

Oracle General Ledger
Inquiry
Select the Factor in
which to view the
Balances/Details
Select the accounting Periods, Single / All
currencies and the Currency Type
Click to Drill down
to the Journal
Details.
Click to show
Variance between
Actual and Budget
Click to Show the
Balances against
each account
Select Actual/Budget as
Primary/Secondary
Viewing

Oracle General Ledger
Intracompany and Intercompany Journals

Oracle General Ledger
Intracompany Journals
Intra Company balancing rules are used to create balancing lines on journals between
balancing segment values within the same legal entity.
Intra Company balancing rules are used when more than one balancing segment value
exists on a transaction or journal entry.
Journal in General Ledger cannot be posted when the debit and credit amounts for each
balancing segment value do not net to zero.
These journals can be balanced automatically by setting up the balancing rules and
enabling the option to balance cross-entity journals.
You can specify unique due-to and due-from intercompany accounts or templates for
Oracle General Ledger to use to balance intercompany journal entries automatically.
Based on the rules that you define, Oracle General Ledger inserts additional journal lines
to offset journal lines that cross balancing segments.

Oracle General Ledger
99
ABC Corporation
Single Ledger
Asia 06Europe 04North America 01
Intracompany

Oracle General Ledger
Standard Intracompany Balancing Example
•You define the following intercompany accounts for a specific source and category:
– xx.000.1600.000 intercompany receivables
– xx.000.2600.000 intercompany payables
•You post the following transaction using the same source and category to transfer an
asset from company 01 to companies 02 and 03:
An Example
Account
02.000.1725.000
03.000.1725.000
01.000.1725.000
Debit
300
400
Credit
700

Oracle General Ledger
Standard Intracompany Balancing Example
•General Ledger creates the following journal lines to record intercompany receivable for
company 01 and payables for companies 02 and 03.
Account
01.000.1600.000
02.000.2600.000
03.000.2600.000
Debit
700
Credit
300
400

Oracle General Ledger
Intercompany Journals
Intercompany journals involve balancing segment values that map to different legal
entities. These journals are balanced for each legal entity by using their intercompany
accounts.
The offsetting debit for a legal entity goes into its intercompany receivables account.
The offsetting credit goes into the legal entity's intercompany payables account.
Intercompany accounts may be defined at the balancing segment level of the legal
entities. In other words, a transacting legal entity can use different accounts for
different transacting balancing segment values, depending on what the trading
partner legal entity and trading partner balancing segment value are.

Oracle General Ledger

Budgets

Oracle General Ledger
BUDGETING
Use budgeting to enter estimated account balances for a specified range of periods. These estimated amounts can be
used to compare actual balances with projected results, or to control actual and anticipated expenditures. GL gives a
variety of tools to create, maintain, and track budgets, including the ability to upload budget amounts from spreadsheet
software.
The Process Chart for creating Budgets is as under:

Oracle General Ledger
Overview on Oracle Budgets
Oracle General Ledger provides a variety of tools to create, maintain, and track your budgets.
Upload budget amounts from an Excel spreadsheet.
Create an unlimited number of budgets or forecasts.
Control user access to budgets.
Create budget organizations to mirror the levels of your company’s organization and to
control user access to budget information.
Structure your budget into an unlimited number of levels.
Create master-detail budgets.

Oracle General Ledger
Anatomy of an Oracle Budget
•A budget consists of periods, accounts, and amounts.
Name: FY2001
001-010 ….. $3000
002-200 ….. $1500
Jan-2001 to Dec-2001 Periods
Accounts
Amounts

Oracle General Ledger
Steps in Budgeting:
Define a budget to represent specific estimated cost and revenue amounts for a range of accounting periods. Multiple budget versions can be
created for a SOB. Budget hierarchies can be created by assigning a master budget to lower-level budgets to track budgeted amounts against
a control budget.
Define budget organizations to represent the departments, cost centers, divisions, or other groups for which budget data is required. A
general budget organization can be defined to include all accounts.
The various methods of entering budget amounts are as under:
Copy budget amounts from an existing budget.
Enter amounts directly into the budget, replacing any existing budget amounts. Budget rules can be used to calculate and distribute amounts
automatically across several periods.
Create and post budget journal entries to maintain an audit trail of budget entries. Use budget rules to calculate budget journal amounts
automatically. After generating budget journal entries, one can review, change, and delete them.
Define budget formulas to calculate budgets based on other budget amounts or on actual account balances.
Define Mass Budget formulas to allocate revenues and expenses across a group of cost centers or departments.
Transfer budget amounts from one account to another.
Create an Excel budget spreadsheet using the Applications Desktop Integrator tool and upload the budget information.
Upload budget amounts from the budget interface table.
Calculate budget amounts to update budget balances from budget and Mass Budget formulas.
Perform online inquiries to review budget information.
Use the Financial Statement Generator (FSG) to design a wide variety of reports that include budget information.
Define and run a consolidation to consolidate budget balances between SOBs.
Freeze budgets to prevent accidental or unauthorized changes.
Translate budget balances to create budget versus actual reports in reporting currency using FSG. One can also generate reports comparing
different versions of budgets in reporting currency.
BUDGETING

Oracle General Ledger
Define Budgets
Define Budget Organisation
Review & Correct Budgets
Freeze Budgets
Define Budgetary Control Group
Report on Budgets
1
2
3
4
5
6
Budget Accounting Cycle
Enter Budgets
7

Oracle General Ledger
Defining a Budget
•Define Use the Define Budget window to specify the accounting periods that you want
to include in your budget.
•Use the Define Budget Organization window to specify accounts by defining a budget
organization, then assigning appropriate accounts to that organization.

Oracle General Ledger
DEFINING BUDGET
Enter Budget
Name and
Description
Enter the Status of budget.
Open: The budget is
available for update and
budget entry.
Current: The budget is
open, and it is the default
budget
Frozen: The budget is
unavailable for update or
budget entry.
This allow s only
Budget entry
methods that create
JV.
Enter First
and Last
period for the
Budget
Assign a Master Budget to
track budget amounts
against a control budget.
One can choose any
budget in the set of
books that has the same
period range.
To open the first fiscal year of
your budget, choose Open Next
Year. GL launches a concurrent
request to open the next
year.

Oracle General Ledger
Budget Organizations
Budget organizations can be set up for each entity that maintains a budget.
Engineering
CC #300
Maintenance CC
#100
Administration CC
#200

Oracle General Ledger
Budget Organizations
Budget organizations:
•Contain ranges of accounts that make up the budget.
•Represent departments, cost centers, divisions, or other groups for which you enter and
maintain budget data.
•Options:
–All budget organization
–Password to restrict access
•Advantages of Budget Oranizations
–You can freeze the budget for a budget organization, while still working on the data
for other budget organizations.
–You can inquire and report on data for a budget organization
–You can set up security for a budget organization to restrict access.
–You can set up an ALL budget organization to include all account ranges.

Oracle General Ledger
DEFINING BUDGET ORGANIZATION
Enter Organization
Name and
Description
Enter the Sort and
Display Options
Ordering Segment: Account segment that is
used to sort accounts when reviewing budget
organization assignments, and while entering
Budgets.
Display Sequence: Use this sequence to
change the order of account segments while
entering Budgets.
Assign passwords to
different budget
organizations within
enterprise, to distribute
budgeting responsibilities
among various organization
managers.
To add any newly
created accounts
automatically, or to
remove reference to any
inactive accounts.
GL runs a concurrent
process to add any new
accounts to budget
organization that fall
within its account
ranges. It also deletes
disabled accounts that
fall within those ranges.
To Delete a
Budget
Organization
To assign ranges of
accounts to
the budget organization
To assign Accounts
directly without
range
To copy the range assignments from another budget
organization:
- Enter the name of the budget organization to Copy From.
- Enter Segment Overrides to tell GL which account
segment values to change for the new budget
organization. At least one segment override must
be designated because one cannot assign identical
accounts to multiple budget organizations.

Oracle General Ledger
DEFINING BUDGET ORGANIZATION
Enter a Line no and the Low and
High ranges for Accounts.
The ranges cannot overlap other
account ranges with the same
currency for any budget organization
in that SOB.
Calculated: To be used for calculating budgets
amounts thru Mass Budgets, Budget Formulas.
Entered: To be used for entering Budget
amounts thru Enter Journals, Amounts,
Upload, Mass Budget Journals, Transfer
Budgets and Budgetary Control
Enter the Currency for
which the budgeting is
to be done.
On saving, GL launches a concurrent program to
assign all the existing accounts within the
designated ranges to the budget organization with
the following status:
Adding: The concurrent request to add accounts
from a range is pending.
In Process: The concurrent request to add
accounts from a range is running.
Reporting: The concurrent request to add
accounts from a range is generating an execution
report of all the accounts it created.
Current: The concurrent request to add accounts
from a range has completed.
To see/assign the
individual code
combinations within the
range defined.

Oracle General Ledger
Enter a Line no and the Low and
High ranges for Accounts.
The ranges cannot overlap other
account ranges with the same
currency for any budget organization
in that SOB.
Calculated: To be used for calculating budgets
amounts thru Mass Budgets, Budget Formulas.
Entered: To be used for entering Budget
amounts thru Enter Journals, Amounts,
Upload, Mass Budget Journals, Transfer
Budgets and Budgetary Control
Enter the Currency for
which the budgeting is
to be done.
On saving, GL launches a concurrent program to
assign all the existing accounts within the
designated ranges to the budget organization with
the following status:
Adding: The concurrent request to add accounts
from a range is pending.
In Process: The concurrent request to add
accounts from a range is running.
Reporting: The concurrent request to add
accounts from a range is generating an execution
report of all the accounts it created.
Current: The concurrent request to add accounts
from a range has completed.
To see/assign the
individual code
combinations within the
range defined.
DEFINING BUDGET ORGANIZATION

Oracle General Ledger
See / Enter/ Delete the
Individual Account
assignments.
DEFINING BUDGET ORGANIZATION

Oracle General Ledger
Entering Budget Amounts
•Use Single Row Mode to enter budget amounts for each account in the budget organization
one-by-one
•Use Worksheet Mode to enter budgets for several accounts at once
•Use budget rules to distribute budget amounts for all periods
•Enter statistical budget amounts
Budget amounts can be entered in following Modes:
–Journal mode
–Worksheet mode
–Individual account mode
Enter budget amounts to replace any existing budget balances.
You can:

Oracle General Ledger
Using Budget Rules To Enter Budget Amounts
Annual advertising budget

Budget rule: Divide evenly
1,200,000
Jan
100,000
Feb
100,000
Mar
100,000
Apr
100,000
May
100,000
Jun
100,000
Jul
100,000
Aug
100,000
Sep
100,000
Oct
100,000
Nov
100,000
Dec
100,000
Budget rules are predefined methods for distributing and calculating amounts to all periods for an
account. You can use budget rules to help you enter budgets quickly and easily.

Oracle General Ledger
ENTERING BUDGET AMOUNTS
Select the Budget Organization,
Budget, Accounting Periods and
Currency for which Budgeting is to be
done.
Worksheet Mode: to review and
enter budget amounts for several
accounts at once.
Select the Code Combination Range
for which Budget Amounts are to be
entered.
Single Row Mode: to review and
enter budget amounts for one
account at a time.
Enter the amounts in
the Requisite Period.
Click to Enter the Budget
Rules for distributing the
amounts
Click to Post the
Budget amounts Click to show the Column
Totals for control purposes
Enter budget
amounts to replace
any existing budget
balances

Oracle General Ledger
Select the appropriate
Budget Rule
Set the rounding options to
handle differences resulting
from amounts that cannot be
divided exactly. One can either
choose to ignore any rounding
errors, or can post the
difference to a specific budget
period.
Click to Apply the Rule
Enter the requisite Budget
Amount
Budget rules are predefined methods for
calculating and distributing budget amounts
to all periods for an account. One can use
budget rules to enter budgets quickly and
easily.
Divide Evenly: Evenly distribute the
amount entered across all accounting
periods.
Repeat Per Period: Repeat the amount in
each accounting period.
Prior OR Current Year Budget OR
Actual Monetary OR Statistical: Multiply
the amount entered by the prior/current
year budget /actual and
monetary/statistical balance of the account
entered.
4/4/5: Enter 4/52 of your amount in the first
period, 4/52 in the second
period and 5/52 in the third period. This
sequence is repeated for the
entire period range. If you are using a 13
period year, no amount is
entered in the thirteenth period.
Similarly 4/5/4 and 5/4/4
ENTERING BUDGET AMOUNTS

Oracle General Ledger
Entering Budget Journals
•You can use budget rules to calculate budget journal amounts
•You can enter statistical budget journals for accounts that are assigned a currency
of STAT
•You can review and change your budget journals before posting them
•When you post budget journals, the journal amounts update existing budget
balances

Oracle General Ledger
ENTERING BUDGET JOURNALS
Enter the requisite Budget
Amount
Select the Budget Organization,
Budget, Accounting Periods and
Currency for which Budgeting is to be
done.
Journal Mode: to
enter budget
amounts in a
journal format.
Enter budget journals to maintain an audit
trail for budget balances. On posting budget
journals, the journal amounts update existing
budget balances. One can review and
change your budget journals before posting
them.
Enter Line Description
Click to create budget
Journals

Oracle General Ledger
TRANSFER BUDGETS
Enter the Budget for which the
amounts are to be transferred.
Enter a Batch Name and a
Currency
Budget amounts can be transferred from one
account to another within any budget. The
accounts may belong to the same or different
budget organizations. One can transfer fixed
amounts or a percentage of an account’s
budget balance.
Enter the Budget Organization and
the Accounts from which the Budget
amounts are to be transferred; Enter
the Budget Organization and the
Accounts to which the Amounts are to
be transferred.
Click to Transfer and specify the fixed
amounts or percentages of account
balances to be transferred.
On Saving GL automatically runs
Journal Import to create an un posted
budget journal batch which is to be
posted to transfer batch.

Oracle General Ledger
TRANSFER BUDGETS (CONTD…)
Select a Single Period or the % of
Budget amount to be transferred.
Click to transfer by a
Period Range
Select the From and
To Period Range
Enter % to transfer in
% terms
Click to Apply the
Rules
Enter the Budget Amount to be
transferred
Select the
Budget Amount
to be transferred.

Oracle General Ledger
UPLOAD BUDGETS
After loading the Budget through ADI or
Loader, the data is to be uploaded from the
interface to GL Tables. This imports a JV in
un-posted form which is to be posted to
update the balances.

Oracle General Ledger
Finalizing Budgets
Use a three-step process to ensure the accuracy of your budgets.
Step 1:
Review budget
information.
Step 3:
Freeze budgets.
Step 2:
Correct budget
information.

Oracle General Ledger
FREEZE BUDGETS
Select the Budget
Organization under a
Budget to be Frozen
Select the Budget to be
frozen.
Freeze a budget, budget organization, budget
formula batch or range of budget accounts to
prevent accidental or unauthorized changes.
One can also unfreeze a budget, budget
organization, budget formula batch
or range of budget accounts that is currently
frozen.
Select Account Ranges to
be Frozen

Oracle General Ledger
About Budget Formulas
•Use budget formulas to calculate budget amounts
•Budget formulas can be simple or complex
•You can use any combination of fixed amounts and account balances from the current period,
prior period, or same period last year, including:
–actual or budget amounts
–statistics
–period-to-date or year-to-date balances

Oracle General Ledger
Defining Budget Formulas
Headcount budget (HC) = 1,000 employees
Total salary budget = 40,000,000
(1000 X 40,000)
Per head salary budget = 40,000 each
With budget formulas, you can calculate recurring budget amounts based on other budget
amounts or on actual results.

Oracle General Ledger
Overview On Budgetary Control
•Budgetary control is the process of recording budget data and tracking encumbrance and
actual data against the budget.
•Funds Checking prevents overspending budgets by verifying available funds online before
processing a transaction.
•You can track budget or encumbrance data using one of the following methods:
–Encumbrance accounting
–Budgetary amounts
•Funds checking is the feature of budgetary control that helps prevent overspending budgets by
verifying available funds online before processing a transaction.

Oracle General Ledger
Budgetary Control Options for Accounts
•Assign budgetary control options to a range of accounts, using the Define Budget Organization
window.
•Determines the level of detail for funds checking for specific accounts.
•When you create new accounts that fall within a range of account assignments with Advisory or
Absolute, GL automatically updates budget organizations with new accounts.
•Includes: Funds Check Level, Amount Type, Boundary, Funding Budget, and Automatic
Encumbrance flag.

Oracle General Ledger
Defining Budgetary Control Options for Accounts

Oracle General Ledger
Report on Budgets
Summary/Detail Budget Report
Funds Available Analysis Report
Budgetary Control Transactions Report
Encumbrance Trial Balance Report
Budget Hierarchy Listing
Budget Organization Listing
Budget Journals by Account Report

Oracle General Ledger
Revaluation

Oracle General Ledger
Revaluation Process
Revaluation is a process that reviews foreign currency transactions, reconverts them to the functional
currency using the Revaluation Rate, then creates a journal entry to adjust the functional balance to
the reconverted amount.
Revaluation reflects changes in conversion rates between the date of journal entry and the date of
receipt/ payment of the foreign currency amount.

Oracle General Ledger
Revaluation
Account balances denominated in a foreign currency are Revalued to reflect the change in the foreign currency rate from
the date a transaction is entered and the reporting date. The value of the balance in the original currency remains the
same.
Only the converted amount gets changed and the difference is posted to the Unrealized Gain/ Loss Account.
Revaluation Process:
Define the revaluation rates.
Run the revaluation program to launch a process that revalues the functional currency equivalent balances for the
accounts and currencies selected, using the appropriate current market rate for each currency.
Resulting gain or loss amounts are posted to the gain/loss or cumulative translation adjustment account specified.
This process creates a revaluation batch containing separate journal entries for each revalued foreign currency.
One can revalue a single account or ranges of accounts, for both income statement and balance sheet reporting.
Income Statement accounts are revalued on the basis of their PTD or YTD balances. Balance sheet accounts are
always revalued on the basis of their YTD balances.
Revaluation journal entries generated and posted in primary SOB are automatically replicated and converted to each
reporting SOBs. You must separately post these replicated journal batches in each reporting SOBs.

Oracle General Ledger
 The exchange rate difference arising out of revaluation is posted to Unrealized Gain/Loss
Account.
 Generate Journals for Revaluation and automatically mark them for Reversal in the
immediate following period.
USD
Foreign Currency
AED
Functional Currency
Converts to
R E V A L U E
USD
Foreign Currency
AED
Functional Currency
Converts to
Revaluation Process

Oracle General Ledger
Revaluation Example
On May 31, the receivable for the previously converted May 17 consulting services remains
uncollected and the organization wants to report on its financial position.
–The exchange rate has risen to 0.81.
–The receivable is still for 10,000 USD, but that receivable is now worth 8,100 GBP.

Oracle General Ledger
Defining Revaluation Rates
The default currency is the SOB
Functional Currency. Enter the To
Currency (Target Currency)
Period–average and period-end rates: to
translate actual and budget account balances.
Revaluation rate: to revalue account balances
that are denominated in a foreign currency.
Choose the Balance
Type – Actual or Budget
Enter the Accounting
Period to which the rates
apply.
Period–Average rate: to
perform currency translation for
income statement accounts.
Period-End rate: to
perform currency
translation for
translating balance
sheet accounts GL
enters the inverse
of the period–end
rate as the
revaluation
rate. GL uses the
revaluation rate for
running revaluation.

Oracle General Ledger
Foreign Receivable
10,000
Functional Receivable
8,000
Foreign Receivable
10,000
Functional Receivable
8,100
Functional Unrealized Gain
100
After Revaluation
Revaluation Example
Before Revaluation

Oracle General Ledger
Performing Revaluation
Single currency: enter the Currency to use
for the revaluation. If SOB’s functional currency
has a currency derivation of Other, you can only
enter a currency that also has a currency
derivation of Other. Enter the Rate to use for the
revaluation
All currencies: GL revalues each foreign
currency balance only if a period-end rate exists
for each currency and accounting period.
Click to launch the Revaluation process.
GL automatically generates the Revaluation
Execution Report which reflects the status of
revaluation

Oracle General Ledger
Translation

Oracle General Ledger
Overview on Translation
Foreign currency translation is a process that enables you to restate your functional currency
account balances into a reporting currency.
Foreign
currency
Functional
currency
Translation

Oracle General Ledger
Translation
Currency Translation process restates functional currency account balances into a reporting currency.
This feature is used by companies whose reporting requirements in multiple currencies are not frequent
and they want to maintain reporting at account balances level only.
Balances And Rates Used For Translation:
Account TypeBalance Rate to be used in Translation
Assets Cumulative Periodic End- Rates: Daily rate on the last day of the
accounting period.
Liabilities Cumulative Periodic End- Rates.
Revenue Periodic Period Average Rates: The average of daily rates
throughout the accounting period.
Expense Periodic Period Average Rates
Equity Cumulative Periodic End- Rates
OR Historical Rates: The Weighted Average rate for
transactions that occur at different points in time.

Oracle General Ledger
Translation
Cumulative Translation Adjustment Account:
On translating balances to another currency, GL automatically adjusts the balance of the Cumulative
Translation Adjustment account to the net difference needed to balance the translated COA.
Translation with Historical Rates and Amounts:
GL selects one of two amounts that is used to arrive at a translated balance for the account:
Account Balance: One can assign historical rates or amounts to accounts individually/by range. The resulting
amount is a YTD translated account balance.
Net Activity: In this method, the amount is added to the previous period’s translated balance to arrive at the
current period’s translated balance.
Foreign Currency Listings:
Daily Conversion Rates / Historical Rates / Period Rates Listing,
Foreign Currency Reports:
Foreign Currency GL / Journals / TB (s) Report, Translation TB, Foreign Account Analysis Report
Multi – Currency Profile Options:
GL: Income Statement Accounts Revaluation Rule
GL: Revaluation: Autoquery Last Run Ranges
GL: Owner’s Equity Translation Rule
Journals: Allow Multiple Exchange Rates
Journals: Display Inverse Rate

Oracle General Ledger
Translation Example
Functional Currency Income Statement
Revenue 7,000
Expense(4,000)
Net Income 3,000
Functional Currency Balance Sheet
Assets
100,000
Liabilities
60,000
Owner’s Equity
40,000
Foreign Currency Income Statement
Revenue 5,040
Expense(2,880)
Net Income 2,160
Foreign Currency Balance Sheet
Assets
75,000
Liabilities
45,000
Owner’s Equity
28,000
Period Average Rate = 0.72 Period End
Rate = 0.75
Historical
Rate = 0.70

Oracle General Ledger
Terms You Should Know
Period end rate:
The daily rate on the last day of your period
(Used for Asset and Liability accounts)
Period average:
The average of your daily rates rate: throughout your period
(Used for Revenue and Expense accounts)
Historical rate:
A weighted average rate for transactions that occur at
different times
(Used for Equity accounts)

Oracle General Ledger
Performing Translation
Enter the Target
Currency and the
Period for translation.
Mark the All checkbox to translate
balances for all balancing segment values,
or enter a single Balancing Segment Value
for which translation is to be carried out.
Select the Balance
Type as Actual for the
currency.
Click to launch the
Translate concurrent
process.

Oracle General Ledger
Consolidation

Oracle General Ledger
Overview of Consolidations
With Oracle General Ledger, you can consolidate any number of subsidiaries into parents
represented by different sets of books—even those with different charts of accounts, currencies
and calendars.
Subsidiary 1:
Company A
Company B
Subsidiary 2:
Company C
Subsidiary 3:
Company D
Company E
Company F
Parent:
Company A
Company B
Company C
Company D
Company E
Company F
Run Consolidation

Oracle General Ledger
Consolidation Tools
•Use the Consolidation Workbench to
consolidate data from:
–Multiple Ledgers
–Multiple instances
–Non-Oracle applications
•Use the State Controller to:
–Access windows used to perform each
consolidation activity
–Monitor the status of consolidation
•Create reports to consolidate:
–Businesses within single
Ledger.
–Businesses in different
Ledgers with same
calendar, chart of
accounts, and currency
•Produce additional
consolidation reports
Global Consolidation
System(GCS)
Financial Statement
Generator (FSG)

Oracle General Ledger

Financial Statement Generator (FSG)

Oracle General Ledger
Overview on Financial Statement Generator
Oracle General Ledger’s Financial Statement Generator (FSG) is a powerful and flexible financial report
building tool you can use to build your own custom financial reports without programming.
Rows
Columns
FSG Report

Oracle General Ledger
Components of Financial Statement Generator
•Row set:
Defines all of the rows in your financial report. You control the format, content and the
account assignment included in each row.
•Column set:
Defines all of the columns in your financial report. You control the format, content and
usually the periods included in each column.
•Report:
A combination of at least a row set and a column set comprise a financial report.

Oracle General Ledger
Customized Financial Reports
Use a four-step process to define and run your FSG reports.
1. Define row sets.
2. Define column sets.
3. Define financial reports and report sets.
4. Request financial reports and report sets.

Oracle General Ledger
Income Statement
Company 1
Sales
Returns
Net Sales
PTD YTD
3,000 6,200
1,000 1,000
2,000 5,200
Row Set ARow Set A
Balance Sheet
Company 1
THIS YR LAST YR
100 200
600 400
980 700
Row Set BRow Set B Cash
Investments
Receivables
Defining Row Sets
Define the format and content of rows in financial reports.

Oracle General Ledger
Income Statement
Company 1
Sales
Returns
Net Sales
PTD YTD
3,0006,200
1,0001,000
2,0005,200
Column Set AColumn Set A
Balance Sheet
Company 1
THIS YR LAST YR
100 200
600 400
980 700
Column Set BColumn Set B
Cash
Investments
Receivables
Defining Column Sets
Define the format and content of columns in financial reports

Oracle General Ledger
Standard Reports and Listings

Oracle General Ledger
Reporting in Oracle General Ledger
Oracle General Ledger provides you with a variety of period end reporting capabilities, including
the Financial Statement Generator, and standard reports and listings.
Period Activity FSG and Standard Reports

Oracle General Ledger
Oracle General Ledger gives you a complete set of standard reports. Categories of standard
reports and listings include:
•Account Analysis
•Budget
•Chart of Accounts
•Multi-Company Accounting and
Consolidation
•Currency
•General Ledger
•Journals
•Trial Balance
•Execution
•Other
Overview on Standard Reports and Listing

Oracle General Ledger
Standard Reports and Listings
Oracle General Ledger gives you a complete set of standard reports. Categories of
standard reports and listings include
–Account Analysis: Accumulated balances of a range of accounts and all journal
entry lines that affect that range.
–Budget: Information about your budgets and budget organizations, including
account assignments and budget hierarchies.
–Chart of Accounts: Information about the accounts in your chart of accounts,
including segment values, rollup ranges, and suspense accounts.
–Multi-Company Accounting and Consolidation: Information about your multi-
company accounting and consolidation activities. Intercompany transactions made
can be viewed using GL’s GIS feature.
–Currency: Daily, period, and historical rates that you defined for foreign currencies.
– Financial Statement Generator: Summary or detail information about the
definitions of your Financial Statement Generator report components, reports, and
report sets.
– General Ledger: Beginning and ending account balances, and all journal entry lines
affecting each account balance in your functional and foreign currencies.

Oracle General Ledger
–Journals: Journal information in functional and foreign currencies, including posted,
unposted, and error journals. You can also review journal activity for particular periods
and balancing segments.
–Trial Balance: Account balances and activity for functional and foreign currencies,
budgets, encumbrances, and actuals.
–Execution: Automatically generated after concurrent processes have completed.
–Other: Information about MassAllocation/Mass Budget definitions, recurring journal
formulas, statistical units of measure, and value-added taxes received and paid.
Standard Reports and Listings

Oracle General Ledger
Period Closing Process
Enter, import,
generate, reverse and
post journal entries
Run revaluation and
translation
Consolidate your
sets of books
Analyze the resultsRun period end
reports
Close the current
period

Oracle General Ledger
233A
Q
&
233

Oracle General Ledger
Thank You
234

GL_Training_Presentation_01010101010.ppt

About This Presentation

Slide Content

Tags

Categories

Download

Quick Actions

Statistics

Related Slideshows

GL_Training_Presentation_01010101010.ppt

About This Presentation

Slide Content

Slide 1

Slide 2

Slide 3

Slide 4

Slide 5

Slide 6

Slide 7

Slide 8

Slide 9

Slide 10

Slide 11

Slide 12

Slide 13

Slide 14

Slide 15

Slide 16

Slide 17

Slide 18

Slide 19

Slide 20

Slide 21

Slide 22

Slide 23

Slide 24

Slide 25

Slide 26

Slide 27

Slide 28

Slide 29

Slide 30

Slide 31

Slide 32

Slide 33

Slide 34

Slide 35

Slide 36

Slide 37

Slide 38

Slide 39

Slide 40

Slide 41

Slide 42

Slide 43

Slide 44

Slide 45

Slide 46

Slide 47

Slide 48

Slide 49

Slide 50

Slide 51

Slide 52

Slide 53

Slide 54

Slide 55

Slide 56

Slide 57

Slide 58

Slide 59

Slide 60

Slide 61

Slide 62

Slide 63

Slide 64

Slide 65

Slide 66

Slide 67

Slide 68

Slide 69

Slide 70

Slide 71

Slide 72

Slide 73

Slide 74

Slide 75

Slide 76

Slide 77