Custom SQL in OTBI report

Jaime Castillo

Hello,

I have the following problem. I would like to have the signing authorities in a OTBI report; the main issue is that I have the codes but not the meanings (I've been told that is stored in FND_LOOKUP_VALUES with particular lookup type). So my approach was basically add a new column that contains a CASE where I do the mapping code - > meaning; and is working fine:

CASEWHEN " "." " = aTHEN 'asdf'
WHEN " "." " = bTHEN 'ñlkj'
...
ELSE '' END

(I do not add the data and fields and values due to confidenciality stuff).

The issue I have now, is that the client is not fine with this approach, and wants to do it in another way; what I thought is basically add a query, but I have no idea how this table is mapped in OTBI: FND_LOOKUP_VALUES, so I can add a new column with the following query:
select meaning from FND_LOOKUP_VALUES where lookup_type='asdf'

Any hint or suggestion, will be welcome.

Kind regards.

Rajasekhar Bandaru-Oracle

Hi

Please review the given OTBI LIneage mapping documentation link details.https://community.oracle.com

HCM

=====

https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

SCM

====

https://community.oracle.com/customerconnect/discussion/479636/r13-scm-and-procurement-otbi-subject-areas-to-database-lineage-mapping-spreadsheet

FSCM

=======

https://community.oracle.com/customerconnect/discussion/40268/financials-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

Filter the data based on the database object(FND_LOOKUP_VALUES) and identify the OTBI subject area presentation column details.