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.

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.

Please explore by creating a custom OTBI report that lists timecards with fields including Status (e.g., Incomplete, In Error) then use a filter on Status in the report. Embed this custom report as a page or dashboard in Redwood for users.

Have you tried https://docs.oracle.com/en/middleware/bi-publisher/12.2.1.4/biprd/BIPRD/GUID-5DFF8A6D-84A5-4C45-BA0F-FFFB5FAEF5A3.htm

If it is a BIP report, you should be able to Edit the Report and drag the column to the desired position

Unlike OTBI, BIP allows more flexible data access logic, where you can use custom SQL to include terminated employees regardless of current Line Manager. You can then embed the BIP report in the Fusion UI or send it via scheduled email.

There is no out-of-the-box OTBI subject area that includes UOM conversion details. OTBI primarily focuses on transactional and operational data, not setup/config tables like UOM conversions. You can try to get it from following tables: EGO_UOM_CONVERSIONS_B: Holds conversion rates between UOMs. EGO_UOM_CLASSES_B: UOM class…