gfcbuild.zipThe 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. 

latest updates:
22.6.2005 - cloned from GPBUILD.sql
25.7.2006 - applied GPBUILD corrections, and remove chartfield fudge
5.12.2006 - added handling for hash-partitioned only tables
13.12.2006 - remove partitioning column check
6. 9.2007 - enhancement for PeopleTools 8.48, and support for partitioned function based indexes
8.11.2007 - support for range-list composite partitioning
14.2.2008 - selective list partition -v- range build, drop purge, all keys on subrecords

 David Kurtz 2015