How to create lookups through Fusion BI

Sankeerthana Anumasula-Oracle

Summary

We have a requirement to create lookups but we dont have access from UI.Is there any way that we can achieve this task through BI/OTBI.

SantoshKumarBhairi

You can only create logical lookups in BI/OTBI thru CASE statement or using select 'x' form dual, etc. 

And if you are going to require those lookups to transact further, they must be created in the Fusion UI using dff setup.

MandeepGupta

Hi,

You can't create the lookups using BI like on-prem systems. The only option other than UI is to use web services. However, currently there is no REST API support to create lookups. So, the only option is to use SOAP services.

Please check below links to use webservices for lookup creation:

How to import of Lookup Types and Lookup codes using Webservice ? (Doc ID 2215379.1)

https://community.oracle.com/mosc/discussion/4054229/webservice-for-valueset-lookup

Thanks.

 

Sankeerthana Anumasula-Oracle

Hi Mandeep,

 

Thank you so much for the reply. This looks helpful .

 

Thanks and Regards,

Sankeerthana

Sankeerthana Anumasula-Oracle

Thank you for the reply. I will check on this.

Thanks and Regards,

Sankeerthana