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!

Thursday Jun 30, 2016

Get a Better Understanding of GL Mass Allocations Across Ledgers

Mass allocations make a wonderful tool to be used for quick generation of journal entries for a group of cost centers, departments, divisions, ledgers. Instead of creating many manual journals to transfer amounts from one account to others based on specific business rules, users can create one allocation formula that will generate all these journals directly. 

It is That Easy! Define

  • Allocation Pool
  • Allocation Formula
  • Target and Offset Account

Run it! 

Mass Allocations help generate a variety of allocations - such as:

  • Net Allocations
  • Step-Down Allocations 
  • Rate-Based Allocations
  • Usage-Based Allocations
  • Standard Costing Allocations

You can group Mass Allocation formulas into batches even when they refer to different ledgers. 

The setup required to run Mass Allocations across ledgers is more complex; available features allow to enter a ledger or ledger set for the accounts, run based on entered currency or ledger's currency and more. 

We have prepared a Whitepaper for you that includes real business cases, examples, known issues and more - share it with the business users today:

Mass Allocation Across Ledgers in Release12 (Doc ID 2137586.1

Now Available: General Ledger Health Check Analyzer

EBS Analyzers are complex Diagnostics provided by Oracle to help troubleshoot issues, identify any problems and proactively help resolve any situation reported. The result is presented as an easy-to-read html page outlining items that need to be reviewed and adjusted, along with confirmation of correct validations for existing setups. You can execute the Analyzer via SQL script or Concurrent Request.

In the world of EBS Analyzers there is a NEW one available:  General Ledger Health Check Analyzer!

Perform immediate health check analysis, get proactive recommendations for:

  • Misclassified Accounts
  • Overlapping Child Accounts
  • Duplicate Rows in GL Tables
  • Period Closing
  • Calendar Overlapping periods or Gaps data
  • Budgetary Control 

In addition, find in the same output: 

  • Instance Overview
  • Proactive and Preventive Recommendations
  • Diagnostics Apps Check 

Use the power of almost All our GL Diagnostics by running a single Analyzer!

Download it now and find out more about this tool in: 

EBS General Ledger Health Check Analyzer (Doc ID 2117528.1)

Thursday Mar 31, 2016

Oracle AME Integrated With GL Journal Approvals. Business Considerations In Implementing This Enhancement

Oracle Approvals Management (AME) is an Application that provides the users with multiple options to define business rules applying to processes related to approving transactions in Oracle Applications where AME was integrated. 

Recently General Ledger Journals Approval process has been integrated with AME and Workflow, enabling enhanced methods for journals approval processes.

Find below a few relevant details that may help decide in bringing this enhancement to the business: 

  • Can Standard Journal Approval still be used? 

Yes, it is possible to use AME Journal Approval or the Standard GL processes; this is controlled by profile option setup: GL: Use Approval Management (AME).

  • How are organization changes affecting the approval process?
 AME recalculates the chain of approvers after each approval, therefore each transaction will be approved under the latest conditions being set up. 
  • Is the Preparer of the journal affected if AME Journal Approval is used?

The answer is Yes. If AME Journal Approval is enabled, this profile option will not be considered: Journals: Allow Preparer Approval; if the business requires to use this profile in order to control Preparer's access to approve the journal he creates, then use Standard Journal approval in GL as the only method that will take this profile into consideration.  However you may include the Preparer in the Approvers Group and get the same functionality working with AME  even without the profile setup. 

  • Is Approval Limits setup considered by AME?
Maintaining Approval Limits is not mandatory for AME but this setup step could be useful for subsequent AME definitions. 
  • What are the right business situations where AME Journal Approval should be used? 

There is no right or wrong here, this is entirely business decision depending on organizational structures and separations of duties. AME Journal Approval is more flexible, providing ways to be proactive by automatically detecting and routing the journals to approvers according to the separation of duties and not mandatory based on hierarchy; this is very relevant especially for those organizations where the hierarchy is very complex or the approval roles are granted based on skill sets and capabilities of individuals, rather than considering hierarchy only. 

This new feature enables enterprises to enhance their governance, control and compliance with pre-set business rules.  

See how it works here:

Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management (AME) and Oracle Workflow (Doc ID 2038960.1)


Wednesday Mar 30, 2016

Alternate Accounts - GL Feature That Helps Avoid Journal Import Errors

Subledger Create Accounting Program or GL Journal Import may sometimes fail due to having to transfer data into GL on an invalid account - one that was recently disabled or end-dated. 

To help avoid such errors, GL provides the feature of Alternate Accounts which gives the users an opportunity to setup a replacement code combination for an invalidated one, allowing the mentioned programs to continue until successful completion.

How to define this setup? 

Just navigate to GL > Setup > Accounts > Combinations - define your Alternate Account for the code combinations as needed:

General Ledger Alternate Accounts Sample

Where will the Alternate Account be used?

  • in  Subledger Create Accounting Program
  • in GL Journal Import process

Are there situations where Alternate Accounts can not be used?

  • they will not be considered by Subledger or GL forms where the accounts are entered by the users
  • will  not replace an account combination that has posting/budgeting disabled

I like this feature and want to know more!

Sure! Please review this useful document:

R12: How to Use Alternate Accounts in General Ledger? (Doc ID 2111940.1

Friday Mar 25, 2016

Recent Changes for Report Manager Affecting GL FSGs Publishing to Excel

General Ledger's Financial Statement Generator provides the option to create a large variety of custom reports based on General Ledger balances. 

Integration of Financial Statement Generator (FSG) with Report Manager and WebAdi to help publish such reports in Excel directly makes this tool even more powerful. 

Recent changes in Report Manager security code have caused FSG  to no longer publish as Excel file, generating either a template instead of the report, or simply throwing error of insufficient privileges being granted to the responsibility.

Prevent this issue from happening!

Please review these documents for details and solution:

Blank Excel Trying to Generate FSG Statement In Report Manager After JAN 2016 CPU Patch 22133441 (Doc ID 2115436.1)

Users Are Getting Insufficient Privilege Error While Trying To Open FSG Report in Report Manager. What Is The Required Menu Function To Resolve This Error? (Doc ID 2098187.1

Act now!

Monday Jan 11, 2016

Budgetary Control Setup and Funds Inquiry Diagnostic Available!

General Ledger incorporated many features and tools to create, maintain and track budgets, supporting also a variety of budgeting methods that facilitate specific reporting. Planning and implementing budgeting setup according to the business requirements need to be done very carefully; mapping such business needs on the available features may sometimes require more dedicated time and multiple setup reviews until completion.

Incorrect setup for budgeting may lead to: 

  • overspending budgets
  • overstated funds available which may determine incorrect business decisions
  • incorrect reporting on funds
  • bad accruals created in the system

Finding the setup cause for such undesired consequences was many times difficult even for the most experienced users. It just got Simple!

A new General Ledger Budgetary Control Setup and Funds Inquiry Diagnostic is now available to centralize setups and availability of funds!

Budget Diagnostic Sample

What's available inside?

  • budget and organization setup
  • budget organization account ranges
  • summary templates setup and associated summary accounts
  • detail code combinations associated to summary accounts
  • budgetary control group setup
  • funds inquiry/availability
  • calendar definition for the year

This will definitely save some time, download it now!

R12: General Ledger Budgetary Control Setup and Funds Availability/Inquiry Diagnostic (Doc ID 2079451.1)

comes just in time for new year budgeting setup and changes overview!

Tuesday Dec 29, 2015

GL Posting Performance After Database Upgrade to or Patch Available!

Posting journal entries in General Ledger is the last step of the accounting cycle, transferring these entries in a final state to update GL balances and locking them for further updates. This is the main GL process that will afterwards support Reporting on the balances, Translation, Consolidation and other business specific processes. As Posting is very common activity in GL, it is very important that the concurrent requests run with reasonable performance.

Posting bad performance was reported after Database Upgrade to or A higher parse time than 11g may be seen in 12c for a complex query with a multi-table join with SQL plan directives enabled.

Database Patch 20807398 is now available to fix this for you!

Did you upgrade the Database to the mentioned versions recently?

Proactively review this document today, before the users get to report performance issues:

GLPPOS: After Database Upgrade to or Posting Has Poor Performance Due to SQL Plan Directives (Doc ID 2068068.1)

Saturday Dec 26, 2015

General Ledger Calendar Definition for the New Year: Keep in Mind 2016 is a Leap Year!

General Ledger's Calendar is used to define 'years' from accounting perspective, allowing business users to decide on the periods and period types they would include. These may be identical or different from calendar-year perspective, meaning that they could include more than 12 periods (adjustment or non-adjustment periods), may follow a fiscal-year definition that is specific to a certain country or fiscal system, or simply match various business requirements.

On setting up GL Calendar for the next year, please keep in mind 2016 is a Leap Year! Do not miss February,29 from your calendar!

Accounting Calendar - February 2016

How to check the existing definition?

  • Simply verify the setup in General Ledger form - query for the calendar and relevant period
  • Under Gl responsibility, run Calendar Validation Report, check the output for any violations reported
  • Use SQL scripts to look into the tables directly

The following document may help: General Ledger Calendar Setup, Usage and Troubleshooting (Doc ID 130539.1)

Did you find a gap in your calendar?

If you already defined the calendar and just spotted a gap - most common mistake at this time of the year is to miss out February29 from the definition - Act Now!

Do Not use Sql to update the tables yourself as this may generate massive corruption. Let Oracle Support help!

Raise a Service Request sooner rather than later. Calendar missing dates is something we may be able to fix; as times passes, it adds complexity to the solution to be provided making it impossible to be applied for some cases, mostly due to having Subledgers tables affected too.

Check your GL Calendar now!

Thursday Oct 01, 2015

EBS General Ledger - Accounting Hub Reporting Cloud Service

Oracle Accounting Hub Reporting Cloud Service provides excellent reporting and analytics capabilities along with real-time access to information and latest accounting numbers. Drilldown to EBS balances, journals and subledger transactions is also available. 

The integration between the Accounting Hub Reporting Cloud Service and E-Business Suite Release12 continuously streams balances from EBS,

  • providing immediate access to updated financial data
  • supporting quick business decisions
  • offering enhanced reporting options with minimal effort, cost or risks
EBS General Ledger setups are loaded automatically to the Accounting Hub Reporting Cloud Service:
  • charts of accounts
  • calendars
  • hierarchies
  • ledgers
  • balances
Sample financial reports are already available!  

We encourage you to benefit and improve your business with Oracle ERP Cloud Service.

Check this Whitepaper today! 

Accounting Hub Reporting Cloud Service for E-Business Suite Customers (Doc ID 2034564.1)
Oracle ERP Cloud Welcome Note (Doc ID 1499539.1)

Monday Sep 28, 2015

New! Journal Approvals Integrated With Oracle Approvals Management and Oracle Workflow!

General Ledger Journal Approval features ensure that journal entries get approved by the appropriate managers before they can consume available funds or be posted in order to affect balances. The batches get validated in the flow and, if approval is required, they are submitted to management personnel based on the setup configuration, notifying the proper individuals regarding the approval results. In standard processes, approval is enabled at Ledger and Journal Source level.

For 12.1.3 and later Applications versions, General Ledger Journals Approval process just got enhanced! Development integrated this flow with Oracle Approvals Management and Oracle Workflow, allowing configuration of more flexible rules.

What's in it? 

  • routing to one or more approvers, sequentially or in parallel
  • tracking approval status for the journals processed
  • building rules for combinations of ledger, entered amount, approval level
  • using different parts of the journals as selection criteria, such as header, lines level - category, source, account, descriptive flexfield

New profile options!

  • GL: Use Approval Management (AME) for journal approval
  • GL: Number of journal lines to display in AME journal approval notification

This integration allows enterprises to improve governance, control, compliance requirements.

Take advantage now, download the Whitepaper from

Oracle General Ledger Journal Approvals Integration with Oracle Approvals Management and Oracle Workflow (Doc ID 2038960.1)

Thursday Jul 02, 2015

General Ledger Balances Corruption - Causes, Suggestions, Solutions

Finding correct and accurate balances in General Ledger(GL) at the end of each period and year is one of the main targets for the functional applications users and accounting departments. The GL balances are considered base for reporting purposes and also important to reveal the results and current position of the company based on the accomplishments and changes reflected by the accounts through balances. It is important to be able to rely on the trial balance reports.

What if the balances get corrupted? 

In the last months our Developers worked close with General Ledger Support team and reviewed all the balances corruption cases reported by customers, preparing a complex document to reflect their findings: 

  • Potential Causes identified
  • Solutions for each potential cause that could lead to corruption
  • Suggestions to prevent such corruptions from happening

Do review this document we have prepared for you - it will help prevent potential corruptions, allowing the users to focus on period closure activities and report on the balances without delays: 

General Ledger Balances Corruption - Causes, Solutions and Suggestions. (Doc ID 1995324.1

Wednesday Jul 01, 2015

iSetup? Use It Even Inside The Same Instance!

Oracle iSetup tool is a convenient solution to manage setups and parameters, moving setup configurations between instances as required by the business. This saves the time of rebuilding similar setups on different instances for various E-Business Suite modules ( Oracle Applications Library, General Ledger, HRMS, Payroll, Workflow and more).


Questions have been raised - is iSetup able to copy data even inside the same instance? The answer is: Yes!

Check this for more details: Can iSetup Be Used to Copy Data Inside the Same Instance? (Doc ID 2016589.1

For General Ledger you may copy setups related to:

  • Accounting Calendars
  • Budgeting
  • Chart of Accounts
  • Code Combinations
  • Currencies and Rates
  • Data Access Sets
  • ....and more!
Don't waste more time with rebuilding your setups, use iSetup now!

Tuesday Jun 30, 2015

Using Translation and Plan to Upgrade? Don't Miss This!

Translation is the process that converts balances from functional currency to foreign currencies, covering various reporting requirements. It is possible to translate

  • Actual Balances
  • Budget Balances 
  • Average Balances - if enabled for the ledger 

Once deciding to upgrade from Release11i to Release12, you need to consider the designed changes in the process as described in this document:

R12 Upgrade: Changes to Expect in R12 as Against Release 11i (Doc ID 1443965.1

  • Period End Rates and Period Average Rates no longer exist in R12 
  • Balances Maintained as Separate Reporting Ledger

If you are using Translation in your 11i instance, please visit this important guide we created for you in order to avoid known Post-upgrade Translation problems: 

 Pre-Upgrade Steps To Avoid Post Upgrade Issues Related to Translation (Doc ID 2000905.1)

 It provides step-by-step guidance to review any potential issues and recommended patching for your R12 instance once the upgrade is complete. 

Don't miss this one! 

Thursday Apr 09, 2015

Webcast: Implement & Customize Transaction Account Derivation Rules (TADR) in AGIS

Webcast_icon.jpgImplement & Customize Transaction Account Derivation Rules (TADR) in AGIS

Date: April 22,, 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 intended for functional and technical users who would like to implement and customize intercompany Transaction Account Derivation Rules (TADR) in AGIS based on their business needs. Join us to learn required setups, the transaction process flow, basic troubleshooting and more!

Topics will include:

  • Transaction Account Derivation (TAD) Overview
  • Advantages of TAD
  • Required Setups
  • Transaction Process Flow
  • Basic Troubleshooting

Details & Registration via the My Oracle Support Community thread:  Advisor Webcast On 22-Apr-15: Implement & Customize Transaction Account Derivation Rules (TADR) in AGIS


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