My Oracle Support Banner

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.

Symptoms

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.



Changes

 

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
Changes
Cause
Solution


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