My Oracle Support Banner

E-CRM: How to Update the LONG_URL Field from PS_RC_CASE_ATTACH Table? (Doc ID 2724710.1)

Last updated on NOVEMBER 02, 2020

Applies to:

PeopleSoft Enterprise CRM Multichannel Communications - Version 9.2 and later
Information in this document applies to any platform.

Goal


In table PS_RC_CASE_ATTACH the LONG_URL field contains the URL to view an attachment that is linked to the CASE.

e.g the LONG_URL for an attachment looks something like:
https://hrxxx.xxx.com/PSAttachServlet/crmxxprd/xxx/12345_2_555.png?contentType=image/png&attRoot=//xserver/ps_attachments/x_att/&emailID=1234&server=outlook.xxx.com

Since the complete URL is stored in the table, how do we update the file reference URL if the file server location change?
 

Solution

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
Goal
Solution
References


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