PeopleSoft HRMS Procure to Pay Process Configuration Insight (PSFTHRMSP2PCI)

To exclude tables in script-based extraction:

  1. Edit the ExtractPSFTHRSCI_DB2.cmd file
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTHRSCI_DB2.cmd file. Rewrite the query as shown bellow. Please refer the example given below.

    For example: 

    db2 export to "%2\ PS_APPR_RULE_AMT.txt "of modified by nochardel "SELECT '' FROM
SYSIBM.SYSDUMMY1" 
REM db2 export to "%2\PS_APPR_RULE_AMT.txt "of DEL modified by nochardel "SELECT
''||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||TRIM(CHAR(APPR_RULE_SET))||'$$$$!@**'||
(CASE WHEN EFFDT < '1900-01-01 00:00:00' THEN '1900-01-01 00:00:00' ELSE (coalesce 
(VARCHAR_FORMAT(TIMESTAMP_ISO(EFFDT ),'YYYY-MM-DD HH24:MI:SS'),'1900-01-01 
00:00:00'))END)||'$$$$!@**'||TRIM(CHAR(APPR_STEP))||'$$$$!@**'||TRIM(CHAR
(APPR_PATH))||'$$$$!@**'||TRIM(CHAR(APPR_RULE_SEQ))||'$$$$!@**'||TRIM(CHAR 
(FIELD_PNLFIELD))||'$$$$!@**'||TRIM(CHAR(MAX_DEBIT_AMT))||'$$$$!@**'||TRIM(CHAR
(MAX_CREDIT_AMT))||'$$$$!@**'||TRIM(CHAR(RECNAME))||'$$$$!@**'||TRIM(CHAR
(CURRENCY_CD))||'$$$$!@**###' FROM PS_APPR_RULE_AMT"