Sunday Jul 03, 2016

Get Help to Reconcile Primary - Secondary Ledgers: SQL Diagnostic

The Secondary Ledgers store additional accounting representations of the information present in the Primary Ledger. There are different levels of detail in which this information is stored, which are called Conversion levels. Even though Secondary Ledgers are optional, they are intensively used in order to fulfill various business needs. 

Secondary Ledgers can differ from Primary Ledgers in one or more of the following components: 

  • Chart of Accounts
  • Accounting Calendar / Period Type Combination
  • Currency
  • Subledger Accounting Method
  • Ledger Processing Options

Reconciliation is performed usually at period end, users attempt to verify the balances or transactions transferred between ledgers. Depending on setup differences between Primary and Secondary Ledgers, setup complexity, especially where the Chart of Accounts is different between ledgers, also depending on the volume of data and summarization options, Reconciliation process can be difficult and time-consuming.

To support such activities, we have released a New Diagnostic that would help point out the main issues that could cause differences in balances between Primary and Secondary Ledgers.

Relevant validations are performed, suggestions to resolve the reported issues offered.

Find it here: Primary Ledger to Secondary Ledger Diagnostics with Pointers to Reconciliation (Doc ID 2137066.1)

Very helpful SQL Diagnostic, download it today!

Wednesday May 04, 2016

Webcast: Reconcile Oracle Receivables to General Ledger With Ease

Reconcile Oracle Receivables to General Ledger With Ease

Date:May 18, 2016 at 11 am ET, 8 am PT, 4 pm GMT, 8:30 pm India (Mumbai)

This one-hour Advisor Webcast is recommended for Receivables users who perform, or have an interest in, reconciliation of Receivables to General Ledger. We will review standard reports used, methods to reconcile, briefly touch on reconciliation within Receivables, and go over troubleshooting tips. We will also walk through the reconciliation and troubleshooting processes using a short demonstration.

Topics will include:

  • Getting ready to reconcile
  • Standard reports
  • Steps & methods to reconcile
  • Troubleshooting tips
  • Reconciliation demonstration

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 18-May-16: Reconcile Oracle Receivables to General Ledger With Ease

Tuesday Jan 26, 2016

Reconciling Receivables to General Ledger

What is AR to GL Reconciliation Report?

  • Compares the Account Balances process from Receivables to General Ledger
  • Highlights Journal Sources where Discrepancies Exist
  • Report will show differences between Account Balances only if item did not successfully process to General Ledger
  • Pulls information from the XLA tables to General Ledger during the Import Process of Create Accounting or Submit Accounting from Receivables
[Read More]

Thursday Oct 15, 2015

Webcast: How to Create Bank Statements & Reconciliations in Oracle Cash Management

Webcast_icon.jpgHow to Create Bank Statements & Reconciliations in Oracle Cash Management

Date: October 28, 2015 at 11:00 am ET, 8:00 am PT, 3:00 pm GMT, 8:30 pm, India Time (Mumbai)

This one-hour Advisor Webcast is recommended for functional users who want to learn more about importing/creating bank statements & reconciling receipts in Oracle Cash Management. We will review related setups, create bank statements, reconcile receipts and debug bank statement issues.

Topics will include:

  • Setting up Cash Management to use with Oracle Receivables
  • Manual & imported bank statement creation
  • Manual & AutoReconciliation
  • Data Flow
  • Debug bank statement issues

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast on 28-Oct-15: How to Create Bank Statements & Reconciliations in Oracle Cash Management

Tuesday Jun 24, 2014

Journal Lines Reconciliation - What's Different in Release12?

General Ledger Reconciliation feature allows accounting users to reconcile transactions for accounts that should balance to zero, cross-referencing such transactions with each-other through reconciliation references. Either Manual or Automatic, using references from GL or Subledgers, including complete accounting code combinations or just the natural account segment value, when the balance for a group of transactions is zero the transactions are marked as reconciled. 

What's different in Release12?  

Part of European Localizations in 11i, Reconciliation feature was incorporated in the Standard Applications Release 12 due to its importance for the business.

What features are included?

  • Populate reconciliation references for journal lines or headers
  • Create references from Subledgers directly
  • Replicate references to Reporting Ledgers
  • Perform Manual or Automatic reconciliation
  • Multi-currency reconciliation
  • Report on reconciled-unreconciled transactions
Reconciliation form

Need to know more?  

Find out all the details related to available features, setup requirements, reporting, technical information - all delivered in clear steps with screenshots and quick tips through this New Whitepaper Document:

Journal Line Reconciliation in R12: A Whitepaper (Doc ID 1673357.1)

Share this with your financial users today!


Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« July 2016