Reporting and Analytics
Discussion List
-
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…Nilesh Jain 2 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
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 12 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…
-
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…
-
Identify the SALARY Amount chanages based on AUDIT_CHANGE_BIT_MAP_ value in CMP_SALARY_ tableSummary: Hi Team, We have a requirment to create a repoert with only whenever user salary amount changes we need to include those rows in Report using CMP_SALARY_ Audit …Venkatesh Emani-Oracle 11 views 2 comments 0 points Most recent by Venkatesh Emani-Oracle Compensation
-
How to delete the association of Lead and Campaign?Summary: Hi Team, currently, once we add the Lead to Campaign, the association is being created on MKT_CAMP_MEMBERS. But once we removed it, the association Active statu…
-
Retrieving and showing info from third party SystemsSummary: Hi, we need to create reports and documents related to info retrieved via API from a third party system. Furthermore we need to show those data in Account subta…
-
Which table stores vacation rules on bpm worklistSummary: Which table stores vacation rules on bpm worklist Content (please ensure you mask any confidential information): Hello all, Can you help please to extract the B…Osama Mohamed 11 views 0 comments 0 points Started by Osama Mohamed Reporting & Analytics for Fusion Service
-
BICC Extract: No way to correlate MANIFEST.MF file to specific requestSummary: When submitting multiple BICC extract offerings in parallel via the ESSWebService (submitRequest), each completed job produces a MANIFEST.MF file in UCM under t…
-
how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 24 views 3 comments 0 points Most recent by thoham Reporting & Analytics for Fusion Service
-
How to get subledger accounting details in CAA subject area for journals with non AP, AR sources?Hi All, The Configurable Account Analysis (CAA) subject area in FAW/FDI does not shows subledger accounting details for journals with non AP (Payables) and AR (Receivabl…Junaid Ahmad 1 view 0 comments 0 points Started by Junaid Ahmad Payables, Payments & Cash Management
-
How to export the information that is in the Sales Dashboard from UI RedwoodSummary: I want to export the reports that are in the Sales Dashboard. Content (please ensure you mask any confidential information): I've created several reports in OTB… -
Payroll processing status for timecard not available in HWM_TM_REC_GRP_SUM tableI have a requirement to fetch the "Payroll Processing Status" on the timecard level as shown in the below image. Since the transfer status is available in the table HWM_…Janhavi Kulkarni-Oracle 31 views 1 comment 0 points Most recent by RaduA-Oracle Payroll and Global Payroll Interface (GPI)
-
Reopen RateSummary: Any tips on how to get the number of incidents that were reopened in a given time period? For example went from solved to updated (but may no longer be in updat…Kim Dante 1 view 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service -
Report Name Change ImpactsSummary: We have some reports in OTBI & BI which have a prefix of a Company and the name is changed - just a letter - XYZ to XY1 - so can anyone advice on the below Do w…Sailajad 11 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to access opportunity Scheduling data for reporting?Summary: In CX, there's a way that reps can forecast, monthly, how much an opportunity product will bring in using the schedule piece. How can we access and report on th…
-
Why Contract Audit Report is not Showing Line Status change/update in Audit ReportSummary: Contract Audit Report Is not Showing Status change/update in Audit Report in line level even though Status field for line level is already enabled in Manage Aud…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Is it possible to switch the display of an OTBI report to the Redwood view?Summary: I want the reports we create in OTBI to be displayed in the Redwood format. Content (please ensure you mask any confidential information): I want the reports de…