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 and later
Information in this document applies to any platform.


On : 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