Invalid message while SQL transaction in process: Language preference will be changed to ZHS for the duration of your session. Select OK to Continue. (4600,343) (2,178) (Doc ID 2004833.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Symptoms

HCM 9.2

When a Manager with English Login accesses a Performance document created in Chinese Language (that does not have Define Criteria or Track Progress steps) the Manager gets an error : 

Invalid message while SQL transaction in process: Language preference will be changed to ZHS for the duration of your session. Select OK to Continue. (4600,343) (2,178) EP_APPR_SELECT.GBL.EP_BTN_LINK_WRK.EP_DOCUMENT_LINK.FieldChange PCPC:4159 Statement:54
A PeopleCode program tried to issue the indicated message while an SQL cursor is open. The message is invalid because it requires user input.
Review the PeopleCode and either move the message to a place where it will be issued during user "think-time", or change the "style" so no choice is required.

Steps to replicate :

1) Use a Performance document that does NOT have Define Criteria or Track Progress steps. Using Demo Delivered H0AP5 Template ID but removed the Define Criteria step on setup.
2) " Allow Language Override" field on the navigation : Set Up HCM > Install > Product & Country Specific > ePerformance Installation CHECKED.
3) Login as Manager HCRUSA_KU0046 and Navigate to Main Menu ; Manager Self Service - ; Performance Management - ; Create Documents. Create document for any employee using the above modified template , in any language other than ENG.
4) Log in as Employee HCRUSA_KU0039 and go to Main Menu ; Self Service ; Performance Management ; My Performance Documents ; Current Documents to complete self evaluation.
5) Login as Manager HCRUSA_KU0046 with ENG, and Navigate to Main Menu ; Manager Self Service ; Performance Management ; Performance Documents ; Current Documents. Click performance document of this employee, and will get the Invalid message while SQL transaction in process: Language preference will be changed to ZHS for the duration of your session.  Select OK to Continue. (4600,343) (2,178) error.

Note : References to Template ID H0AP5, Manager HCRUSA_KU0046, Employee HCRUSA_KU0039 is from PeopleSoft Delivered Demo data

Cause

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