My Oracle Support Banner

PAR Processing USF Components Performance Issue When PS_TAX_LOCATION2 Loaded with 45k Rows (Doc ID 3000283.1)

Last updated on JANUARY 31, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Geographic locations, locations and tax location tables updated to correspond with OPM duty locations in PS_TAX_LOCATION2 table , facing significant performance issues with the HR PAR Processing USF components

Steps to reproduce the issue:
1. Update Geographic locations, locations and tax location in table : PS_TAX_LOCATION2 around 45k rows
2. Access HR PAR Processing USF components : 1st Request Authorization USF , Approve Request USF , HR Processing USF , Correct Personnel Action USF
    Navigation : Workforce Administration > Job Information

Changes

 

Cause

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
Changes
Cause
Solution
References


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