Performance Issue While Using the API PER_BF_BALANCE_TYPES_API.DELETE_BALANCE_TYPE (Doc ID 2218894.1)

Last updated on JANUARY 06, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Balances and Balance Uploads

ACTUAL BEHAVIOR
----------------------
Encountering Performance issue When attempting to delete backfeed balance type information using PER_BF_BALANCE_TYPES_API.delete_balance_type.
It takes around 4-5 minutes for one record

EXPECTED BEHAVIOR
-----------------------
API PER_BF_BALANCE_TYPES_API.DELETE_BALANCE_TYPE should not take much time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Delete backfeed balance type information using API PER_BF_BALANCE_TYPES_API.DELETE_BALANCE_TYPE

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms