E-FTP: PS_FILEDIR Environment Variable Value and its Usage in File Attachment Functionality (Doc ID 1990809.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Goal

On PeopleTools 8.52.07, a delivered CRM 9.1 application engine process RY_DRE seems to use the PS_FILEDIR environment variable inconsistently:

In one occasion, it issues an SQL statement "INSERT INTO PSPRCSRQSTFILE ( PRCSINSTANCE,SEQNUM,PRCSRQSTFILE) VALUES (:1, :2, :3)",
and the bind variable for PSPRCSRQSTFILE.PRCSRQSTFILE provides a well-formed value "E:\CR91\appserv\prcs\DEVCR\files\CCEV1180_test.xml",
which has a directory separator "\" between directory path "E:\CR91\appserv\prcs\DEVCR\files" (=PS_FILEDIR) and filename "CCEV1180_test.xml".

In another occasion, there is a sequence where the directory separator is not been inserted, leading to an incorrect file path usage and an error:

where the concatenation &sProcessSchedServDir | &sFileName gets bad value "E:\CR91\appserv\prcs\DEVCR\filesCCEV1180_test.xml"

Why is the PS_FILEDIR variable used differently in different parts of the same delivered process, is it a result of a PeopleTools bug?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms