SQL ERROR ON "TEMPLATE CREATION" PAGE WHEN "TEXTID" PROMPT IS CLICKED (Doc ID 2229771.1)

Last updated on JULY 04, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Related language prompt query failing due to underlying CLOB usage

Connected in French, the prompt for "TextId" field from "Template Creation" ( SetUp HCM -> Product Related -> Workforce Administration ->Smart HR Template ->Template Creation page and click on click on "Select Configuration" link) results in following SQL error:
"A SQL error occured. Please consult your system log for details"

The issue can be reproduced at will with the following steps:
1. Connected in English,
2. Go to SetUp HCM -> Product Related -> Workforce Administration ->Smart HR Template ->Template Creation
3. click on Select Configuration -> "Template Section Configuration" subpage upload
4. click on "Change Label" link from "Template Section Configuration" subpage
5. click on TextId -> prompt works OK
Connected in French, the prompt for "TextId" field results in SQL error: "A SQL error occured. Please consult your system log for details".

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