My Oracle Support Banner

HCM 9.2: Microsoft SQL DB - OnBoarding Activity Guide: Summary Section SQL Error: "SQL error in Exec. AGC_UTILITIES.Context.ContextualData.OnExecute" (Doc ID 2866993.1)

Last updated on MAY 04, 2022

Applies to:

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

Symptoms

When attempting to access the Onboarding Activities Tile -Summary step in a Microsoft SQLServer Database, the following error occurs:


Steps to reproduce the issue:

Prerequisite for testing:
   1.Navigate to Set Up HCM> Common Definitions> Manage OnBoarding Event : Associate the Employee to a delivered Activity Guide Template
   2. Navigation: PeopleTools> Security> User profile : Make sure employee has the Role AG Composer User
   3. Login with the Employee setup at step 1 and access the Fluid Employee Self Service Fluid Homepage >Onboarding Tile
   4.Click on Summary Step and the error is displayed.

Changes

 The issue occurred after applying PUM Image 40, in PUM Image 38 it worked as expected.

Cause

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
Symptoms
Changes
Cause
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.