My Oracle Support Banner

EPY: BUD003 Performance (Doc ID 1275891.1)

Last updated on OCTOBER 10, 2018

Applies to:

PeopleSoft Enterprise HRMS Payroll for North America - Version: 9.1 and later   [Release: 9 and later ]
Information in this document applies to any platform.


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?


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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