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

Goal

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

Solution

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