04 GeneralLedger
04 GeneralLedger
[ 12 May – 16 May ]
[ 09 Jun – 13 Jun ]
[ 23 Jun – 26 Jun ]
The following is intended to outline our general product direction. It is intended for information purposes
only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or
functionality, and should not be relied upon in making purchasing decisions. The development, release,
timing, and pricing of any features or functionality described for Oracle’s products may change and remains
at the sole discretion of Oracle Corporation.
Statements in this presentation relating to Oracle’s future plans, expectations, beliefs, intentions and
prospects are “forward-looking statements” and are subject to material risks and uncertainties. A detailed
discussion of these factors and other risks that affect our business is contained in Oracle’s Securities and
Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q
under the heading “Risk Factors.” These filings are available on the SEC’s website or on Oracle’s website
at http://www.oracle.com/investor. All information in this presentation is current as of September 2019 and
Oracle undertakes no duty to update any statement in light of new information or future events.
• GL Balances Cube
• GL Security
• Journal Entry to Period Close
• Accounting Automation
Confidential - Oracle Restricted
GL Balances Cube
Processes
✓ Create Accounting process
✓ Post Subledger Journal Entries process ERP & EPM Integration
✓ Import Journals process Options and Strategies
✓ AutoPost Journals process
GL Balances Cube
✓ Dimensions
• GL Balances Cube
• GL Security
• Journal Entry to Period Close
• Accounting Automation
Confidential - Oracle Restricted
Job Roles
General Accountant
Records and reports financial transactions and manages revenue,
expense, asset, liability and equity accounts. Responsible for recording
accounting adjustments, accruals, allocations, currency revaluations
and translations.
Financial Analyst
Analyzes the financial performance of an enterprise or an organization
within an enterprise.
• GL Balances Cube
• GL Security
• Journal Entry to Period Close
• Accounting Automation
Confidential - Oracle Restricted
Open Year /
Close Year Open Period Close Period
Period
✓ Perform Allocations
✓ Translate Balances
Allocations
Open Year /
Close Year Open Period Close Period
Period
• Allocations are defined and generated from pre- Transaction Company Cost Center Account Employees
aggregated balances in the GL Balances cubes.
101 10 6001 25
• Source, Target, Basis & Offset 101 11 6001 5
Statistical
101 12 6001 15 Basis
• Use Cases Journal
101 15 6001 20
o Allocate expenses by department headcount
o Bad Debt Allowances 101 20 6001 35
o Intercompany Eliminations etc., Total 100
Target
• Across Ledgers within a Ledger Set Transaction Company Cost Center Account Debit Credit
• Spreadsheet Support
• Video Replay
Revaluation
Open Year /
Close Year Open Period Close Period
Period
✓ Revaluation process is used to adjust account balances denominated in a foreign currency; due to changes in
conversion rates between the date of the original journal and the revaluation date.
Translation
Open Year /
Close Year Open Period Close Period
Period
✓ Translate General Ledger Account Balances process restates the actual account balances from the ledger
currency to the Balance Level reporting currency • Typical translation rules / methods:
o Balance sheet accounts [always YTD & Period
End Rate]
Ending Balance DR Ending Balance CR o Equity [default PTD & Historical Rate FBDI]
Account Code Combination Functional Currency Functional Currency o Income statement accounts [default PTD &
EUR EUR Period Average Rate]
Accounts Receivable 101-00-1002-000-000 10,000 • The first accounting period translated becomes the
initial translation period for the specified balancing
Revenue 101-00-5010-000-000 10,000 segment values.
• If you're submitting the translation process for the first
time, select the Accounting Period carefully. After the
• Period End Rate: 1.2785 initial translation period is set, you can't run the
• Period Average Rate: 1.2581 translation process for any earlier period.
• You can rerun the process if you post additional journal
Ending Balance DR Ending Balance CR entries or change translation rates.
Account Code Combination Reporting Currency Reporting Currency • The daily rates that are defined for the last day of the
USD USD period for the corresponding period average and period
end rate types are used as the translation rates. If the
Accounts Receivable 101-00-1002-000-000 12,785 rate for the last day of the period doesn't exist, the
translation process searches back within the period until
Revenue 101-00-5010-000-000 12,581 a rate is found. If no rate exists for the period, the
translation process ends in error.
Cumulative Translation
101-00-5050-000-000 204
Adjustment Account CTA • Reference
• How Translated Balances Are Deleted
• Translation: Functional Deep Dive
• Cumulative Translation Adjustment Account [CTA] is defined in Specify Ledger Options
Consolidation
Open Year /
Close Year Open Period Close Period
Period
If your subsidiaries and corporate ledger share the same chart of If there are complex factors in your financial consolidation
accounts and calendar. requirements such as:
Balance Transfer Consolidations: o Managing period close process, assigning tasks, scheduling
and workflow monitoring
If your subsidiaries and corporate ledger have either or both different
charts of accounts and different calendars. o Complex company structures, for example joint ventures,
minority interest holdings, or partially or fully owned
subsidiaries.
InFusion UK RC InFusion UK RC
InFusion UK Ledger
USD USD
Corp COA, Corp Cal, GBP
InFusion Corp
Ledger Set
InFusion US Ledger InFusion US Ledger • Create a chart of accounts mapping to map subsidiaries
Corp COA, Corp Cal, USD Corp COA, Corp Cal, USD account values to the corporate chart of accounts.
InFusion Corp
Elimination Ledger
Intercompany Eliminations
Closing Period
Open Year /
Close Year Open Period Close Period
Period
• Ensures an effective period close process by validating all transactions are complete and are not held up during the close.
• You can exclude one or more of the following subledgers so the General Ledger period close process skips any exceptions encountered within the context of the
excluded subledgers (by updating ORA_GL_INCLD_STRICT_PRD_CLOSE lookup) :
o Payables
o Receivables
o Revenue Management
o Project Foundation
o Cost Management
o Assets
Open Period
Open Year /
Close Year Open Period Close Period
Period
AutoReverse
• Used for accruals, estimates, revaluations, closing entries, errors, or
temporary adjustments and reclassifications
• Create Income Statement Closing Journals process creates a journal Revenue 101-00-2050-000-000 0 0
entry that shows the selected revenue and expense account balances
moved to the retained earnings account. Optionally use Offset account. Expense 101-00-5050-000-000 0 0
• GL Balances Cube
• GL Security
• Journal Entry to Period Close
• Accounting Automation
Confidential - Oracle Restricted
Accounting Automation
• Accounting automation streamlines and automates end-to-end accounting and transaction processes, including daily rates import, accounting creation, journal import,
and journal posting. Data flows through all of the required processing steps without user intervention. Users are notified of exceptions and provided with the information
to help resolve them. Additional users can optionally be notified of errors generated during the transaction accounting process.
• Exclusion of Ledgers [New in 23D] – Ledgers can be excluded from Accounting Automation, so that they can be processed at more controlled times or frequencies
Reference: Replay
Documentation: Guide
Services Receiver
• Fusion Intercompany Transactions: Process Flow
Payables
• Fusion Intercompany Invoicing Flow General Ledger
Invoice