E-RCF:SQL ERROR OCCURRED WHEN CLICKED ON COMPONENT RECORD FIELD LEVEL EVENT MAPPING

(Doc ID 2321508.1)

Last updated on OCTOBER 26, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.

Symptoms

On : 8.56 version, RCF

When attempting to configure Component Record field event Mapping and clicking on record Prompt getting the following error occurs.

ERROR
-----------------------
A SQL error occurred. Please consult your system log for details.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to PeopleTools > Portal > Related Content Service > ManageRelated Content Service
2. Go to event Mapping Tab.
3.Click on the Map the event of the Application pages link
4.Configure event mapping by adding any page
5.Click on the lookup prompt for the Record Name field in the "ComponentRecord Field Level Event Mapping" section.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot go further transactions.

Cause

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