E-FTP: PS_FILEDIR Environment Variable Value and its Usage in File Attachment Functionality
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.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms