HCM Attachments Unique Filename Gets Truncated if '&ATTACHSYSFILENAME = UUIDGENBASE64();' Function Contains '/' Sign, and the '+' Sign is Converted to '_' Sing when Using Database Blob (Doc ID 3053716.1)

Last updated on OCTOBER 24, 2024

Applies to:

Symptoms

The delivered code '&ATTACHSYSFILENAME' use the 'UuidGenBase64()' function to generate unique filenames but the function can have forward slash '/' and '+' signs in it. So when the unique file names is generated with this characters, if using database blob the '+' sign gets converted into '_' sign and if the URL is pointing to 'http' repository, filenames are being truncated due to the '/' forward slash.

Below are some examples, they are tab separated and first column is the generated filename and next what is actually saved:

Generated filename                              Saved filename
+AUbH7On7RGDIoNoLBw7RA==A._ABC_-_ABCD.pdf    _AUbH7On7RGDIoNoLBw7RA==A._ABC_-_ABCD.pdf
+GaPPU7r7RGYmaLG1L/E7A==X_XY_-_XYZ.pdf            E7A==X_XY_-_XYZ.pdf

The issue can be reproduced at will with the following steps:
1. Navigate to Workforce Development > Profile Management > Profiles > Manage Employee Profile
2. Click on Qualifications tab
3. Add attachments to Licenses and Certifications section.

Changes

Cause

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