My Oracle Support Banner

21D Fusion Global HR: My Team View by Position Error ORA-00904" "QRSLT" Invalid Identifier (Doc ID 2820138.1)

Last updated on NOVEMBER 08, 2021

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.21.10.0 and later
Oracle Fusion Workforce Directory Management Cloud Service - Version 11.13.21.10.0 and later
Information in this document applies to any platform.

Symptoms

In case Position Hierarchies are enabled, managers who are assigned the Custom Job Requisition security profile won't be able to access "View by Position" page after they've selected that option from the List of Values on the My Team page.

Steps to replicate:
1) Create Custom Job Requisition Security and assigned to the Role
2) Login with the manager user and navigate to My Team -> My Team
3) Select View by Position
 
The following error is triggered:
ORA-00904" "QRSLT" "<ATTRIBUTE>": invalid identifier

Depending on the custom security profile and the predicate used, the attribute from the error message might point to: ORGANIZATION_ID, JOB_FAMILY_ID, JOB_FUNCTION_CODE, GEOGRAPHY_NODE_ID.

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
References

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