PeopleSoft FISCM Procure to Pay Process Configuration Insight (PSFTFIP2PPCI)

To exclude the tables in script-based extraction:

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

    Example:

    
db2 export to "%2\ PSAUDIT.txt "of modified by nochardel 
"SELECT '' FROM SYSIBM.SYSDUMMY1"
REM db2 export to "%2\PSAUDIT.txt "of DEL modified by nochardel
"SELECT ''||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||TRIM(CHAR(AUDIT_OPRID))
||'$$$$!@**'||@**'|| (CASE WHEN AUDIT_STAMP < '1900-01-01 00:00:00' THEN '1900-01-01
00:00:00' ELSE (coalesce(VARCHAR_FORMAT(TIMESTAMP_ISO(AUDIT_STAMP ),'YYYY-MM-DD
HH24:MI:SS'),'1900-01-01 00:00:00'))END)||'$$$$!@**'||TRIM(CHAR(AUDIT_ACTN))||
'$$$$!@**'||TRIM (CHAR(RECNAME))||'$$$$!@**'||TRIM(CHAR(FIELDNAME))||'$$$$!@**'
||TRIM(CHAR (OLDVALUE))||'$$$$!@**'||TRIM(CHAR(NEWVALUE))||'$$$$!@**'||TRIM(CHAR(KEY1))
||'$$$$! TRIM(CHAR(KEY2))||'$$$$!@**'||TRIM(CHAR(KEY3))||'$$$$!@**'||TRIM(CHAR(KEY4))
||'$$$$! @**'||TRIM(CHAR(KEY5))||'$$$$!@**'||TRIM(CHAR(KEY6))||'$$$$!@**'||TRIM(CHAR(KEY7))
||'$$ $$!@**'||TRIM(CHAR(KEY8))||'$$$$!@**'||TRIM(CHAR(KEY9))||'$$$$!@**'||TRIM(CHAR
(KEY10))||'$$$$!@**'||TRIM(CHAR(KEY11))||'$$$$!@**'||TRIM(CHAR(KEY12))||'$$$$!@**'
||TRIM (CHAR(KEY13))||'$$$$!@**'||TRIM(CHAR(KEY14))||'$$$$!@**'||TRIM(CHAR(KEY15))||'$$$$!
@**###' FROM PSAUDIT"