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

Tuesday Mar 31, 2015

Where to Find Product Documentation for General Ledger?

We know that having reliable Documentation available is crucial for anyone interested to use Oracle Applications; business users, developers, consultants, system administrators, in short - everyone using it needs to know how it works, understand the expected functionalities and design, keep track of changes. 

We heard you asking for direct links to Online Documentation, as browsing through My Oracle Support portal  may be inconvenient at times for a business user. 

We responded to this request - Product Documentation for General Ledger and Electronic Technical Reference Manual are both available online, there is no need for an account, password or browsing multiple pages.

Online Documentation

It is so simple!

Find out more today! Documentation - General Ledger Manuals and eTRM (Doc ID 66935.1)

Balances Corruption Fix Script (GLBALFIX) Now Available for Parameters Including Special Characters

General Ledger Balances Corruption Fix script -known as GLBALFIX- was provided by Development to help safely detect or fix corrupted actual balances. This script basically rebuilds the balances based on the posted journal lines.

We have briefly presented the script to customers in a previous blog article which is still available here

This easy-to-use script could not be used for cases where the input parameters such as ledgers or calendar periods included special characters (arabic, german, polish and so on).

New version available!

Development recently released a new version of GLBALFIX script which will addres special characters cases

Did you have this concern before?

Just check: GLBALFIX errors when Input Parameters Contain Special Characters (Doc ID 1958420.1)

Do you suspect balances corruption? Do not hesitate, get help today!

General Ledger Recommended Patch Collection Released Recently!

Recommended Patch Collections (RPC's) are released by Development periodically with the main purpose of providing a compact, reliable collection of relevant product patches that would address the main and most oftenly reported issues.

With a relatively small footprint, RPC's deliver solutions to address critical issues that could otherwise affect important business processes and flows.

Which Patches?

Patch 20251722:R12.GL.B: R12.1 General Ledger Recommended Patch Collection, February 2015

Patch 20255342:R12.RG.B: R12.1 General Ledger Recommended Patch Collection(FSG), February 2015 

What do they bring?

Solutions for multiple functional areas, addressing Bugs related to: 

  • Standard reports
  • Consolidation
  • Revaluation 
  • Financial Statement Generator Reports (FSG)
  • Drilldown
  • Gl Setup and Performance

I want more! 

Thank you, please review this document providing all the additional details you may need: 

General Ledger Recommended Patch Collection (GL RPC) Feburary 2015 (Doc ID 1982728.1

Be Proactive! Don't wait to have a problem, Prevent it from occurring!  

Monday Jan 05, 2015

Did Your Consolidation Journals Post Twice Recently?

General Ledger Consolidation feature allows reporting users to combine the financial results of multiple companies, disregarding the fact that the ledgers might have different chart of accounts, calendars or currencies. 

For some specific cases, where Consolidation was used along with Autopost feature, double posting occurred for the consolidation journal resulting in balances corruption. We have identified this issue and found a solution! 


 Review this document today for more details! 

Journal Posted Twice causing balance corruption (Doc ID 1922615.1

Budgeting For The New Year? Allow Us To Help!

Budgeting is used to represent specific estimated costs and revenues for the selected period ranges. Budgetary control helps track budgeted amounts against the control budget, monitor the available funds, get a good view over future funds reservations and funds consumption. 

General Ledger(GL) provides many tools to create, maintain and track budgeted amounts; this functionality is integrated with WebAdi product, allowing the users to upload budget data from the spreadsheet files directly to GL. It's that Easy! 


Do you think the setup required to achieve budgetary control is complicated? 

Review this document today, it provides everything you need for a good start:

Budgets and Budgetary Control - Setup and Usage (Doc ID 1928941.1

Let us help!

Wednesday Dec 31, 2014

Did You Check The Latest Rollup Patch for Report Manager?

Oracle Applications provide a large variety of reporting capabilities, Report Manager being one of the most powerful tools available, as it makes use of Financial Statement Generator (FSG) reports presented in a professional manner, allowing at the same time many custom options for the template and output.

No programming needed to define your own custom reports!

However in order to get the best out of this reporting tool, you should always consider upgrading the code periodically in order to include the latest implemented features and bug fixes.

Do you know what is the latest Rollup Patch for Report Manager? 

Find out now!

R12 - What Is the Latest Rollup Patch for Report Manager? (Doc ID 1952615.1

Tuesday Dec 30, 2014

Financial Reporting Using Excel? Get Some Hints!

Report Manager, as part of Oracle Applications E-Business Suite is a powerful tool allowing users to publish, store and customize reports results in order to meet complex business reporting requirements. Being integrated to work with Excel and General Ledger - Financial Statement Generator (FSG), it allows users to get a personalized look for their reports. 

Using Excel for reviewing and analyzing financial reports brings great advantages, such as:

  • making use of many Excel formatting options - bold heading, colors, pictures, logos
  • performing calculations directly on the report's output
  • presenting the report in a well-organized manner, using Excel worksheets
  • creating graphical representations of the results presented in the report output 

Are your users familiar with Excel? Do you need to pick between Report Manager and BI Publisher? 

Best Practices for Excel-based Financial Reporting with E-Business Suite Release 12 (Doc ID 1936523.1

Check this first!

Advanced Global Intercompany System Setup Diagnostic Available!

E-Business Suite Diagnostics are free tools intended to help troubleshoot problems reported by the users or proactively detect setup issues, maintaining a healthy environment. As a result, they provide an easy-to-read document revealing existing setup definition and, where possible, setup changes suggestions or problems spotted during the diagnostic run.

Most probably you are already using our existing diagnostics presented in this Catalogue?

Oracle General Ledger (GL) Diagnostics Catalog and Scripts Collection (Doc ID 1416402.1

Diagnostics for GL

Did you notice we do not have an Advanced Global Intercompany System (AGIS) Diagnostic available? 

We knew it!

An AGIS diagnostic was prepared on your request - share it with your users now!  

Agis diagnostics sample

Oracle Financials Common Modules (FUN): Advanced Global Intercompany System(AGIS) Setup Diagnostic (Doc ID 1939150.1

Just Check it Now! 

Wednesday Oct 01, 2014

Interested in Financial Control - New Features on 12.2.4 Release?

The Release Content Documents provide detailed information about new or changed functionalities available with the mentioned Applications release. For 12.2.4 such documentation is already available.

New or changed functionalities include: 

  • Sharing Allocation Formulas across Ledger Currencies
  • Control Accounts usage restriction for WebAdi
  • Intercompany Ledger level balancing 
  • Brazil: SISCOSERV
  • Oracle Menu displayed differently for Report Manager -WebAdi spreadsheets 

Do you have an Upgrade Plan already?

We have presented the information separately for each product, to make it easier for you:  

Oracle General Ledger Release Notes for Release 12.2.4 (Doc ID 1911147.1)

Oracle Advanced Global Intercompany System Release Notes for Release 12.2.4 (Doc ID 1913688.1)

Oracle Public Sector Financials (International) Release Notes for Release 12.2.4 (Doc ID 1915011.1)

Oracle Public Sector Financials Release Notes for Release 12.2.4 (Doc ID 1915356.1)

Oracle Financials for the Americas Release Notes for Release 12.2.4 (Doc ID 1914069.1)

Oracle Report Manager Release Notes for Release 12.2.4 (Doc ID 1911898.1)

Oracle Web Applications Desktop Integrator Release Notes for Release 12.2.4 (Doc ID 1911899.1)

Be curious! Find out more about Release 12.2.4!


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



« December 2015