Balance Feed's: Performance Issue Encountered When Pay_Balance_Feeds Triggers for Update, Delete or Insert are Fired (Doc ID 1388475.1)

Last updated on JULY 18, 2022

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

This note provides a brief overview of

Problem Statement:

When the pay_balance_feeds triggers which are for update, delete or insert are fired a performance issue is encountered.

Then the following query in pay_balance_pkg.invalidate_run_balances is executed when these triggers are called and takes several hours.

Application of:

This issue occurs on the following version:

Release	File (including directory)	Version
11.5.10.2 +	$PAY_TOP/patch/115/sql/pybaluex.pkb	115.140
12.0.6 +	$PAY_TOP/patch/115/sql/pybaluex.pkb	120.28.12000000.14
12.1.3 +	$PAY_TOP/patch/115/sql/pybaluex.pkb	120.38.12010000.7

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.