PeopleSoft FISCM System Configuration Insight (PSFTFISCMSYSCI)

To exclude tables in script-based extraction:

  1. Edit the ExtractPSFTFISCI.sql file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTFISCI.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 PSACCESSPRFL 
SET TERMOUT OFF 
SPOOL &1\PSACCESSPRFL.txt 
/*SELECT NULL||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'||SYMBOLICID||'$$$$!@**'
||VERSION||'$$$$!@**'||ACCESSID||'$$$$!@**'||ACCESSPSWD||'$$$$!@**'||ENCRYPTED
||'$$$$!@**###'
FROM PSACCESSPRFL;*/ 
SPOOL OFF