Interfacing with the General Ledger
Richard Byrom
Oracle Applications Consultant
13th Cheque Payroll Seminar
12th December 2001
Agenda
Set of Books
Standard Oracle Interfaces
Payroll Interfaces
Applications Desktop Integrator
Set of Books
In order to determine what information is
required to be interfaced into the General
Ledger the infrastructure of the General
Ledger/ Set of Books needs to be understood
Set of Books
A set of books consists of a chart of accounts structure,
an accounting calendar, and a functional currency.
Set of
books
Functional
Chart of accounts currency
structure Accounting
calendar
Chart of Accounts Structure
Define a flexible chart of accounts structure:
Create up to 32 segments of up to 25
characters per segment.
Define each segment name and the order in
which it appears.
Attach a list of valid values to each segment.
Chart of Accounts examples
Tailor your account structure for your industry and reporting requirements.
Choose the number of segments, as well as the length, name, and order of
each segment.
Examples:
Manufacturing:
XX XXXXXX XX XX XX XXX
Company Cost Center Account Product Product Line Sub account
News Distribution:
XX XXXXX XXX XXX XX
Division Account Region Story Distribution
Project Oriented:
XXX XXXXX XXX XXXX XX
Company Account Department Project Project Type
Multiple books for multiple companies
Each corporation may include multiple sets of books.
Each set of books may include multiple companies
and/or divisions.
Corporation
Sets of books
Companies
Divisions
Standard Oracle Interfaces
Import journal entries from feeder systems
Third Party Systems - Billing, Banking etc.
Oracle Sub-ledgers - AP, AR,Payroll
Includes statistical information - airtime, customers
Review journal import data
Correct and delete journal import data
Interface Overview
Create journals in feeder systems and upload them to
Oracle General Ledger using Journal Import.
Summary or Detail Automatic or Manual
Journal
Subledgers GL_INTERFACE
Import
GL_JE_LINES
GL_BALANCES Post GL_JE_HEADERS
GL_JE_BATCHES
Importing Journals
Journal Import Verification Process
Load GL_INTERFACE Correct errors in
Table Feeder System
Journal import creates
Import journals by
a postable journal batch
source and Group ID
Delete source from
Do any of the No Journal Import
journals have errors?
Yes High
Number of
errors Low
Correct Journal
Import online
Drilling down to Sub-Ledger Detail
You can drill down further to see detailed
information about a respective journal activity in
a Sub-ledger.
Payroll Interface
Elements are all types of earnings, deductions,
employer charges and non-payroll payments that
go through the payroll.
Typical examples of elements are:
Regular Salary
Wages
Bonus Payments
Health Insurance
Stock Purchase Plan
Pension Contributions
Elements
Car Allowance
Compensation
Hospital Training
and
Benefits
Paid Time Off Equipment
Salary
Three Steps to Set Up an Element
Define the information to hold
Element
1 Definition
Define how to validate entries
Define how to process entries
Define who is eligible for the element
Element
2 Define costing
Link
Define how to validate entries
Put the element on record for all employees
Element
3 Entry
who should receive it
Automatic or manual entry
Payroll Interface
Summary or Detail Automatic or Manual
Journal
Payroll GL_INTERFACE
Import
GL_JE_LINES
GL_BALANCES Post GL_JE_HEADERS
GL_JE_BATCHES
ADI Functionality
Applications Desktop Integrator is a spreadsheet tool
which enables you to interface data in spreadsheet
format directly into Oracle, it can also drill down into
Oracle from a spreadsheet to provide you with the
required information. Its features are: -
Journal Import
Budgeting
Analysis and Drilldown
Fixed Asset Import
Account Hierarchy Editor
Physical Inventory Run
Import Text File