Summary

Lexical parameter in Fusion BI Publisher Report ( SAAS)

Content

We want to create a report using Dynamic table name.

We had followed the Oracle provided document mentioned in the link below:

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-F9F844BA-5831-46E5-B085-44D82258A9A9.htm#BIPDM482

Using the lexical references we could pass the dynamic SQL, but in SAAS we may not able to create packages where lexical reference needs to be defined.

What other possible options are there to create a query where we can pass the table name dynamically.

Any document or information would be of great help with respect to the same.

Regards