PeopleSoft FISCM Procure to Pay Process Configuration Insight (PSFTFIP2PPCI)

To exclude tables in script-based extraction:

  1. Edit the ExtractPSFTFIP2PCI.sql file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTFIP2PCI.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.

    For example:

    SET TERMOUT ON
PROMPT Extracting PSAUDIT
SET TERMOUT OFF
SPOOL &1\PSAUDIT.txt 
/*SELECT NULL||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||AUDIT_OPRID||'$$$$!@**'
||(CASE WHEN TO_CHAR(AUDIT_STAMP, 'YYYY-MM-DD HH24:MI:SS') < '1900-01-01
00:00:00' THEN  '1900-01-01 00:00:00' ELSE TO_CHAR(AUDIT_STAMP, 'YYYY-MM-DD
HH24:MI:SS') END)||'$$$$!@**'||AUDIT_ACTN||'$$$$!@**'||RECNAME||'$$$$!@**'
||FIELDNAME||'$$$$!@**'||OLDVALUE||'$$$$!@**'||NEWVALUE||'$$$$!@**'||KEY1||
'$$$$!@**'||KEY2||'$$$$!@**'||KEY3||'$$$$!@**'||KEY4||'$$$$!@**'||KEY5||
'$$$$!@**'||KEY6||'$$$$!@**'||KEY7||'$$$$!@**'||KEY8||'$$$$!@**'||KEY9||
'$$$$!@**'||KEY10||'$$$$!@**'||KEY11||'$$$$!@**'||KEY12||'$$$$!@**'||KEY13||
'$$$$!@**'||KEY14||'$$$$!@**'||KEY15||'$$$$!@**###'
FROM PSAUDIT;*/ 
SPOOL OFF