PeopleSoft FISCM Procure to Pay Process Configuration Insight (PSFTFIP2PPCI)

To exclude tables in script-based extraction:

  1. Edit the ExtractPSFTFISCMP2PCI_SQLBackend_Support.bat file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTFISCMP2PCI_SQLBackend_Support.bat file. Just rewrite the query as shown in the example. Example given below.

    Example: 

    
ECHO Extracting PSRECDEFN --Started
BCP "SELECT '' " queryout "%2\PSRECDEFN.txt" -t $$$$!@** -r -w -S "%1" -U "%5"
-P "%6" REM BCP "SELECT NULL,'@B$R@C!I#D#',LTRIM(RTRIM(ZPSRECDEFN.RECNAME)),
ZPSRECDEFN.FIELDCOUNT,ZPSRECDEFN.INDEXCOUNT,ZPSRECDEFN.DDLCOUNT,ZPSRECDEFN.VERSION,
LTRIM(RTRIM(ZPSRECDEFN.AUDITRECNAME)),ZPSRECDEFN.RECUSE, ZPSRECDEFN.RECTYPE,
LTRIM(RTRIM(ZPSRECDEFN.SETCNTRLFLD)),LTRIM(RTRIM(ZPSRECDEFN.RELLANGRECNAME)),
LTRIM(RTRIM(ZPSRECDEFN.OPTDELRECNAME)),(CASE WHEN (SELECT COUNT(1) 
FROM %7.PSRECDEFNLANG WHERE %7.PSRECDEFNLANG.LANGUAGE_CD = '%3' ) >= 0 
THEN COALESCE (ZPSRECDEFNLANG.RECDESCR,ZPSRECDEFN.RECDESCR) WHEN '%3'='%4' 
THEN ZPSRECDEFN.RECDESCR		END),LTRIM(RTRIM(ZPSRECDEFN.PARENTRECNAME)),
LTRIM(RTRIM(ZPSRECDEFN.QRYSECRECNAME)),LTRIM(RTRIM(ZPSRECDEFN.SQLTABLENAME)),
ZPSRECDEFN.BUILDSEQNO,LTRIM(RTRIM(ZPSRECDEFN.OPTTRIGFLAG)),LTRIM(RTRIM 
(ZPSRECDEFN.OBJECTOWNERID)),(CASE WHEN CONVERT(NVARCHAR(20),ZPSRECDEFN.LASTUPDDTTM,20)<
 '1900-01-01 00:00:00' THEN '1900-01-01 00:00:00' ELSE 
CONVERT(NVARCHAR(20),ZPSRECDEFN.LASTUPDDTTM,20)END),LTRIM(RTRIM(ZPSRECDEFN.LASTUPDOPRID)),
LTRIM(RTRIM(ZPSRECDEFN.SYSTEMIDFIELDNAME)),LTRIM(RTRIM(ZPSRECDEFN.TIMESTAMPFIELDNAME)),
ZPSRECDEFN.AUXFLAGMASK FROM %7.PSLANGUAGES ZPSLANGUAGES,%7. PSRECDEFN ZPSRECDEFN 
LEFT OUTER JOIN %7. PSRECDEFNLANG ZPSRECDEFNLANG ON 
ZPSRECDEFNLANG.RECNAME = ZPSRECDEFN.RECNAME AND ZPSRECDEFNLANG.LANGUAGE_CD = '%3' 
WHERE ZPSLANGUAGES.LANGUAGE_CD = '%3' AND ZPSLANGUAGES.INSTALLED = 1" queryout 
"%2\PSRECDEFN.txt" -t $$$$!@** -r $$$$!@**###\n -w -S "%1" -U "%5" -P "%6" 
echo Extracting PSRECDEFN – Completed