E-FTP: PutAttachment Function Replacing $ Sign To _ (underscore)
(Doc ID 2865968.1)
Last updated on MAY 05, 2022
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.59 and later
Information in this document applies to any platform.
Using PT 8.59 version, File Attachments - PutAttachment function replacing $ sign to _ (underscore):
During tax withholding processing PutAttachment function is changing $ sign to _ (underscore) in the file name. $ Sign in the File name is replaced with _ underscore. Due to this the attached file is not being deleted from the attached record. Example: During W4 Tax Withholding processing, file name is inserted into PY_WHFORM_GUIDE and PY_WHFORM_DATA records.
Data is inserted into PY_WHFORM_GUIDE record using a SQL (PNAW4_I_WHFORM_GDE) which has a insert statement. PutAttachement function is used to insert data into PY_WHFORM_DATA. PY_W4_FILEID field in PY_WHFORM_GUIDE has $ Sign where as ATTACHSYSFILENAME field in PY_WHFORM_DATA record has _ (underscore). Because there is a mismatch in the file names, during delete the attachment data is not being deleted from PY_WHFORM_DATA record.
The issue can be reproduced at will with the following steps:
1. Provide URL ID on File Attachment Test.
2. Test Upload
3. File name replaces $ signs with underscores where required.
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