PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Peoplesoft Attachment

edited Oct 10, 2014 10:02AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

Hello,

I have written peoplecode to generate attachements to a physical storage location using the code below. The problem is if there are attachments with the same file name, the already existing ones would get over written on the file server. Is there anyway to generate unique file names for the files generated?

&UC_Rs = CreateRowset(Record.UC_TV_RQST_ATCH);
&UC_Rs.fill("WHERE UC_TV_REQ_NBR = :1 AND UC_TV_ATT_TYPE='PD'", &uctv_req_nbr);
For &i = 1 To &UC_Rs.activerowcount
   &UC_Attachsysfilename = &UC_Rs.getrow(&i).getrecord(Record.UC_TV_RQST_ATCH).ATTACHSYSFILENAME.value;
   &UC_Attachuserfile = GetEnv("PS_SERVDIR") | "\files\PD\" | &UC_Rs.getrow(&i).getrecord(Record.UC_TV_RQST_ATCH).ATTACHUSERFILE.value;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center