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 Sep 05, 2014

Invoice Validation Parallel Processing New Functionality Available

What has changed?

The Invoice Validation concurrent program is now equipped to spawn multiple child requests based on the Purchase Order matched invoice load and the newly seeded profile "AP:Maximum Invoice Validation Child Requests".

The user continues to submit a single Invoice validation program with his/her preferred parameters but internally the program groups the invoices matched to same Purchase Orders and ensures that each such group is processed by a single child request.

Whereas for invoices that are not matched to any Purchase Orders, the system distributes these invoices equally amongst the maximum number of child requests spawned (as per the value set by the user in the aforementioned profile).

Why the change?

1) The current invoice validation concurrent program was not scaling up for high volume of invoices.

2) If multiple requests of the invoice validation concurrent program are submitted and invoices matched to the same Purchase Orders are processed by two or more requests then there are possibilities of lock contention errors on PO_HEADERS_ALL in any of the requests that concurrently attempts to update the PO object.

3) To avoid conflicts, user had to wisely select the parameters at the time of submitting the concurrent program or have conflict domains defined that constrained the program to execute serially.

4) Submitting multiple requests of the program causes an overhead of reviewing multiple log files and outputs.

More Information

R12: New Functionality Invoice Validation Parallel Processing (Doc ID 1917614.1)

If you have any questions on this new functionality please use the community thread

Thursday Sep 04, 2014

Projects Create Accounting Performance Issues With Database Version

The PRC: Create Accounting program is run for various process categories within Oracle Projects.  This program is run to create accounting entries in Oracle Subledger Accounting for accounting events created by the generate accounting events processes.

After upgrading the RDBMS version to, PRC: Create Accounting performance issues were reported due to incorrect partition statistics at the index level for the following tables:


Have you recently upgraded your database to version  Do you plan to upgrade to in the future?

The document below provides all of the needed details to help avoid this known issue:

Performance issues on SLA tables for Database (Doc ID:1465689.1)

Tuesday Jul 01, 2014

Posting Performance Issues Reported After 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, 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 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 Program Stuck on Glpubr.Concurrency (Doc ID 1602141.1)

Friday Dec 06, 2013

Diagnostic: HCM Technical Analyzer Now Available!

The HCM Proactive Support Delivery Team is introducing the HCM Technical Analyzer, a Health-Check script which reviews your overall HCM footprint by analyzing your current configurations and settings for your HCM environment.  The HCM Technical Analyzer is a non-invasive script which is designed to provide proactive feedback and recommendations associated with the HCM instance on which the analyzer is executed.

This Analyzer / Health Check / Data Collection tool is a PL*Sql script which will check the E-Business Suite environment and can be executed on all currently released / supported application versions  (i.e., 12.0, 12.1, and 12.2).   As the process executes, it will output diagnostics advice and proactive recommendations within an .html output file.

When reviewing the analyzer output, you can immediately see where issues are identified as they are displayed in red (errors), orange (warnings) or blue (best practices), so that they can be easily seen.  In addition to identifying areas of concern, the analyzer will also identify My Oracle Support (MOS) articles which can be utilized to resolve the issue.

The Analyzer can be executed using one of two 'Run Type' parameters: 

  • Run Type = ISSUES, which will execute the Analyzer / Health Check with the output geared to customer problem resolution. This option will display only those sections where an issue or potential issue is identified so that you the customer can proactively address them.
  • Run Type = ALL, which will execute the Analyzer as a Data Collection tool which can be used to assist an Oracle Support Engineer in resolving an issue.

 The Analyzer is designed specifically to be used with the Human Capital Management (HCM) products, which is driven by the following input parameter values:

  • BEN - Benefits
  • HR - Human Resources
  • IRC - iRecuitment
  • OTL - Oracle Time and Labor
  • PAY - Payroll
  • SSHR - Self Service Human Resources
  • ALL - All HCM products above.

When the Analyzer is executed an environment review is performed and feedback provided on: 

  • Performance related setups and checks
  • Invalid objects, disabled triggers, and database issues
  • Profile settings
  • Packages and java classes version
  • Patching status.

It is recommended that this script be setup as a concurrent request from the E-Business Suite interface so that it maybe executed by either Functional or Technical representatives from your business.

  • How to run the HCM Technical Analyzer as a Concurrent Request (Doc ID 1575663.1)

Download the HCM Technical Analyzer Script (Doc ID 1562530.1) Today, and Provide us your Feedback!

Thursday Nov 21, 2013

Optimizing Calculation Performance in Oracle Incentive Compensation

If you use Oracle Incentive Compensation (OIC), then new Doc ID 1600221.1- Guidelines to Optimize Calculation Performance via Oracle Incentive Compensation Settings is recommended reading.

In an effort to parallelize calculation, a single calculation concurrent request can spawn thousands of calculation subprocesses. By understanding how OIC spawns calculation, implementers can better understand how to optimize the 3 core OIC settings that drive performance in the calculation process. There are non-OIC factors, like DB tuning that drive OIC Calculation performance, but these are not the focus of the document which is focused on an understanding of the 3 core OIC settings:
  • Transaction Batch Size
  • Salesrep Batch Size
  • Number of Concurrent Managers Workers
Read more in Doc ID 1600221.1 which contains explanations of these settings and guidelines on how to set them.

Wednesday Nov 20, 2013

Transportation Management Analysis and Performance Monitoring

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

Benefits include the following:
  • Immediate Analysis of OTM Environment
    • Identifies Entity Data Volume
    • Identifies Database Parameter and recommendations
    • Identifies OTM processes volumes.
  • Easy to add Tool for regular Maintenance.
  • Execute Analysis anytime to compare trending from past outputs.
Please refer to the following document for additional information: ASCP Performance Analyzer script for Performance Monitoring (11.5.X and R12) (Doc ID 1579683.1).

Friday Nov 15, 2013

VCP: ASCP Performance Analyzer Script

The ASCP Performance Analyzer is a Self-Service Health-Check script which reviews the overall 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. 

Benefits Include the following:
  • Immediate Analysis and Output of ASCP Environment
  • Identifies Entity Data Volume
  • Identifies Database Parameter and recommendations
  • Identifies Planning process programs run time trend
  • Easy to add Tool for regular Maintenance
  • Execute Analysis anytime to compare trending from past outputs
Please refer to the following document for additional information: ASCP Performance Analyzer script for Performance Monitoring (11.5.X and R12) (Doc ID 1554183.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