|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