EPY: BUD003 Performance (Doc ID 1275891.1)

Last updated on AUGUST 01, 2014

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.

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

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