No experience with Snowflake but see if below works for you: Add an 'All' option with a null or special value, like '@ALL @' . Display Value Return Value All @ALL @ WHERE (:PARAMETER_NAME = '@ALL @' OR FIELD IN (:PARAMETER_NAME)) This makes it explicit: when @ALL @ is selected , skip filtering. I think this pattern is…

You can start with following query SELECT dept.ORGANIZATION_NAME AS DEPARTMENT_NAME, bu.BUSINESS_UNIT_NAME, le.NAME AS LEGAL_ENTITY_NAME, le.LEGAL_ENTITY_IDENTIFIER FROM HR_ORGANIZATION_UNITS dept JOIN PER_BUSINESS_UNIT_ORGS buo ON dept.ORGANIZATION_ID = buo.ORGANIZATION_ID JOIN FUN_BUSINESS_UNITS bu ON bu.BU_ID =…

It is a good question. For quick turnaround, consider taking help from Oracle Support by logging a SR.

It is tricky but see if you can make it work by using Payables subject areas like: Payables Invoices – Transactions Real Time Payables Payments – Transactions Real Time Procurement – Spend From these subject areas, you can get: Supplier Name Invoice Amounts (debited from AP) Payments GL distribution details (via invoice…

Please confirm if this question still needs answer otherwise consider closing it as Accepted Answer. Thanks

It is a good idea, but you need to consider creating ADW pipeline and obviously need to consider the cost as well. You can explore creating a Custom Object in ERP and SCM domain using Application Composer and it will give you an option to populate the data within Fusion and it will be available within OTBI Custom Subject…

Sometimes OTBI needs a metadata refresh. If you still don't see the DFF: Log out and back in. Navigator → Tools → Reports and Analytics Click on "Browse Catalog" Go to Administration → Reload Files and Metadata Also, it is worth checking …. Was the DFF segment deployed to the correct context (e.g., global or specific)? Are…

Checklist Real Time SA is particularly isolated and not directly joinable to other SAs unless you structure it specifically. One option to try is Start from "Worker Assignment Real Time" (base SA). Add fields from "Goal Status Overview Real Time". Then try adding only specific fields from "Checklist Real Time" – not the…

As per Analytics community guidelines, please accept the answer so that this post can be considered Closed and future community members can refer it accordingly.

Can you share the recording for the audience who cannot attend in person?

You have a valid point, please consider logging an idea in the Idea Lab.

If it is not showing up in the LOV then it is not available for now, you can consider logging an idea in the SCM Idea Lab.

If you have checked PVOs and did not find anything then try building a small BIP report that selects from the needed tables (with appropriate security filters), schedule it to output a flat file (CSV/Excel), and load that output into your ETL pipeline.

Check POZ_SUPPLIER_REGISTRATIONS - This is the primary table that stores supplier registration / onboarding requests.

In Oracle Fusion OTBI, when creating a report using the "Procurement - Purchasing Real Time" subject area, the PO Line Quantity can be tricky to locate because of how data is exposed and not all columns behave as expected in all use cases (e.g., for partially approved or complex lines). In the subject area: Procurement -…

There could be something corrupt Sometimes after edits, parameter mappings in the report become corrupted. Worth a try … Exporting your data model. Deleting all parameters. Re-adding them with correct data types, LOVs, and default values.

Hope you have reviewed following documentation .. Enable Plans for OTBI Reporting

You might need to log a SR to review your scenario with Oracle Support. Oracle Support can review and suggest if it needs an idea in the Idea Lab.

You might need to log a SR for Oracle support to review it with the development team. Oracle Support can suggest if it needs an idea in the Idea Lab.

You might need to log a SR for Oracle support to review it. Oracle Support can review and suggest if it needs an idea in the Idea Lab.