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

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! 

funds_review

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 
excel_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!

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!

Mexico Electronic Accounting - Need This Functionality in EBS?

On July 2014 was published The Second Resolution of Modifications to the Mexican Fiscal Code establishing, among other regulations, that taxpayers required to keep accounting books and records must use electronic systems and accounting programs that would be able to generate the files in XML format.

The mentioned provisions refer to: 

  • Chart of Accounts
  • Trial Balance
  • Accounting Policies

Need to meet these requirements regarding compliance and delivery of accounting information through electronic media? 

To understand better the implications of this legislative update and follow-up the formal Enhancement Request raised with Oracle, please visit these documents today!

E-Business Suite Release 12: Mexico Electronic Accounting, 2014 (Doc ID 1918417.1)

R12: Mexico Electronic Accounting : Does New Functionality Exist? (Doc ID 1921779.1)

Be the first one to know when the functionality becomes available! Bookmark this Enhancement Request now! 


Tuesday Jul 01, 2014

Posting Performance Issues Reported After 11.2.0.4 Database Upgrade

Posting is the main General Ledger process that updates the account balances for detail and summary accounts. As the program is submitted multiple times almost every day and the volume of data processed by this concurrent request is sometimes huge, getting a good performance for each run is crucial for having up-to-date balances available for reporting purposes at any moment. 

After upgrading RDBMS to 11.2.0.4, Posting performance issues were reported due to a new optimizer feature introduced for Database. Posting uses a bad execution plan and might get severe performance issues or simply hang at glpubr.concurrency procedure: 

Posting Logfile

Did you upgrade to RDBMS 11.2.0.4 recently? Do you plan to upgrade?

Ensure proper application usage for your users through a proactive patching plan!

This recently updated document provides all the needed details to help avoid a known issue: 

GLPPOS Poor Performance after DB Upgrade to 11.2.0.4.0: Program Stuck on Glpubr.Concurrency (Doc ID 1602141.1)

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!

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)


Monday Mar 31, 2014

Intercompany Program Passing Incorrect CREATED_BY Details to Interfaces

Audit Trails represent chronological recordings of event sequences and keep track of the users involved in specific processes, giving a clear view of all historical details for financial transactions. Details related to id's of the users creating or changing an accounting record are extremely relevant for auditing purposes.

What was reported?

A couple of bugs were discovered with Advanced Global Intercompany System (AGIS) transfers with incorrect CREATED_BY id's for certain processes.

What Processes Were Affected?

The following relevant programs that record user id's were reported to pass incorrect details to other programs and interfaces:

  • Intercompany Import Program (FUNXIMPB)
  • Manual Intercompany Transactions Sweep (FUNPRDSTSB)

Created_by_data sample

How to Address This Issue?

A patching solution is now available for both affected processes!

Keep a Clean Audit Trail linking to correct user id's, Patch Today!

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!


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
« March 2015
SunMonTueWedThuFriSat
1
2
4
6
7
8
10
12
13
14
15
16
17
18
20
21
22
23
24
25
27
28
29
30
31
    
       
Today