Tuesday Sep 08, 2015

Managing Growth of Oracle Payroll Transactional Tables

Payroll database administrators are aware that over time that the Oracle Payroll processes can store potentially large amounts of information to the database.   They also know, that this can have an adverse effect, from supplying larger amounts of database storage to potential performance issues due to queries executing across high volume tables.

To ease this overhead, Oracle Payroll delivers multiple features that can reduce the amount of payroll data held on the database.  These features have been documented and are delivered in the whitepaper

Best Practices to Reduce Existing Volume and Limit Future Growth of Transactional Tables (Doc. ID 2031293.1)

This document lists the various features with online references that detail the process and how to enable / implement the feature if it is available for localization. These features include:

  • Sparse matrix / Insignificant Run Results
  • Payroll Purge
  • Single Latest Balances Upgrade
  • Database Compression
  • Event Model
  • Run Balances

It is HIGHLY recommended that you discuss these options with your database administrator or payroll manager

Monday Jul 20, 2015

How to run the new XML version of the APList Invoice Data Collection Diagnostic

There is now an XML version of the Payables APList, which is an alternative to the Invoice Data Diagnostic in the diagnostic pack. 

Why it is needed?

The Diagnostic version (HTML based) is limited on size and cannot bring back all the data needed to resolve issues.  By using the XML version the size limitation is removed.

The XML version offers some significant advantages over the HTML version in the diagnostics:

  • The XML contains more data available to Oracle Support: versions, more setup tables, profile options, etc.
  • Support can apply various XSL templates to the XML to make it easy to read and specific to the issue at hand
  • Removes size constraints and all the data can be retrieved without making the HTML impossible to open
  • Can be run as a concurrent request rather than having to use the diagnostic responsibility
  • Can be run via SQL*Plus or any other SQL Utility
  • Can be run for multiple invoices at a time
  • Support tools can use XML to automatically diagnose certain issues

While the XML version can take a couple more minutes to run it reduces the need for other diagnostics.

When to use it?

This version can be used when requested by Support, or anytime an invoice data diagnostic is requested.

How to run it?

The script can be ran several ways depending on your preference:

  • Run directly from SQL*Plus (or a comparable tool)
  • Run via the concurrent manager SRS window
  • Run via an option on the Tools menu in the Invoice Workbench

How can I find out more?

Please review Doc ID 1677861.1 - How to use the XML version of the Payables APList [VIDEO] which contains videos teaching how to use all the methods to help you fully understand how to use this new tool.

What if I still have questions?

Post your question on the AP community thread and we will be happy to answer them.

Tuesday Jul 08, 2014

Your Payables #1 Document Keeps Getting Better!!

The Master GDF Diagnostic (MGD) has held the title of #1 Payables document for a while now and it just keeps getting better!

What's Changed?

A new version of the Payables Master GDF Diagnostic (MGD) is now available for download which includes improvements to the Impact Areas listed for each corruption signature that is detected.  This improvement makes it possible for the summary of corruption signatures detected to be categorized more effectively into functional areas that are affected by data corruption - making it easier for you to know where to start with your patching solutions.

If you haven't used the MGD lately we urge you to give it a try and proactively scan your Payables data for issues that have known supported data fixes and root cause patches available.  The latest version of the MGD is 120.233 and was released on 07/07/2014.

How Do You Get It? 

Review full details of the MGD by reviewing Doc ID 1360390.1 - R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax [VIDEO].

Why Should You Download This?

If you aren't using the latest and greatest MGD package you will miss potential corruption that will cause you pain at some point in the future.  By using the latest version you are sure to screen for all data corruption that could affect your system.

In addition, this version is the best to use because it makes our new Automated SR functionality much better.  We recently added a new SR Problem Type to automatically screen for data corruption if you are having issues with Create Accounting for a Specific Invoice, Check or Vendor.  Having this latest MGD in place will make this process work much faster and you'll be able to find solutions much faster than when using the standard Create Accounting SR Problem Type.  This automation process only works if you upload the MGD for us to review so download it today.

Further Information 

For full details of how to use SR Automation refer to the earlier blog entry and post any questions on our community thread for the same.  


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