Tuesday Mar 31, 2015

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! 

consolidation

 Review this document today for more details! 

Journal Posted Twice causing balance corruption (Doc ID 1922615.1

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!

Using WebAdi to Upload GL Journals? Excel 2013 is Now Certified with Webadi!

Web Applications Desktop Integration (WebAdi) is a powerful tool leveraging desktop applications to perform some of the Oracle EBS Tasks. Familiar desktop tools such as Excel can be used to create spreadsheets, enter or change existing data, then upload or propagate the changes to EBS.

For General Ledger, WebAdi can help through usage of specific integrators to:

  •  Upload Journals to Gl 
  •  Upload Budget Journals or change existing Budget balances directly 
  •  Upload Intercompany Journals

Did you just upgrade to Microsoft Office 2013? 

Good news! Excel 2013 is now certified with WebAdi! 

Either using previous versions of Microsoft Excel or the 2013 version, they are certified with WebAdi; you may now plan your desktop applications upgrades as needed and continue to Enjoy the Webadi Experience! 

Need more details?

Is Microsoft Office 2013 Certified With Webadi and E-Business Suite? (Doc ID 1907418.1)

Tuesday Sep 30, 2014

New GL Recommended Patch Collection Released by Development

Since E-Business Suite 12.1 was released, very important fixes were delivered by Development to improve your experience with General Ledger or introduce solutions for reported issues that might affect critical business processes.

Many patches are available. How to select those being relevant for your business? 

RPC's (Recommended Patch Collections) make this choice easy!

What are they? Collections of compact, reliable patches addressing issues that occur often and interfere with normal completion of crucial business processes

Why RPC's? They are tested, quality-assured compared to one-off patches and smaller in footprint compared to RUP's (Release Uptake Patches) 

When? As soon as possible! Maximize your experience with GL Release 12.1, minimize the patch adoption effort!

Find out more about this last RPC released by Development in

General Ledger Recommended Patch Collection (GL RPC) August 2014 (Doc ID 1919532.1)

Check the list of included fixes and Patch Now!

Friday Aug 22, 2014

Channel Revenue Management and General Ledger Integration

Back in February of this year, we told you about the EBS Business Process Advisor: CRM Channel Revenue Management document which has detailed information about the Channel Revenue Management application business flow and explains integration points with other applications.  But we thought that you might like to have even more information on exactly how Channel Revenue Management passes data to General Ledger.

Take a look at Integration Troubleshooting: Oracle Channel Revenue Management to GL via Subledger Accounting (Doc ID 1604094.2).  This note includes comprehensive information about the data flow between Channel Revenue Management and GL, offers troubleshooting tips and explains some key setups.

Let us know what you think - start a discussion in the My Oracle Support Channel Revenue Management Community!

Monday Jun 23, 2014

General Ledger - Accounting Setups Diagnostic Now Available!

Accounting Setup Manager is the central place where all accounting setup is defined and maintained. Collecting information related to your ledger and its configuration could be time-consuming while the ledger architecture is much more complex in Release 12 and multiple pages need to be accessed in order to gather a complete set of details. 

Collect all this setup information in one diagnostic run! Find information related to: 

  • Primary Ledger and its associated ledgers 
  • Legal Entities
  • Configuration details
  • Ledgers relationships
  • Balancing segments assignments
  • Intercompany and Intracompany rules
  • Relevant table data and files version
Sample Diagnostic Output

Tired of running too many scripts, browse through many setup pages and take screenshots to prove your ledger's configuration?

Get it all at once with a single Sql run!

New Diagnostic tool available in: R12: Accounting Setup Manager (ASM) Diagnostic (Doc ID 1643493.1)


Sunday Mar 30, 2014

New Feature! Balance Intercompany Journals Using Clearing Balancing Segment Value!

Intercompany transactions occur between two related legal entities or between groups in the same legal entity. In Release 12 of Oracle Applications these transactions are split into two different categories, INTERcompany and INTRAcompany.

Intracompany transactions can also be generated within a ledger where there is no legal entity context.

How Did This Work Before?

For 'no legal entity context', only Intracompany journals could be balanced using a clearing balancing segment value, based on Intracompany rules defined.

What's New?

  • R12.1+ Intracompany Rules user interface was enhanced, now allowing users to setup rules at ledger level (no legal entity context) even when the legal entities to balancing segment value associations are defined in the system
  • Balancing code was enhanced to use ledger level balancing rules instead of the Intercompany or Intracompany rules set up at legal entity level
  • Ability to derive different accounts based on the source and category , when ledger level balancing is used
  • Advanced Global Intercompany System(AGIS) functionality will not be affected by this new setup
  • Possible to toggle between old/new functionality through profile options

Fun balance profile option

Interested?  

Review How to Balance Intercompany Journals Using a Clearing Balancing Segment Value(BSV)? (Doc ID 1640618.1) for full details.

Friday Mar 28, 2014

Using Additional Currencies for Reporting Purposes in General Ledger

The need to report in additional currencies may occur at any time to satisfy legal, statutory or management supplementary reporting requirements. This is also a good option to be considered if you operate in countries with highly inflationary economies.

In General Ledger this can be accomplished using

  • Reporting Currencies - where the need is to simply maintain transactions in multiple currencies
  • Secondary Ledgers - where the main purpose is to represent transactions in a different accounting method, calendar, currency, chart of accounts

You may configure any of these setup alternatives to comply with your Generally Accepted Accounting Principles circumstances.

Add Secondary Ledger, Why The Primary Ledger is in Use?

qm1

But what if the business requirement comes after your Primary Ledger is already in use?

What would be the impact of such setup changes?

Would this change be permitted? 

The answer is Yes!

We Can accommodate such a change, find out How in

Impact of Newly Added Alternate Ledger Currency(ALC)/Secondary Ledger in Release12 (Doc ID 1479782.1)

This document provides a complete impact analysis for new installs or upgraded instances regarding

  • Business flows
  • Accounting and Reversals
  • Validations
  • Non-upgraded data options

We made it EASY to get meaningful balances in Any Currency, Anytime!


Wednesday Mar 26, 2014

Interested in E-Business Tax Integration with General Ledger?

Did you ever consider using Tax Journals feature in General Ledger but felt discouraged by the complex setup required, or simply did not know where to start?  We now have a simple solution for you!

A new Whitepaper was published recently on this topic: 

E-Business Tax Integration with General Ledger in Release 12 (Doc ID 1613279.1)!

This document aims to provide all required setup steps in E-Business Tax and General Ledger with the final purpose of creating Tax Journals in Oracle Applications.

Find step by step details with screenshots and examples regarding setup for:

  • Tax and Tax Regime
  • Tax Jurisdictions
  • Tax Rates and Rules
  • Transactions Processing in General Ledger
  • Useful Standard Reports
  • Table Level Details 

Sample of Tax Setup from the Whitepaper

E-Business Tax permits configuration of taxes according to local tax laws and international requirements. Integration of E-Business Tax with General Ledger allows uniformly using tax configurations for manual journals too.

Don't just READ about this setup, SEE it! 

Monday Mar 24, 2014

Get Help to Verify Your General Ledger Balances Anytime!

General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes. 

  • Maintaining correct balances is crucial for reporting purposes
  • Financial users may want to verify balances periodically to make sure they are accurate 

In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.

We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:

Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).

Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:

Glbalfix output sample

Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!

Why don't you give Glbalfix a try?


About

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

Twitter

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today