PeopleSoft HRMS Procure to Pay Process Configuration Insight (PSFTHRMSP2PCI)

To extract the files in script-based extraction:

  1. Edit the ExtractPSFTHRP2PCI.sql file
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTHRP2PCI.sql file. To comment the query place /* before the SELECT statement and place */ as the end of the select statement please refer the example given below. 
    SET TERMOUT ON
PROMPT Extracting PSRECDEFN
SET TERMOUT OFF
SPOOL &1\PSRECDEFN.txt 
/*SELECT 
NULL||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||ZPSRECDEFN.RECNAME||'$$$$!@**'||
ZPSRECDEFN.FIELDCOUNT||'$$$$!@**'||ZPSRECDEFN.INDEXCOUNT||'$$$$!@**'||
ZPSRECDEFN.DDLCOUNT||'$$$$!@**'||ZPSRECDEFN.VERSION||'$$$$!@**'||ZPSRECDEFN.AUDITRECNAME
||'$$$$!@**'||ZPSRECDEFN.RECUSE||'$$$$!@**'||ZPSRECDEFN.RECTYPE||'$$$$!@**'
||ZPSRECDEFN.SETCNTRLFLD||'$$$$!@**'||ZPSRECDEFN.RELLANGRECNAME||'$$$$!@**'
||ZPSRECDEFN.OPTDELRECNAME||'$$$$!@**'||(CASE WHEN (SELECT COUNT(1) FROM 
PSRECDEFNLANG WHERE PSRECDEFNLANG.LANGUAGE_CD = '&2' ) >= 0 THEN
COALESCE(ZPSRECDEFNLANG.RECDESCR,ZPSRECDEFN.RECDESCR) WHEN '&3' = '&2' THEN ZPSRECDEFN.RECDESCR
END )||'$$$$!@**'||ZPSRECDEFN.PARENTRECNAME||'$$$$!@**'||ZPSRECDEFN.QRYSECRECNAME
||'$$$@**'||ZPSRECDEFN.SQLTABLENAME||'$$$$!@**'||ZPSRECDEFN.BUILDSEQNO||'$$$$!@**'
||ZPSRECDEFN.OPTTRIGFLAG||'$$$$!@**'||ZPSRECDEFN.OBJECTOWNERID||'$$$$!@**'||
(CASE WHEN TO_CHAR(ZPSRECDEFN.LASTUPDDTTM, 'YYYY-MM-DD HH24:MI:SS') <
$!'1900-01-01 00:00:00' THEN '1900-01-01 00:00:00' ELSE
TO_CHAR(ZPSRECDEFN.		LASTUPDDTTM, 'YYYY-MM-DD HH24:MI:SS') END)||'$$$$!@**'
||ZPSRECDEFN.LASTUPDOPRID||'$$$$!@**'||ZPSRECDEFN.SYSTEMIDFIELDNAME||'$$$$!@**'||
ZPSRECDEFN.TIMESTAMPFIELDNAME||'$$$$!@**'||ZPSRECDEFN.AUXFLAGMASK||'$$$$!
@**###' FROM PSLANGUAGES ZPSLANGUAGES, PSRECDEFN ZPSRECDEFN LEFT
OUTER JOIN PSRECDEFNLANG ZPSRECDEFNLANG ON ZPSRECDEFNLANG.RECNAME =
ZPSRECDEFN.RECNAME AND ZPSRECDEFNLANG.LANGUAGE_CD = '&2' WHERE
ZPSLANGUAGES.LANGUAGE_CD = '&2' AND ZPSLANGUAGES.INSTALLED = 1;*/ 
SPOOL OFF