I have worked with PeopleSoft's Global Payroll product since its very first beta release in 2000 . Over the last few years we have provided specialist performance and configuration consultancy on Global Payroll systems in UK, France, Switzerland, Japan and USA. Experiences at a variety customer sites has enabled me to progressively develop the techniques that have been employed, and these have been fed back to all our customers.

Github: davidkurtz/gfcbuild The presentation Configuring Global Payroll for Optimal Performance recommends physically partitioning Global Payroll result tables to match the logical streaming, and converting working storage tables to Oracle Global Temporary tables. Application Designer cannot generate the DDL for partitioned tables.

The gfcbuild utility is a generic PL/SQL package that will build record defined in PeopleSoft as partitioned tables.  This concept is explained in more detail in the document Configuring and Operating Streamed Processing in PeopleSoft Global Payroll, including a step-by-step guide on implementation.

The script is now freely and publicly available on Github

© David Kurtz 2020