Reporting and Analytics
Discussion List
-
Unable to see the Business Unit value in the ESS Job report parameter as LOVHi All, We have created a custom role for Accounts Receivable Specialist to restrict user access only for Creating or Managing the AR Transaction along with some ESS Job…Naresh Kumar-95714 1 view 0 comments 0 points Started by Naresh Kumar-95714 Fusion Applications Administration -
OTBI Report Giving Performance issue specifically for Non BI Admin UsersWe created a custom OTBI report in Oracle BIP using the "Inventory - Inventory Transactions Real Time" subject area. When the report is run by users with BI Admin access…User_G9BRM 11 views 1 comment 2 points Most recent by User_G9BRM Reporting & Analytics for Fusion Service -
Data Table for Activity Streams in RedwoodSummary: Hi, Are there any data tables or subject areas available for the Activity Stream in Redwood? We would like to create some reports on them. https://docs.oracle.c… -
We could not see the table for Email Communication functionalitySummary: We could not see the table for Email Communication functionality for Activities, we would like to seek assistance on locating the backend table for this. Conten… -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh… -
Select BIP to get the pick slip for the pending transactionsSummary: Select BIP to get the pick slip for the pending transactions of a specific item Content (please ensure you mask any confidential information): Hi All, we need a…Mamdouh Ahmed 11 views 1 comment 0 points Most recent by Ahmed Maher Kadeh Reporting and Analytics for SCM -
HCM Table that stores Candidate Personal DetailsSummary: I need to get the HCM ORC Table that holds this record based on the screenshot belowUser_6RUAW 1 view 1 comment 0 points Most recent by Abhishek Premchandra Reporting & Analytics for Fusion Service -
Custom Dashboard in Redwood Service Center – Graph Resize, Table Report, and Drill-Down CapabilitySummary: I have created a custom dashboard and embedded an analytics report that displays a graph (SR Routing Report). I need guidance on the following: 1. Graph Size Ad… -
GRNI report issueSummary: Hello all, we are using seeded GRNI report in oracle fusion and a custom report for GRNI with some additional columns. Both of them are not matching, Custom rep… -
OTBI Reporting Performance issueI am using two subject areas Order Management - fulfilment lines real time & Shipping real time for oracle fusion OTBI report, as per the business requirement, inspite o…Shahid Qureshi 01 21 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM -
How to run Costing Reports outside of Scheduled Processes?Most of the reports under /Shared Folders/Supply Chain Management/Cost Management/Cost Accounting and /Receipt Accounting are only able to be run through the Scheduled P…Abigail Wiggins 11 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
Difference in report outputs in PIMI have a custom report built using SQL based data model, no UI or report level filters. However when I run the report an excel is downloaded with inconsistent report out… -
Report descriptionSummary: I would need a complete list of Out Of the Box Reports for Oracle ERP and SCM. Content (please ensure you mask any confidential information): I would need a com…DamianLopez7 11 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM -
How can I hide disabled item classes in Report and Analytics?Hi, How do I hide / remove disabled Item Classes in Report and Analytics? I have disabled 2 item classes, but these are still showing in Report and Analytics Is it possi… -
Do you need FDI to create new KPIs in new Purchasing icon?Summary: Hi Oracle community, I am following this link regarding the new Purchasing Icon application on the Procurement tab on the Oracle Fusion Homepage Link: https://d… -
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 11 views 2 comments 0 points Most recent by Shahid Qureshi 01 Reporting and Analytics for SCM -
How to embed Data Model report with filter based on the opened record?Summary: How to embed Data Model report with filter based on the opened record? We have created a BIP Report due to it's flexibility over OTBI and would like to embed it… -
Passing Custom Parameters (BIP) in Report Task Type in Guided Journeys (Redwood - shipment page)BI Report on Shipment Page: We need the Guided Journey parameters available on the "Shipment" page to pass the Shipment as an input parameter required by the BI reports. -
How we can get the percentage between two contract fields after each 20 lines or after the last lineCurrently we have a requirement to show a total at last of each page for contract lines. Let say we have 30 contract lines, we are printing 20 lines at first page then r…Abhishbansal 1 view 0 comments 0 points Started by Abhishbansal Reporting & Analytics for Fusion Service -
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not… -
Usage of Prompt's "contains any" for both upper case and lower caseSummary: Usage of Prompt's "contains any" for both upper case and lower case Content (please ensure you mask any confidential information): Hi Experts, I am using subjec… -
Oracle BPM Workflow Rule Configuration and Approval Hierarchy ReportingThe client is requesting a holistic configuration‑level view of all approval workflows configured in Oracle BPM covering both ERP and HCM modules. The focus is strictly … -
How to create audit report using SQL statement where in similar result to history tabSummary: in history tab of each record, we can see the changes of each auditable fields. like for example: field1, we can see in the list the before and after change. i … -
Handle-Time per Agent for Transferred ChatsContent Does anyone have experience calculating handle-time per agent across a single chat, when multiple agents have handled the chat? For example, if I initially handl…Michael Winter 35 views 5 comments 0 points Most recent by User_HY8R2 Reporting & Analytics for B2C Service -
Agent's Chat AHT without Virtual AssistantSummary How to exclude VA's AHT from Agent's AHTContent We recently began piloting Oracle's VA. All of our reporting is based on the Chat table, which means it it includ…user3511667 31 views 2 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
Is there a way to prevent user from running a report for other BU other than they ownSummary: We have a requirement to prevent user from getting data for BU's other than the one they are assigned to. how to achieve this for BIP report Content (please ens…