Issue with Attachments for Contract Entry Page when using Server Type as URL

(Doc ID 2419052.1)

Last updated on JULY 04, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

We have setup file attachment setup with Server Type as URL to pick URL type and has subdirectories defined for components for Contracts, Amendments etc Below are the two issues happening

1) While creating new amendment in contract ID the file is going into subfolder called "DocMaint" and Inserting new row into PS_PV_ATTACHMENTS table with file details.

This should have ideally also inserted the subdirectory information in SERVER_PATH field of above table. ie SERVER_PATH for the above file should be now"/DocMaint".But this not getting updated .Hence when we try clicking 'View Amended Documnent" button system thinks that file is in parent directory as SERVER_PATH is blank which is actually not the case, Hence getting error Cannot locate file (10420,336).

2) In Contract Entry Page go to Edit Comments> add an attachments. The file goes to sub directory as per setup. But when trying to view , the system is not taking the url under URL definition set up in administer File Attachment page, instead it consider the name of URL itself as the actual path which is not correct. This is happening at delivered code - &retcode = ViewAttachment(@(&url), &sys, %This.UsrFile); at SCM_ARCH_ATTACH:Attachments:Attachment
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms