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.
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.
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.
Hi Mandeep,
Thank you so much for the reply. This looks helpful .
Thanks and Regards,
Sankeerthana
Thank you for the reply. I will check on this.
