How to Call ff_exec.run_formula in Oracle BI Publisher Report

Moamin Shadid

Summary:

Hello Oracle Experts,

I am working on Oracle Fusion Cloud BI Publisher (BIP) report and need to call the ff_exec.run_formula function to retrieve Fast Formula results within my data model. However, I am unsure about the correct way to invoke this function in BIP and whether there are any prerequisites or limitations when using it in a SQL-based data model.

Here are my specific questions:

1. What is the correct syntax to call ff_exec.run_formula in a BIP report data model?
2. Are there any parameters or context settings required for this function?
3. Is there any restriction on calling it in SQL queries inside the BI Publisher data model?
4. Are there alternative ways to fetch Fast Formula results in BI Publisher reports?

I would appreciate any guidance or examples from those who have successfully used ff_exec.run_formula in BI Publisher reports.

Thanks in advance!

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):