How To Compare Alphanumeric Values Of Two Different Columns.
(Doc ID 2216539.1)
Last updated on APRIL 10, 2017
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Technology Management - Reports/Analytics
How compare alphanumeric values of two different columns in OTBI report ?
Job Category and Person Category contains values like A, A1, B, B1, C, C1, CVC etc.
Both Person and Job Category contains values from A to E. A is the highest and E is the lowest.
Example: If C2 and C (Person Category) is less than B (Job Category).
The final output should be the persons whose Person Category is less than Job Category.
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