My Oracle Support Banner

HR ESP: Contract Attachments Don't Work When Using SFTP (Doc ID 2535590.1)

Last updated on NOVEMBER 18, 2019

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue :

HR spain use attachments have code which are not written for SFTP based URL definitions and used String based URL.


For Eg:

Local string &URL = "URL." | CNT_TEMPLT_ESP.URL_ID.Value;

If All(&URL) Then
rem MessageBox(0, "", 0, 0, "&URL - " | &URL);
Local number &retcode = AddAttachment(GetURL(@&URL),
&ATTACHSYSFILENAME, "", &ATTACHUSERFILE, 0);

In this code fragment the URL gets the "URL." notation stripped by the GetURL

function and hence if the URL is a SFTP based one, this doesnt work. Once we
substitute this with the following the code works as expected :

Local number &retcode = AddAttachment(@&URL, &ATTACHSYSFILENAME, "",
&ATTACHUSERFILE, 0);

Steps :
Above codes are found in below events-
CNT_TEMPLATE_ESP.GBL.FM_DERIVED_ESP.VIEW_PB.FieldChange(Component peoplecode)

CNT_TEMPLATE_ESP.GBL.FM_DERIVED_ESP.EFFDT.FieldChange(Component peoplecode)
CNT_TEMPLATE_ESP.GBL.FILE_ATTACH_WRK.ATTACHVIEW.Fieldchange(Component
peoplecode)
CNT_TEMPLATE_ESP.GBL.FILE_ATTACH_WRK.ATTACHADD.Fieldchange(Component
peoplecode)
CNT_TEMPLATE_ESP.GBL.FILE_ATTACH_WRK.ATTACHDELETE.Fieldchange(Component
peoplecode)

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.