Hi @Sankalp-D, If you already has a Fusion Cloud analytics entitlement like Oracle Analytics Cloud subscription should be able to use BI Publisher for reporting without extra cost. But if you have only Oracle Fusion Field Service subscription and the contract does not explicitly include Oracle BI Publisher as part of the…

Hi @Chetana2000, You can remove all HTML tags from your HSDL file before loading using Notepad++ using regular expression Go to Search →> Replace and use this regular expression <[^>]*> Below is the sample file for illustration After using Replace you can find the cleansed file Hope this helps Thanks

Hi @Sankalp-D , OTBI offers constrained, indirect access to Oracle Field Service data. Unlike core Fusion pillars such as ERP, HCM, and SCM, OFS does not have dedicated, native OTBI subject areas. There are no dedicated OTBI subject areas delivered out-of-the-box for Oracle Fusion Field Service (FFS or OFS). Since OTBI…

Hi Chris, You can generate check output (PDF/XML) using BI Publisher. Next customer side server pulls the generated file using SFTP or using Web API/REST APIs. Then local server send job to internal print server or spooler. Oracle does not directly integrate with printers, but can integrate with Check printing vendors,…

Thanks @Rasta Ghafouri-Oracle that's great to hear

@SaurabhJaiswal-Oracle If possible can you please share the bug number

@Rajaraman Loganathan - If I am not wrong there is no separate indexing step required to make a Subject Area accessible for Natural Language Query (NLQ) or AI Assistant.

Thank you @Lalitha Venkataraman-Oracle for sharing

Effective Start Date and Effective End Date these two columns are important to show history rather than the current record. Go to criteria tab then Filters and then remove filters such as Effective Latest Change = Yes Effective End Date is after current date Current Record Flag = Y Please make a note do not filter on…

Hi @Ulitka You need to use the subject area, Workforce Management – Worker Assignment Real Time Add the columns from the Person Address folder: Address Type, Address Line 1 City State, Postal Code Country Effective Start Date Effective End Date Add a filter on Address Type = "HOME".

No — there is currently no configuration, feature flag, or admin setting to force numeric/text AI responses onto the canvas. This limitation exists in: OAC (Oracle Analytics Cloud) FDI embedded analytics (since it uses the same AI layer) Even service administrators cannot override this behaviour. Workaround: Use “Explain”…

Internally, numeric/text responses are often generated through: Aggregated AI interpretation layer Semantic query abstraction Sometimes post-processed responses (not always a 1:1 logical query object) So Oracle restricts “Add to Canvas” because those responses are not always backed by a reusable visualization object.…

Use these options given below Option 1 — Use a Session Variable Instead (Best for On-Demand Behaviour) If you truly need on-demand refresh logic, session variables are much more flexible. Why? They refresh at login (or session creation) Can be influenced by user context Can be re-evaluated via new session (logout/login or…

There is no native “Refresh Now” button for Repository Variables in Oracle Analytics. Repository variables (especially dynamic ones) are refreshed only through: Initialization Blocks Their configured schedule (refresh frequency) Server restart (for static repo vars) They are evaluated and stored at the BI Server level, not…

Best Practice Approach (Enterprise-Recommended) Row-Level Data Security (RLS) Using Data Security Tables This is the cleanest and most scalable way to mirror cost centre segment security. Architecture Pattern: Extract user → cost centre access mapping from Fusion (via data roles / segment value security rules) Store that…

In Fusion (GL, Payables, etc.), Segment Value Security is enforced in the application layer via data roles and security rules tied to the COA segment. But in Oracle Fusion Data Intelligence (FDI): Data is extracted into a warehouse Security is not dynamically evaluated against Fusion SVS policies Reports run on semantic…

Hi Senthil, In classic OBIEE dashboards, prompts could directly leverage: Repository variables Session variables Presentation variables (including hidden prompts) Request variables and you could chain them pretty freely inside prompt sections. In modern Oracle Analytics (OAC / DV), the architecture is different. Prompts…

If my response has answered your question, please mention the thread as Accepted Answer as this will help the community members on the solution

Your Current Role Design (Root Cause) From your setup: Area Role Result Finance DV DV Consumer View only (correct) HR Adhoc BI Author Can create Classic reports DV Dataset (HR) Accessible Appears in Create Analysis The key conflict: BI Author + Dataset visibility = Dataset usable in Classic Analytics Restrict Dataset…

Hi Jayaraman, In OAC/OAS, Data Visualization (DV) datasets are exposed as logical data sources once a user has: Access to the dataset (even read-only) AND authoring privileges (like BI Author) So when a user has the BI Author role, the platform assumes: “If you can author analyses, you can use any accessible data source —…