PeopleSoft HRMS Procure to Pay Process Configuration Insight (PSFTHRMSP2PCI)

To extract the files in script-based extraction:

  1. Edit the ExtractPSFTHRP2P_SQLBackend_Support.bat file.
  2. Comment the object's select query for which you don’t want to extract in the ExtractPSFTHRP2P_SQLBackend_Support.bat file. Just rewrite the Query as shown in the example. Please refer the example given below. 
    ECHO Extracting PSAUDIT --Started 
BCP "SELECT '' " queryout "%2\ PSAUDIT.txt" -t $$$$!@** -r -w -S "%1" -U "%5" -P
"%6"	REM BCP "SELECT  NULL,'@B$R@C!I#D#',LTRIM(RTRIM(AUDIT_OPRID)),(CASE WHEN CONVERT
00:00:00' -w -S "%1" -U "%5" -P "%6" (NVARCHAR(20),%7.PSAUDIT.AUDIT_STAMP,20)<
'1900-01-01 00:00:00' THEN '1900-01-01 ELSE CONVERT(NVARCHAR(20),
%7.PSAUDIT.AUDIT_STAMP ,20)END),LTRIM(RTRIM (AUDIT_ACTN)),LTRIM(RTRIM(RECNAME)),
LTRIM(RTRIM(FIELDNAME)),LTRIM(RTRIM (OLDVALUE)),LTRIM(RTRIM(NEWVALUE)),
LTRIM(RTRIM(KEY1)),LTRIM(RTRIM(KEY2)),LTRIM (RTRIM(KEY3)),LTRIM(RTRIM(KEY4)),
LTRIM(RTRIM(KEY5)),LTRIM(RTRIM(KEY6)),LTRIM (RTRIM(KEY7)),LTRIM(RTRIM(KEY8)),
LTRIM(RTRIM(KEY9)),LTRIM(RTRIM(KEY10)),LTRIM (RTRIM(KEY11)),LTRIM(RTRIM(KEY12)),
LTRIM(RTRIM(KEY13)),LTRIM(RTRIM(KEY14)),LTRIM (RTRIM(KEY15)) FROM %7.PSAUDIT" 
queryout "%2\PSAUDIT.txt" -t $$$$!@** -r $$$$!@**###\n
echo Extracting PSAUDIT – Completed