Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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
-
Make sure that the image URL (e.g., https://server.com/images/item123.jpg) must be: Publicly accessible OR Accessible to the BI Publisher server The image URL must end with a valid image file extension (.jpg, .png, etc.) Use following three steps to see if it works: SELECT ITEM_NAME, IMAGE_URL FROM MCS.ITEM_IMAGE (Assuming…
-
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…
-
You can expose custom objects to OTBI via BI View Objects, but this requires configuration. You can try following steps: Create the Custom Object in Application Composer. Add fields, relationships, etc. Deploy it. Enable Reporting: Go to Application Composer → Your custom object → Under Common Setup, click Enable for…
-
As per my understanding, The Modeler, Functional Administrator, Modeler Administrator, and Service Administrator roles are administrative roles meant for managing the overall analytics environment, metadata, and administration. It is not necessarily for direct dataset access or editing by default. You can create a Custom…
-
You might want to use Oracle Fusion’s Access Control Framework (ACF) and Data Roles The Access Control Framework (ACF) governs data security in Fusion Applications including segment value security. Assign users to Data Roles that restrict access to particular cost center segments. FDI can consume these roles and ACF…
-
Please refer R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet — Cloud Customer Connect There is Excel Spreadsheet recently uploaded Rel13_25.x_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx.zipUploaded Sep 25, 202544.5 MB Hope it helps!
-
You can try Page Integrations under Navigator→ Configuration
-
Try this video, hope it helps! Model Your Data With the Semantic Modeler in OAC: Part 1
-
Few pointers, hope it helps! Review the subject areas and columns used in those dashboards and confirm correct date columns and filters. Validate data pipeline freshness for HCM Hire and Termination datasets. Check dashboard filters, user roles, and data security settings for unintended restrictions. For prediction charts,…