http://oracleapps88.blogspot.

com/

M
O
.C
T
O
P
S
G
O
L Ledger
Oracle General
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
L 1
Begin Day
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

Agenda – Day 1 M
O
.C
1. Integration Overview T
O
P Calendar &
S
2. Creation of Ledgers - Chart of Accounts, Currency,
Accounting Convention G
O
L
.B
3. Cross Validation Rules
8
4. Security Rules 8
S
P
5. Shorthand AliasesP
A
E and Summary Templates
L
6. Roll-up Groups
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Integration Overview

Depreciation Expense
Retirement Gains/Losses Invoices
M
O
Cost Adjustment Oracle Payments
Discounts Oracle
.C Payables
Revaluation's Assets Foreign Gains/Losses
Reclassification
Oracle T
Encumbrances
Inventory O
P
S
G
O Labour costs

OracleB
L Usage costs
Oracle
Project
.
Revenue
Accounting
Oracle Encumbrances
8
General
Purchasing 8
Ledger
Month-end Accrual
S
P
P
A Forecasting External
Invoice /E
Self-Service
L Systems
Billing Auto BRS web purchasing
Oracle
C
Receipts
Receivables Adjustments Oracle
ADebit/Credit memos Cash
Oracle
R Management
iProcurement
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Implementation Flow Chart

Legends used in the Implementation Flow Chart M

O
.C
T
O
Required Step P
S
Cannot Continue if not Complete
G
O
L
.BStep
Required
8 Provide Default Values
But Oracle General Ledger
8
S
P
P
A
E Optional Step
L
Corresponding Function not Available if not Complete
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Implementation Flow Chart

Create Ledgers Create Ledgers Define Accounts

M
Define Controls

O
Define Cross Enter Account .C
Define Responsibilities
Validation Rules Combinations T
O
P
Define Value Sets Define Period Types S
Define Additional
G
Inter company
O Accounts
Define Flexfield Define Accounting L
Structure Calendar .B
8 Define Additional
8 Suspense
S Accounts
Define Segment P
Define Currencies
Values P
A Define Summary
E Define Convention Accounts
Define Security L
Rules C
A
R Define Ledger
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Implementation Flow Chart

Create Ledgers Define

Accounts
Define Controls
M
Define Controls

O
Define Short Hand . C
Aliases T
Setup Auto Reverse
O
P
Define Journal S Setup Autopost
Entry SourcesG
O
L Define System
.B
Define Journal Controls
8Entry Categories
8
S
P Define Units of Set Profile Options
P Measure
A
E
L Define Budgetary
C Control Groups
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Set of Books

A Set of Books comprises of Chart of Accounts, Calendar and

Currency (3 C’s). M
O
.C Based
Cash
01-1110-5416-00000-00000000 1 2 3 4 5 6 T
Accrual Based
01-2110-5417-00000-00000000 7 8 9 10 11 12 O
01-3110-5418-00000-00000000 13 14 15 16 17 18 P Accounting
01-4110-5419-00000-00000000 19 20 21 22 23 24 SINR Convention
01-5110-5420-00000-00000000 25 26 27 28 29 30 G
01-6110-5421-00000-00000000 31 O
L Currency

. B
Chart of Accounts
8Calendar
Structure
8
S
P
P
A
E
L
C
A SEW
R LEDGER
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Ledger- Currencies

Define Currencies - Use currencies window to enable the currencies that are required for
operations. M
O
.C
All the ISO currencies are seeded. Enable the currencies that would be utilized
T
O
Currencies Rate Types - Used to define the types of rates i.e. spot or corporate etc.
P
S
Define your own rate type apart from those that are already seeded.
G
O
L
.B
Daily Rates - Used to define daily used rates – to convert from foreign currency to functional
currency
8
8
S
Use the appropriate rate type when entering transaction to default the rate automatically
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Ledger- Currencies

PeriodRates: Used to define rates for a period – for translation and revaluation
M
General Ledger uses O
. C
•Period average and period end rates - for translating actual and budget T account balances
O
•Revaluation Rate - When you revalue account balances denominated P in foreign currency
S
G
Historical: Used to define historical rates for translatingO
balance sheet accounts
L
.Band budget account balances
•Historical rates or amounts for translating actual
8
•Enter Historical rates individually or by8
S range
•Normally entered for balanceP
P
sheet accounts - Example - To translate non-monetary and
A balances
selected owners’ equity account
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Ledger- Calendar

Period Types - Attach the Period Type when defining accounting calendar
M
O
• Period types control the number of Accounting Periods per fiscal year. Period types could
be Month, Quarter, Year etc., .C
T
O
Accounting Calendar P
S
• An Accounting Calendar consists of Accounting Periods G
associated with a Period Type
O
L
.B
• Define your Calendar one year at a time to be more accurate

8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Period Type and Accounting Calendar

Accounting Calendar M
O
Name Type Year Period Qtr From To
.C
T
Jan-03 Month 2003 1 1 01-Jan-03
O
31-Jan-03
Feb-02 Month 2003 2 1 01-Feb-03
P31-Mar-03
28-Feb-03
Mar-03
Apr-03
Month
Month
2002
2003
3
4
1
2
01-Mar-03
01-Apr-03S 30-Apr-03
G
O
L
.B
Dec-03 Month 2003 12 8 4 01-Dec-03 31-Dec-03
8
S
P non-adjusting periods
•Ensure that there are no gaps between
P
•Accounting periods E
A
cannot overlap, except for adjusting periods
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Set of Books - Calendar

Open/Close Period
M
O
.C
Open and close accounting periods to control journal entry and journal posting, as well as
compute period–end and year– end actual and budget account balances for reporting.
T
Accounting Period Statuses O
P
S
a. Open b. Closed
G
c. Permenantly Closed
d. Never Opened e. Future Entry O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Ledger- Calendar

Status of Periods M
O
.C
Status Record Post TReport
O
P
Never Opened N N
S N

YG
Open Y
O Y
L
.B
Future Entry Y N N
8
Closed N
8 N Y
S
Permanently Closed P
N N Y
P
A
Not Opened E N N N
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Accounting Flexfield Structure

Your Accounting Flexfield structure could look like this……….

M
O
Accounting Flexfield Natural .C
Segments Company Cost Center T
Account ………………...
O
Balancing Cost Center P
Natural Account
Segment Segment S Segment
G
O
L
Company .B
Department Account
8
8Format:
Format:
S Format:
Value Sets Char
P Char Char
P
A
Maximum Maximum Maximum
E
Size: 2 Size: 4 Size: 4
L
C Independent
Validation: Validation: Validation:
A Independent Independent
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Accounting Flexfield - Values

Define Account Values M

O
•Query the Value Set and upload/enter values for each value set .C
T
View Value hierarchies O
P
S
•View the value hierarchy by clicking on “Up” and Down” buttons
G
O
Move Child Ranges
L
.B
•Use this form to move child ranges from one parent value to another
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Parent and Child Values

M
Parent Values
All Assets O
.C
T
O
P
S
Child/ G Current Assets
Parent Values
Fixed Assets O
L
.B
8
8
S Cash
Child Values Land
P
Building Bank Stock
P
A
E
Lof levels
• No limit to number
C
• No limit toA
number of entities on each level
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Parent and Child Values

Parent Values : M
O
•Assign ranges of Child values to Parent Values
.C
T
•No Posting is done to Parent Values O
P
S
•Budgets are not entered directly for Parent Accounts
G
O
Child Values : L
. B
8 segment values
•Post journals directly to Child
8
S to Child Segment Values
•Enter Budgets directly
P
P
A
E
• Natural Account Segment values are to be qualified as Assets, Liabilities, Ownership/Stock,
L
Revenue or Expenses
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Set of Books

Enter the Set of Books name M

O
• Attach the Chart of Accounts, Functional Currency and Calendar .C
T
•Enter Retained earnings and Translation account O
P
•Balance Inter Company Journals, Enable journal approvalG S
and Journal Entry Tax

•Allow Suspense and to track

O
rounding difference L
. B
•Choose to allow average balance for the Set8of Books
8
•Enable Budgetary Control for fundsS
P reservation
P
•Enable require Budget Journals
A for entering budgets through journals
E
L type - Primary/Reporting/None
•Enable the Set of Book
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Set Of Books - Chart of Accounts
Chart of Accounts - Consider your Organisational structure and dimensions of your business
before setting up your Chart of Accounts
M
O
.C
Structure:

Code : ACCOUNTING_FLEX T
O
Title : BMI Accounting Flex
P
Description : BMI Accounting Flexfield S
G
Freeze Flex field definition : Yes/No O
Enabled : Yes/No L
Segment Separator :
.B
Period (.) / Dash (-) / Pipe (|) / Custom
Cross Validation Segments : Yes 8
Freeze Roll up Groups : No 8
Allow Dynamic Inserts : S
Yes
P
P
A
•Create the Accounting Flexfield Structure
E
L
•Ensure that the flexfield qualifiers (Balancing Segment, Natural Account Segment, Cost
C
Center Segment and Inter Company Segment) are enabled
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Security Rules

Navigation : Setup>Financials>Flexfields>Key>Security>Define/Assign
Screen : Define/Assign Security Rules M
O
.C
•Control Access to ranges of Accounting Flex-field Segment values by defining Security Rules
and assigning them to responsibilities T
O
P
S
G
O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Cross Validation Rules

Navigation : Setup>Financials>Flexfields>Key>Rules
Screen : Cross-Validation Rules M
O
.C
•Prohibit invalid combinations of Accounting Flex-field Segment values using Cross Validation
Rules T
O
P
S
•Always use one universal include rule and use atleast one exclude element
G
O
L
.B
8
8
S
P
CEO’s Office
P Pax, Cargo, Mail Revenues
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Roll-up Group

Roll up Group M
O
.C
•Define rollup groups to capture different summary levels for each Accounting Flexfield
Segment
T
O
P when creating
•Assign related parent values to rollup groups. Use Rollup groups
summary accounts S
G
O and graphically create parent-
•Use account hierarchy editor to define new roll up group
L
child relationship and assigning parent values to roll up groups
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Summary Accounts

Summary Accounts
M
O
All Assets All Assets .C
Rollup Group T
O
P
S
G
O
Level 2 Fixed Assets L Current Assets
Rollup Group .B
8
8
S
Child Values P
Land PBuilding Cash Bank Stock
A
•Use Summary Accounts Eto view financial information at Summary Level - Example - Cash
L can be reviewed to make decision on investments
C
across all the Companies
A
•Use Summary R Accounts in formulas,allocations and for budgetary control at parent level
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Account Aliases

M
•A Shorthand alias is a simple code that represents a partial or complete Accounting Flexfield
O
.C
• Use Shorthand aliases to reduce flexfield entry keystrokes and maximize productivity and
accuracy
T
O
P
Sample Shorthand Aliases S
G
O
L
Alias
.B
Accounting Flex-field Structure
8
(Co-Cost-Nom-Sub1-Sub2)
8
Cash S
01-0000-1610-00000-00000000
P
Travel P 01-1000-6211-00000-00000000
A
E
Revenue-Pax 01-0000-4101-00000-00000000
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

Agenda – Day 2 M
O
.C
T
1. Journal Entry Setup O
-Journal Sources, Categories P
-Journal Approval Hierarchy S
G
O
-Setting up Auto posting and Auto reverse
L
2. Manual Journal Entries .B
8
8
3. Journal Import S
P
P
A
4. Posting of Journals
E
L
5. HandsC
on Session
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
General Ledger Accounting Cycle

Define Set of Books

M
Open Accounting Period O
.C
T
Enter Manual Journal Define Recurring Journals O
Define Mass Allocations
Entries P
S
G
Setup Journal
Import Create Recurring Create Mass
Journals
O Allocation Journals
Import Journals using L
Journal Import
.B
Review Unposted Journals8
8 online and in Standard Accounting Reports
SCorrect Errors
Correct Journal Import
P
Error Journals
P
A Post Journals Reverse Journals
Import Journals using
E
Journal Import
L
C
A Define Financial Statements and Perform Online Inquiries
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Journals Setup

Define Journal Sources

• Decide on whether Journal has to be Approved M
• Decide to Freeze Journals O
• Import Journal References or not (from Feeder Systems)
.C
• Allow Modifications to imported Journals or not T
O
P
S
• Define Journal Categories to group Journal entries by the nature of the transaction
G
viz. - Station Journals, Payroll Journals,DOC Accrual etc.
O
• Categories can also be used to create document sequences to number journals
L
.B
Define Journal Approval Hierarchy 8
8 option is enabled at the SOB Creation.
S the Employee - Supervisor Relationship
• Relevant only if Journal Approval
P for specific Employees
• Enter Employees & Establish
P
• Enter Approval Limits
• Set the ProfileA
Options to establish the Document routing process
E
Note: ApprovalL Limits are for the highest amount in a journal line and are not for Journal
Total.C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Journal Entries ...
Name : Station Expenses Batch
Period: Jun-03
M
O
.C
Name: Salary Exp
Currency: IEP
Name: Rent
Currency: EUR
Name: Overheads
Currency: USD T Journal
Category : DUB Exp.. Category : PAR Exp. O
Category : EWR Exp. Entry
P
S
G
O
L Journal
.B
Salary Exp… 10,000 Rent - Office … 10,000 Staff Welfare … 10,000
Station Cash… 10,000 Station Cash … 10,000 Station Cash … 10,000 Lines
8
8
S
P
• A Journal Batch may contain an unlimited number of Journal Entries
P
Aan unlimited number of Journal Lines
• A Journal Entry may contain
E
L
• A Journal Batch C
can contain journals of any currency but a Journal can have lines in only one
Currency A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Journal Entries ...

Journal Entry M
O
•Enter Journals in batches or as single journal .C
T
•All journals in a batch share the same period O
P
S be posted only in Open
•Enter journals in Open or Future enterable periods. But they can
periods G
O
L
For Journal Approval - Ensure .B
8
8
S is enabled
•Journal approval in Set of Books window
P
P to Approve and to find approver method
•Set profile options to Allow preparer
A
Eapproval to time-out and return to user creating journal
•Set time limit for journal
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Journal Entries ...

Enter Yes Supply

Journals
Foreign
Exchange M
Currency?
Rate O
Post.C Generate
Review No T
Journals Reports
Journals O
PGenerate
No S
Is the journal
G Reversal

O Journal Voucher
entry correct

L
.IsB No Mark Journal
Post 8 entry
the journal
for
Journals 8 correct
Reversal
S
P Yes
P
A Generate
E Reports
L
C
• When posting to earlier open periods, actual balances roll forward through the latest
A
ever-opened period
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Journal Entries - Auto Post/Reverse

AutoPost
M
O
.C
•Automatically Post journal batches that meet specific criteria with combination of Source,
Category, Balance Type and Period. For example - Automatically Post journals from sub-
ledgers like Account Payable / Accounts Receivable T
O
P
S
•Schedule the Auto Post program for the AutoPost Criteria Set defined periodically from
“Schedule” window G
O
L
Auto Reverse .B
8
8
•Auto Reverse journals that are routinely reversed,like period end accrual journals by marking
S
the journal category as auto-reverse.
P
P
A
•Run Open Period program to launch Automatic Reversal or Submit the Automatic Reversal
E
Program from Submit request form
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
L End Day 1
General Ledger
B .
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
LBegin Day 2
General Ledger
B .
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

Agenda – Day 2 M
1. Recap of Day one O
.C
T
2. Recurring Journals O
P
3. Mass Allocation S
G
O
4. Mass Maintenance L
.B
8
5. Document Sequencing 8
S
P
6. Budgeting P
A
- Budget Organisation
E
- Budgets
L
C
- Budget Entry
A
RBreak
O
7. Lunch

RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

M
8. Budgetary Control Groups O
.C
T
9. Hands on Session O
P
S
G
O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Recurring Journals

•Create Recurring Journals for transactions that occur every Accounting Period
• Create three types of Journals using Recurring Journals M
O
Skeleton Journals .C
T
• Enter accounts only O
P
• Do not enter a formula to create skeleton journals
S
• Each generation produces journal entries with no journal line amounts
G
• Enter journal Line amounts using Enter Journals form
O
L
.B
Standard Journals
8
8constants to generate recurring standard journals
• Enter Accounts and Constant Amounts
S
• Enter a formula using
Pproduces a journal with identical Journal line amounts
• Each generation
P Sector Distance can be created as a standard recurring
• Example, Average
journalA
E
FormulaLJournals
C
A • Enter Accounts and variable amounts
R • Enter a formula using Accounting Flexfields as arguments
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Mass Allocation Journals

M
•Define a single formula to allocate amounts across a group of Balancing Segment values,
Cost Centers etc., O
.C
T
Allocate Amounts O
P
S
Common Pool Total Crew Cost(CC) G
O
L
.B
8
Basis of Distribution
8
-Cabin Crew Working (STAT)
S
by route / aircraft P
P
A
E
L
Target
C
A CC – CC – CC – CC –
R EWR BGO BOS SFO
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Auto Allocation Workbench

Auto Allocation Workbenches M

O
• Set-up the order in which allocation process has to be performed
.C
T
 Step Down Allocation
O
 Parallel Allocation P
S
G
• Use both Recurring Journals as well as Mass Allocation journals in the Auto Allocation
process O
L
.B
• Workflow to manage the whole Journal Creation and Accounting process.
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Mass Maintenance

Mass Maintenance
M
O
.C
Perform the following using Mass Maintenance
T
O
•
P
Move/Merge Operation - Transfers balances from one or more source accounts to one
S
or more target accounts. For example, cost of aircraft before allotting TAIL numbers can
G
later be moved from a generic aircraft number, like B744NO7 into Specific TAIL
O
number. L
.B
8 automatically based on existing accounts.
• Mass Creation - Create new accounts 8
Example - when a new Cost Center S is added, use another cost center as the basis to
P
P
create all the account combinations
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Document Sequencing

Document Sequencing
M
O
.C
• Methodology to number the transactions either automatically or manually
• Number vouchers based on the Journal Category T
O
P
Process for Document Sequencing S
G
a. Define Journal Categories O
b. Define Document Sequences L
. B
c.
8
Assign Document Sequences to Journal Categories
d. 8
Set profile option for Sequential Numbering for the responsibility
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgeting

Budgeting
M
O
.C
• Define Budgets to represent specific estimated costs and revenues for a range of
accounting periods. T
• O
Control Access to budget data by assigning passwords to the budgets.
P
• Maintain and revise unlimited number of budget versions. S
• Create budget journal entries to provide audit trial.
G
O
• L
Use GLDI or Oracle Financial Analyzer to upload budgets.
. B
•
8
Upload budgets from any external budgeting system
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgeting...

Budgetary Control and On line Funds Checking

M
O
• .C
Budgetary Control is the process of recording budget data and tracking actual data and
encumbrance against a budget. T
O
• P
Funds Checking prevents overspending budgets by verifying available funds online
before processing a transaction. S
 Online Checking and Reserving funds. G
O
 Immediate update of funds available balance.L
.B
 Control expenditures at detail and summary level.
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgeting...

Budgetary Control Options M

O
• Set Budgetary Control options for
.C
 Detailed accounts T
O
 Summary accounts P
S
 Journal entry sources and categories - in Budgetary Control Group.
G
• O
Enter Funds Check Level to control the severity of budgetary control checks.
L
 Absolute.
.B
 Advisory 8
8
 None. S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgeting...

 A Budget consists of periods, accounts and amounts

M
O
Anatomy of a Budget .CPeriods
T
O
P
S
G
Name : BM 2004 PLAN
O
Jan-04 to L
Dec-04
.B
8
8
S 5110 ---- GBP 100
P 7220 ---- GBP 200
P
A
E
Accounts L
C
A
R Amounts
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgeting...

 Define budgets, assign accounts to budget organizations, and record budget amounts using
different forms M
O
Accounts C
Amounts
.
Periods
Use Define Budget T
Use various forms to enter,
Use Define Budget form
Organization form O
calculate and transfer budget
Pamounts
S
G
O
Finance
L
.B
Dept

BD 2004 8 JE
PLAN 8Dept
Engg. Finance Dept GBP 400
S Engg. Dept GBP 700
P
P
A
E
L
C BD 2004 PLAN
A Jan-04 to Dec-04

R Finance Dept -- GBP 400

Engg. Dept -- GBP 700
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgeting...

Budget Accounting Cycle :

1 M
Define Budgets O
.C
Define Budget Organisation 2 T
O
P
Enter Budgets S3
G
O
L
.B
Review & Correct Budgets 4
8
8
SFreeze Budgets 5
P
P
A
E Define Budgetary Control Group 6
L
C
A
R Report on Budgets 7

O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Budgetary Control Groups

M
1) Do not perform budgetary control
Requi- Purchase
O
.C
sitions Orders
on transactions coming
from the CEO’s office T
O
FUNDS CHECK LEVEL - None
P
S
Invoices G absolute budgetary control
2) Perform
FUNDS CHECK LEVEL Oon invoices, but allow override for
Absolute L certain Accounts Payable users of
Override Amount 5000 GBP .B GBP 5000 or tolerance of 5 %
8
8
S
P Requisitions
3) Perform advisory budgetaryP
A
control for all requisitions
FUNDS CHECK LEVEL-Advisory
E
from Management Accounting
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
L End Day 2
General Ledger
B .
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
LBegin Day 3
General Ledger
B .
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

Agenda – Day 3 M
O
1. Recap of Day 1 & Day 2 .C
T
O
2. Encumbrance Types P
S
G
3. Revaluation O
L
4. Translation .B
8
8
S
5. Multiple Reporting Currencies
P
P
6. Lunch A
E
L
C
7. Global Consolidation System
A
R Inter-company System (GIS)
8. Global
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

M
9. Financial Statement Generator O
.C
• Row Set T
O
• Column Set P
S
G
10. Hands on session O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Encumbrance Types

1) The user department creates a M

Post a Commitment Encumbrance Journal
requisition for new equipment Requisition
O
.C
----- -----
------ -----
T
O
P
2) The Purchasing Department S
creates a Purchase Order Purchase
Order G BMI
to order the new equipment O Set Of Books
----- -----
------ ----- L
.B
Reverse the Commitment 8
8
S
and post an Obligation
Encumbrance JournalP
P Reverse the Obligation
A
3) The Payables Department
E Invoice
receives an invoice for the equipment
and post an Actual
from the vendor L ----- ----- Payables Journal
C ------ -----
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Revaluation

M
USD O
.C
Foreign Currency T
O
P
S
G
R E VA L U E O
L
.B
8
8
S
P GBP
P
A
Functional Currency
E arising out of revaluation is posted to Unrealized Gain/Loss
L
• The exchange rate difference
Account C for Revaluation and automatically mark them for Reversal in the
A
• Generate Journals
R
immediate following period
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Translation

Functional Currency
M
O
GBP .C
T
O
P
S
TRANSLATE G
O
L
.B
8
8
S
P USD
P
A Foreign Currency
E
L
C
• Oracle General Ledger translates Balance Sheet and Income Statement Accounts as per
SFAS 52 A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Multiple Reporting Currency

Multiple Reporting Currency (MRC)

M
O
.C
•MRC permits Organisation to maintain and report on multiple functional currencies at
transaction level
T
O
P
•MRC can be used when both transactions and general account balances are required for
reporting in multiple currencies S
G
MRC Set up O
L
. B
8
•Define additional set of books with functional currency in the reporting currency
8
SPrimary and Reporting Set of Books in Multiple
•Enable the Set of Books type for both
P
Reporting Currencies tabbed region
P
A
E books to the primary set of book
•Assign the reporting set of
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
MRC...

•Define Conversion options for each application M

O
•Define General Ledger conversion rules .C
T
•Define Reporting responsibilities O
P
•Assign Profile Option for the reporting responsibilities S
G
O
•For Sub-ledger responsibilities, attach MO:OperatingLUnit profile option
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Consolidation

Consolidation M
O
Consolidation within a Single Set of Books
.C
T
• Multiple companies represented by multiple values in the balancingO
segment
P
S
• No separate consolidation is required. Achieved by Parent - Child Relationship
G
O
Consolidation from Multiple Sets of Books L
.B
8
8
• Required when multiple sets of books are maintained where transactions are entered and
S together.
balances are held, which needs to be reported
P
• Consolidation can take place P
either at Balance Level or at Transaction Level.
A
• Actual Balances as wellEas Budget Balances can be consolidated from one book to
another. L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Consolidation...

Subsidiary 1 Subsidiary 2 Subsidiary 3 M

Set of Books Set of Books Set of Books O
.C
T
O
P
S
CONSOLIDATE G
O
L
.B
8
8
SParent
PSet of Books
P
A
E
L
• Oracle General Ledger enables you to consolidate one or more sets of books into another
C
for reporting purposes
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Consolidation...

M
O
.C
T
O
P
S
G
O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Consolidation...

Consolidation Steps : 1
Define Sets of Books
M
O
Define Parent and Subsidiary Relationship 2
.C
T
O3
Define Segment Mapping P
S
G
Create Mapping Set (O) O 4
L
.B
8
Prepare Consolidation Data 5
8
S
P
PPerform Consolidation 6
A
E
LDefine and generate Elimination Entries
C 7
A
R Post Consolidation Journals
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Inter-Company Accounting

Inter-company Accounting
M
Intercompany Accounting within a Single Set of Books O
.C
T
O
• Inter company journals are identified by the different balancing segment
values with in a Single Journal P
S
• However, Journals are balanced for each of the balancingG segment value
during posting. O
L
• Based on the Setup parameters for Intercompany. Baccounting, appropriate
8
I/C Receivable and Payable accounts are populated.
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Global Intercompany System (GIS)

Intercompany Accounting with Multiple Sets of Books M

O
• Processed through GIS - Global Intercompany System .C
T
O
• Can also be between Sets of Books which does not reside in the same instance
also. P
S
• Transactions are identified by the Transaction Type. G
O
L
.B
• Rules can be defined to derive the I/C Clearing Accounts and the Receiver’s
Distribution account also.
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
GIS…

GIS - With Multiple Sets of Books M

O
.C
T
O
P
S
G
O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
GIS…

GIS - With Multiple Sets of Books in M

different instances O
.C
T
O
P
S
G
O
L
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
GIS…

GIS Accounting Cycle :

1 M
Define Subsidiaries O
.C
Set up I/C Profile Option 2 T
O
P
Define I/C Transaction Types S3
G
O
L
.B
Define I/C Clearing Accounts 4
8
8
S
Define Accounting Rules 5
P
P
A
E
Enter, Review & Approve Transactions 6
L
C
A
R Transfer Txns and Post 7

O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Inquiries and Reports

• Online Inquiries M
O
• Online viewing of actual, budget, encumbrance and funds available balance for
summary and detail accounts.
.C
T
• Drill Down to the detailed information. O
P
S
• Standard Reports G
O
L
.B
• Use a variety of standard management and accounting reports for detailed
8
information such as Chart of Accounts Listing, Journal Reports, General Ledgers,
8
Account Analysis and Trial Balances.
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Financial Statement Generator

Reports M
O
• Custom Reports .C
T
O
• Use Financial Statement Generator (FSG) to build custom reports without
programming. P
S
G
• Define reports online with complete control over its rows, columns and contents.
• Create reports across Set of Books. O
L
.B
• Control the display of information in reports.
8 attention.
• Highlight information requiring special
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Financial Statement Generator

M
• Create Customized financial reports on account balances using the Oracle General Ledger
Financial Statement Generator (FSG) O
.C
Define Row Sets 1 T
O
P
Define Column Sets
S
G 2

O
L
.B
Define Content Sets 3

8
8
S Define Row Orders 4
P
P
A Define Display Sets
E 5
L
C
A A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Financial Statement Generator

A M
O
.C
6 T
Autocopy Report Components O
P
S7
Define Reports G
O
L
.B
Define Report Sets 8
8
8
S
Autocopy Reports and
9
P Report Sets
P
A Request Reports and
E Report Sets
10
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Financial Statement Generator

Row and Column Sets M

O
•Row Set and Column sets are 2 primary building blocks of FSGs.
.C
T
•Utilize the Row/Column Set for several reports. O
P
S
•Assign Accounts or Calculations to a row or column. Calculations are useful for creating
totals,subtotals, variances or percentages G
O
L
•Use Column Set Builder for building columns easily and to give an idea of how the report
will look after FSG runs it .B
8
8
Row Order S
P
P
A
•Display Account Values and/or Description
E
L
•Change Account Segment order
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Financial Statement Generator

Display Options:
M
•Display or don’t display a row or column O
.C
•Display or don’t display when the balance is Zero T
O
•Change Sign P
S
G
•Choose to display the amounts on report at different precision levels, or factors (like
O
Units,thousands or millions)
L
.B
•Level of detail reporting allows for screening out excessively detailed information when you
8
run reports for high level audience
8
S
P
Content Set: P
A
•Assign a content set to aE
L report and generate hundreds of similar reports in a single run.
C
A
•Content set can be saved as part of report definition or can be added dynamically when you
R
request an FSG report
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
L End Day 3
General Ledger
B .
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
LBegin Day 4
General Ledger
B .
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Agenda

Agenda – Day 4 M
O
.C
1. Recap of Day 1 / Day 2 and Day 3 T
O
P
2. Financial Statement Generator (FSG) Contd… S
G
O
3. Application Desktop Integrator (ADI) L
.B
4. Lunch 8
8
S
5. ADI Contd… P
P
A
6. Hands on SessionE
L
C
A of the training sessions and Q& A Session
7. Quick recap
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Financial Statement Generator

Display Sets and Display Groups: M

O
.C
•Produce report variations which omit sensitive information or which include information
T
normally not included in the reports. However, hidden columns cannot be subsequently
displayed using a display set O
P
S
•Display set can be saved as part of report definition or can be added dynamically when
submitting an FSG report. G
O
Report Sets: L
.B
8on a sequential order
8
•Use report sets to group several reports to run
S
P
Scheduling Reports: P
A
E
L
•Use the “Run Financial Statement Generator” to schedule the reports to run on specific dates
and specific times C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Application Desktop Integrator(ADI)

 The Application Desktop integrator is a spreadsheet based tool for entering Budget amounts,
entering journals, and running financial reports M
O
.C
 Application Desktop Integrator operates within Microsoft Excel, allowing you to take full
T
advantage of familiar Excel functionality while seamlessly integrating with Oracle General
Ledger O
P
ADI includes S
G
Budget Wizard O Analysis Wizard
L
.B
8
8
Journal Wizard S
P Account Hierarchy Editor
P
A
E
L
C
Report Wizard ADI - Asset Options
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Application Desktop Integrator

a. Budget Wizard
M
Provides a spreadsheet based interface to simplify budget data entry and modelling. O
. C
T
Use budget wizard to download existing budget balances from General Ledger or create a new
budget
O
P
b. Journal Wizard
S
Design and automatically generate spreadsheet-based journalG entry worksheets and enter data in
the worksheet. O
L
. B security rules, and reference
ADI validates the data you enter against the accounts,
8
information you defined in General Ledger. Automatically upload journals to General Ledger.
8
c. Report Wizard S
P
P
Report Wizard provides a spreadsheet-based interface to General Ledger’s Financial Statement
Generator (FSG). A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/
Account Hierarchy Editor

d. Analysis Wizard
M
Analysis Wizard combines multidimensional analysis with report drilldown, completely O
.C
within Excel. You can select amounts from spreadsheet reports and drill into the underlying
financial information within Oracle Applications. T
O
P
Select an individual account and drill into its summary balances, detail balances, journal
lines, down to Payables and Receivables subledger details. S
G
e. Account Hierarchy Editor O
L
.B
The Account Hierarchy Editor is a powerful tool that allows you to create, maintain,
8
simulate, view, and print your Oracle General Ledger account hierarchies.
8
S
 With its drag and drop graphical user interface, the Account Hierarchy editor is intuitive,
flexible, and easy to learn. P
P
A
 The user interface is extremely fast and features scrolling windows and split screens to
E
maximize your efficiency.
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
End of General L
Ledger Training
.B
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA
http://oracleapps88.blogspot.com/

M
O
.C
T
O
P
S
G
O
L
Thank
.B You
8
8
S
P
P
A
E
L
C
A
R
O
RAJU CHINTHAPATLA
RAJU CHINTHAPATLA