R12 General Ledger Ppt 6y261l
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report r6l17
Overview 4q3b3c
& View R12 General Ledger Ppt as PDF for free.
More details 26j3b
- Words: 963
- Pages: 45
1
General Ledger Overview Oracle General Ledger is a comprehensive Financial Management solution that dramatically enhances financial controls, data collection and financial reporting throughout your enterprise.
2
Agenda
• Process Overview • Integration with Modules • Key Functionality ing Set Up Manager Journals Consolidation, Translation, Revaluation
• Security • Open Interface • Reports
3
R12 General Ledger
4
General Ledger Process Open /Close periods
Analysis & Reports
Consolidate / Translate/ Revalue
Originating in GL General Ledger Process
Journal Entries
Sub Modules
Review & Correct JE’s
5
R12 General Ledger
6
Integration
Payables
Receivables
Assets
Inventory
Sub Ledger ing
General Ledger
Payroll
Projects
Cash Management
Purchasing
Treasury
Manufacturing
7
Integration with Sub-Ledgers Oracle Inventory
Asset Cost Depreciation Expense Retirement Gain/Loss
Oracle Assets
Invoices Payments Discounts Foreign Gains/Losses Encumbrances
Oracle Payables
Cost of Sales Adjustments Material Usages
Oracle Purchasing
Encumbrances
Oracle General Ledger
Oracle Project ing
Journal Entries
Oracle Receivables
Invoice / Billing Receipts Adjustments Debit/Credit memos
Oracle HR & Payroll
Employees Payroll Cost
External Systems 8
Integrating With Sub-Ledgers
SubSubLedgers
General Ledger
GL Interface Data Table
Journal Import
9
Integrating With External Systems •
You can integrate with external systems by using published open interfaces.
•
You can write import programs to import data from an external system or from your previous ing system.
•
You can initiate a full validation process during import.
10
R12 General Ledger
11
ing Setup Manager
Legal Entities
Ledgers
Operating Units
ing Setup Manager Reporting Currencies
Subledger ing
Inter & Intra Company ing
ing & Reporting Sequences 12
ing Setup Manager Concepts Primary Ledgers Main, record-keeping ledger Defined by 4Cs:
Chart of s › ing calendar › Primary currency › Sub ledger ing Method ›
Secondary Ledgers Optional, additional ing representations of your primary ledger Can differ in one or more of the following from the primary ledger:
Chart of s › ing calendar › Primary currency › Subledger ing Method ›
13
ing Setup Manager Concepts Maintaining Multiple ing Representations with Secondary Ledgers Legal Entity
ing
Corporate Ledger (Primary Ledger)
Local Statutory Ledger (Secondary Ledger)
SLA
SLA
Subledger Transactions Transaction
AP
AR
FA
Other Subledgers 14
ing Setup Manager Concepts – Reporting Currency If one or more of the following are different,
If difference is only currency,
US GAAP Accrual
Corporate Chart of s
Monthly Calendar
Use a Secondary Ledger
ing Method
Currency
Use Reporting Currencies 15
ing Setup Manager
16
ing Setup Manager
17
ing Setup Manager
18
ing Setup Manager
19
ing Setup Manager
20
ing Setup Manager
21
ing Setup Manager
22
Ledger Set
Grouping of ledgers with the same chart of s and calendar/period type combination Essentially treats multiple ledgers as one
23
R12 General Ledger
24
Types of Journals • Manual Journals • Imported Journals • Recurring Journals • Mass Allocation
25
Manual Journals
26
Recurring Journals
27
Recurring Journal
28
Mass Allocation Journals
1/3 1/3
1/3 Dept3 Dept2
Dept1
29
Mass Allocation Journal
30
Inquiry Rollup Groups • • • • •
Define rollup groups to capture different summary levels for each Parent and Child Segments. Use Summary s to view financial information at Summary Level Assign related parent values to rollup groups. Use Rollup groups when creating summary s. No limit to number of levels. No limit to number of Entities on each level.
Example Rollup Group
Total Assets
Rollup Group Level 1
Level 2 Rollup Group
Level 2.1
Fixed Assets
Level 2.2
Land Child Values
Child
Child
Child
Buildings
Current Assets
Cash
Bank
Child
31
R12 General Ledger
32
Consolidation Subsidiary 1 Set of Books
Subsidiary 2 Set of Books
Subsidiary 3 Set of Books
CONSOLIDATE
Parent Set of Books
33
Translation • Translation and re-measurement • • • •
methods Period average and end rates historical rates Period to date and year to date modes Translation method
Functional Currency
KWD
KWD
KWD
TRANSLATE
USD
USD
USD
Foreign Currency 34
Revaluation converts to USD
KWD
Foreign currency
Functional currency
REVALUE
converts to USD Foreign currency
KWD Functional currency
35
R12 General Ledger
36
Security
CROSS VALIDATION RULE
Cross validation rules prevent the combination of certain segment values in the chart of s.
SEGMENT SECURITY RULE Security gives you the capability to restrict the set of values a can use during data entry
37
Security
DEFINITION ACCESS SET
DATA ACCESS SET
• Control access to setup/reference independently of data security • Enable setup sharing across ledgers and ledger sets • Enable setup autonomy within multilegal entity ledgers • Set up view, modify, and usage privileges
Access multiple legal entities and ledgers from a single GL responsibility
CONTROL S
• • • • • • • • •
ing Calendars Auto Allocations AutoPost Criteria Sets Auto Reversal Criteria Sets Budget Formulas Budget Organizations Chart of s Mappings Consolidation Definitions Consolidation Sets
• • • • • • • •
Elimination Sets FSG Reports and components Mass Allocation Mass Budgets Rate Types Recurring Journals Revaluations Transaction Calendars
Restrict the usage of Control s in manual Journal Entry
38
R12 General Ledger
39
Open Interface GL_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_BUDGET_INTERFACE
To Import Journal lines from peripheral systems and Oracle Sub ledgers
To Import Currency Exchange Rates from external sources
To Import Budget Journals from external sources
40
R12 General Ledger
41
Reports • • • • • • •
Financial Statement Generator Analysis ing Set Up Manager Post-Update Diagnosis Report Consolidation Journals Report Journals Day Book Trail Balance Import Journals
42
Financial Statement Generator FSG Reports
Rows
Income Company statement
columns column set
PTD Sales Returns Net Sales
Row Set A
YTD
3000
6200
1000
1200
2000 5000
Balance Sheet
column set Row Set B
Cash Investments receivables
YTD
Last Y
3000
4200
1000
2200
3000 2000 43
QUESTIONS ANSWERS
44
45
General Ledger Overview Oracle General Ledger is a comprehensive Financial Management solution that dramatically enhances financial controls, data collection and financial reporting throughout your enterprise.
2
Agenda
• Process Overview • Integration with Modules • Key Functionality ing Set Up Manager Journals Consolidation, Translation, Revaluation
• Security • Open Interface • Reports
3
R12 General Ledger
4
General Ledger Process Open /Close periods
Analysis & Reports
Consolidate / Translate/ Revalue
Originating in GL General Ledger Process
Journal Entries
Sub Modules
Review & Correct JE’s
5
R12 General Ledger
6
Integration
Payables
Receivables
Assets
Inventory
Sub Ledger ing
General Ledger
Payroll
Projects
Cash Management
Purchasing
Treasury
Manufacturing
7
Integration with Sub-Ledgers Oracle Inventory
Asset Cost Depreciation Expense Retirement Gain/Loss
Oracle Assets
Invoices Payments Discounts Foreign Gains/Losses Encumbrances
Oracle Payables
Cost of Sales Adjustments Material Usages
Oracle Purchasing
Encumbrances
Oracle General Ledger
Oracle Project ing
Journal Entries
Oracle Receivables
Invoice / Billing Receipts Adjustments Debit/Credit memos
Oracle HR & Payroll
Employees Payroll Cost
External Systems 8
Integrating With Sub-Ledgers
SubSubLedgers
General Ledger
GL Interface Data Table
Journal Import
9
Integrating With External Systems •
You can integrate with external systems by using published open interfaces.
•
You can write import programs to import data from an external system or from your previous ing system.
•
You can initiate a full validation process during import.
10
R12 General Ledger
11
ing Setup Manager
Legal Entities
Ledgers
Operating Units
ing Setup Manager Reporting Currencies
Subledger ing
Inter & Intra Company ing
ing & Reporting Sequences 12
ing Setup Manager Concepts Primary Ledgers Main, record-keeping ledger Defined by 4Cs:
Chart of s › ing calendar › Primary currency › Sub ledger ing Method ›
Secondary Ledgers Optional, additional ing representations of your primary ledger Can differ in one or more of the following from the primary ledger:
Chart of s › ing calendar › Primary currency › Subledger ing Method ›
13
ing Setup Manager Concepts Maintaining Multiple ing Representations with Secondary Ledgers Legal Entity
ing
Corporate Ledger (Primary Ledger)
Local Statutory Ledger (Secondary Ledger)
SLA
SLA
Subledger Transactions Transaction
AP
AR
FA
Other Subledgers 14
ing Setup Manager Concepts – Reporting Currency If one or more of the following are different,
If difference is only currency,
US GAAP Accrual
Corporate Chart of s
Monthly Calendar
Use a Secondary Ledger
ing Method
Currency
Use Reporting Currencies 15
ing Setup Manager
16
ing Setup Manager
17
ing Setup Manager
18
ing Setup Manager
19
ing Setup Manager
20
ing Setup Manager
21
ing Setup Manager
22
Ledger Set
Grouping of ledgers with the same chart of s and calendar/period type combination Essentially treats multiple ledgers as one
23
R12 General Ledger
24
Types of Journals • Manual Journals • Imported Journals • Recurring Journals • Mass Allocation
25
Manual Journals
26
Recurring Journals
27
Recurring Journal
28
Mass Allocation Journals
1/3 1/3
1/3 Dept3 Dept2
Dept1
29
Mass Allocation Journal
30
Inquiry Rollup Groups • • • • •
Define rollup groups to capture different summary levels for each Parent and Child Segments. Use Summary s to view financial information at Summary Level Assign related parent values to rollup groups. Use Rollup groups when creating summary s. No limit to number of levels. No limit to number of Entities on each level.
Example Rollup Group
Total Assets
Rollup Group Level 1
Level 2 Rollup Group
Level 2.1
Fixed Assets
Level 2.2
Land Child Values
Child
Child
Child
Buildings
Current Assets
Cash
Bank
Child
31
R12 General Ledger
32
Consolidation Subsidiary 1 Set of Books
Subsidiary 2 Set of Books
Subsidiary 3 Set of Books
CONSOLIDATE
Parent Set of Books
33
Translation • Translation and re-measurement • • • •
methods Period average and end rates historical rates Period to date and year to date modes Translation method
Functional Currency
KWD
KWD
KWD
TRANSLATE
USD
USD
USD
Foreign Currency 34
Revaluation converts to USD
KWD
Foreign currency
Functional currency
REVALUE
converts to USD Foreign currency
KWD Functional currency
35
R12 General Ledger
36
Security
CROSS VALIDATION RULE
Cross validation rules prevent the combination of certain segment values in the chart of s.
SEGMENT SECURITY RULE Security gives you the capability to restrict the set of values a can use during data entry
37
Security
DEFINITION ACCESS SET
DATA ACCESS SET
• Control access to setup/reference independently of data security • Enable setup sharing across ledgers and ledger sets • Enable setup autonomy within multilegal entity ledgers • Set up view, modify, and usage privileges
Access multiple legal entities and ledgers from a single GL responsibility
CONTROL S
• • • • • • • • •
ing Calendars Auto Allocations AutoPost Criteria Sets Auto Reversal Criteria Sets Budget Formulas Budget Organizations Chart of s Mappings Consolidation Definitions Consolidation Sets
• • • • • • • •
Elimination Sets FSG Reports and components Mass Allocation Mass Budgets Rate Types Recurring Journals Revaluations Transaction Calendars
Restrict the usage of Control s in manual Journal Entry
38
R12 General Ledger
39
Open Interface GL_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_BUDGET_INTERFACE
To Import Journal lines from peripheral systems and Oracle Sub ledgers
To Import Currency Exchange Rates from external sources
To Import Budget Journals from external sources
40
R12 General Ledger
41
Reports • • • • • • •
Financial Statement Generator Analysis ing Set Up Manager Post-Update Diagnosis Report Consolidation Journals Report Journals Day Book Trail Balance Import Journals
42
Financial Statement Generator FSG Reports
Rows
Income Company statement
columns column set
PTD Sales Returns Net Sales
Row Set A
YTD
3000
6200
1000
1200
2000 5000
Balance Sheet
column set Row Set B
Cash Investments receivables
YTD
Last Y
3000
4200
1000
2200
3000 2000 43
QUESTIONS ANSWERS
44
45
Related Documents 171j1w
R12 General Ledger Ppt 6y261l
December 2019 44
General Ledger Interview Questions In R12 4l452g
November 2019 47
General Ledger Interview Questions In R12 4l452g
October 2019 56
Oracle Fsg General Ledger 3i5m4d
November 2019 68
Br100 General Ledger Complete 5m4852
October 2019 57