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

Friday Oct 17, 2014

How To Purge Quotes

New functionality has been released to allow purging of Quotes in R12.1.3.  The ability to purge Quotes is included as standard functionality in release 12.2.4 and this functionality has now been backported to 12.1.3 via Patch 19388406:R12.ASO.B.  (The functionality is not available in R11i).

For details of the R12 Purge Quote functionality refer to the following documentation:

Wednesday Apr 02, 2014

Workflow Analyzer v5.06 Released & Workflow Search Assistant

Workflow Analyzer v5.06 has been released! 

Please download it for use from Doc ID 1369938.1 and continue providing feedback on it as this tool has become a top Workflow resource:

  • Immediate Analysis and Output of Workflow Environment
    • Identifies Aged Records
    • Identifies Workflow Errors & Volumes
    • Identifies looping Workflow items and stuck activities
    • Identifies Workflow System Setup and configurations
    • Identifies and recommends Workflow Best Practices
  • Easy to add Tool for regular Workflow Maintenance
  • Execute Analysis anytime to compare trending from past outputs

Workflow Search Assistant

The Workflow Search Assistant provides access to Workflow Documentation, Top Troubleshooting & How To documents commonly used for solving problems with service requests.  Please review Doc ID 1600307.2 as another resource for your workflow needs.

Additional Resources:

Workflow Product Information Center Doc ID 1320509.1
Please visit the Core Workflow Community for Workflow Discussions and Best Practices!

Tuesday Dec 31, 2013

Concurrent Processing Tips & Tricks & CP Analyzer Update

Concurrent Processing Tips & Tricks & CP Analyzer Update

Did you know?

Tuning concurrent processing largely depends on customers' specific business needs. While Support is unable to provide specific recommendations that address all circumstances, we can certainly provide the guidance which helps you make decisions.

Be sure to check out the following documents to understand the considerations for healthy Concurrent Processing:

  • Doc ID 1057802.1 Best Practices for Performance for Concurrent Managers in E-Business Suite
  • Doc ID 986272.1 How To Performance Tune The Concurrent Processing Server


We suggest you run the FNDCPPUR "Purge Concurrent Request and/or Manager Data" request on ALL instances during hours of low workloads. Doing this regularly and after hours will decrease the contention on the tables running against daily processing. For more information on basic usage for running the Purge program and code fixes, please reference: Doc ID 822368.1 Concurrent Processing - How To Run the Purge Concurrent Request FNDCPPUR, Which Tables Are Purged, And Known Issues Like Files Are Not Deleted From File System or Slow Performance.

Tip: Discuss with the functional teams for determining the best retention policy.

Ensure that the log/out files are removed from the below directory as you run "Purge Concurrent Request and/or Manager Data program":


See Doc ID 844976.1 for more details.

Need a Holistic view of your Concurrent Processing? Choose CP Analyzer v1.03

Concurrent Processor Analyzer sample output

Go to Doc ID 1411723.1 for more details and script download.

The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices.

This is a non-invasive script which provides recommended actions to be performed on the instance it was run on. For production instances, always apply any changes to a recent clone to ensure an expected outcome.

For top Concurrent Processing content, visit:

  • 11i / R12: Concurrent Processing - Product Information Center (PIC) Doc ID 1304305.1

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