My Oracle Support Banner

Sample AXF_ATTACHMENTS_CONFIG.sql for Setting up the PeopleSoft Application Adapter for Use with UCM Managed Attachments (Doc ID 1331901.1)

Last updated on AUGUST 15, 2019

Applies to:

Oracle WebCenter Content - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Goal

In setting up the PeopleSoft Application Adapter for use with UCM Managed Attachments, the AXF_ATTACHMENTS_CONFIG.sql file must be run against the IPM database. 

$MW_HOME/Oracle_ECM1/axf/adapters/psft/AXF_ATTACHMENTS_CONFIG.sql 

A sample of the insert statements for this file is below. These inserts must be run against the IPM schema (e.g. DEV_IPM). Note that the UCM_CONNECTION_STR value must have the proper Profile (PSFTProfile) and ResultTemplate (PSFT_LIST) set in the URL.  The placeholder values for trigger and ResultTemplate in brackets must be set to PSFTProfile and PSFT_LIST respectively. 

 

 

Note: add the line "SET SCAN OFF" to the SQL file to disable the SQL tool from interpreting the ampersands as requiring input for substitution values.  Lastly, be sure to commit the changes to persist the inserts in the database.

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

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