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 publically available on Github

 David Kurtz 2019