How To Compare Alphanumeric Values Of Two Different Columns.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms