My Oracle Support Banner

EPY: BUD003 Performance (Doc ID 1275891.1)

Last updated on APRIL 15, 2024

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.1 and later
Generic (Platform Independent)

Goal


1. It took 15hrs to run BUD003 for 870,000 records. Is this normal?
2. Is BUD003.sqr designed to be run daily?
3. Now that the initial load has run, the next time it is run, is it designed to only update the VALID_COMBO_TBL with changes and not delete and re-insert the over 870,000 rows again?





Solution

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
Goal
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.