My Oracle Support Banner

SQL Error On Selecting Taskgroup On Smart Hire Template Section Configuration (Doc ID 2738692.1)

Last updated on DECEMBER 24, 2020

Applies to:

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

Symptoms

SQL error on selecting Taskgroup on Smart hire Template Section Configuration

SQL error. Function: Rowset.Fill
Error Position: 59
Return: 942 - ORA-00942: table or view does not exist
Statement: select fill.taskgroup,fill.task_profile_id,fill.descr from PS_TL_TSKGRP_DVW FILL WHERE FILL.TASKGROUP = 'xxxx'
Original Statement: %SelectAll(:1 FILL) WHERE FILL.TASKGROUP = 'xxxxx'



Steps to reproduce the issue
------------------------------
1) Login as an Administrator
2) Goto Setup HCM > Product Related > Smart HR Template > Template Creation
3) Select any template eg: KUEMP_ADMIN_FIN
4) Go   to Sections and Add the Section for TIME_REP_IDs and Select Section Configuration
5) Only Select the checkbox for Workgroup and Taskgroup as Required and Override and rest select as Hide and Save.
6) Goto Workforce Administration >  Smart HR Template > Smart HR Transaction
Select the template KUEMP_ADMIN_FIN Enter the details and select next
6) Enter the value for Workgroup and Taskgroup and tab out
7) Error Observed

Changes

 

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


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