Reporting and Analytics
Discussion List
-
Oracle Schedule Agent discrepency compared to manual runHi, We have encountered an issue regarding an OTBI scheduled Agent report where the output results differ significantly depending on how the report is run: Manual Run (v…Josh Dewar 4 views 0 comments 0 points Started by Josh Dewar Reporting & Analytics for Fusion Service -
How to create Employee as a SupplierWe have a requirement to create Supplier records for all active Employees. Please advise on the best approach to establish a link between the Employee and the correspond…Kinjal Patel-Oracle 133 views 4 comments 3 points Most recent by glakshmisha Reporting & Analytics for Fusion Service
-
Last Referring URL Report for ChatContent Hey everyone, I am attempting to build a custom report to show the Last Referring URL before a Chat Request. I have built a "referrer" report where I used "click…User_2025-02-01-08-41-04-877 24 views 5 comments 0 points Most recent by J.Pouliot Reporting & Analytics for B2C Service -
We have requirement where while creating BIP reports in fusion we need to fetch data from Oracle ATPSummary: I have a requirement to build a PDF report in Oracle Fusion Cloud ERP. Most of the data comes from Fusion through BI Publisher (BIP) data models and SQL queries…anushkagrawal 18 views 0 comments 0 points Started by anushkagrawal Fusion Applications Administration
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 51 views 5 comments 1 point Most recent by Dkowall-Virtua Reporting and Analytics for SCM
-
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
Is there a report to show employees with no supervisor listed on their current Assignment record?Is there a report to show employees with no supervisor listed on their current Assignment record?Richard Nagle 21 views 3 comments 0 points Most recent by Jill Stanton Reporting & Analytics for Fusion Service -
REST API to check onhand quantities at org and item level in oracle fusionCan experts help me to with REST API to check onhand quantities at org and item level.Shahid Qureshi 01 21 views 0 comments 0 points Started by Shahid Qureshi 01 Reporting & Analytics for Fusion Service
-
CSV report output from OAC/BIP missing double quotes on string valuesHi Team, There are some csv reports setup in OTM BIP server. Every 2 hours, OIC pulls these csv reports and fetches the output and places them at another external locati…Nabil Saidu Muhammed 17 views 0 comments 0 points Started by Nabil Saidu Muhammed Reporting and Analytics for SCM
-
Unable to View XML Data from Seeded Print Packing Slip Data ModelSummary: Hi Team, I am trying to view the XML data from the seeded Print Packing Slip Report data model in Oracle Fusion. However, when I try to view the data by providi…Pratiksha Sawandkar 10 views 0 comments 0 points Started by Pratiksha Sawandkar Reporting and Analytics for SCM -
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh…Viktoria Priona-Oracle 121 views 4 comments 0 points Most recent by Viktoria Priona-Oracle Reporting & Analytics for Fusion Service -
Oracle Cloud Environment Usage Assessment - Data Extraction QueriesSummary: We are working on doing Oracle Cloud Environment Usage Assessment based on attached documents shared by Oracle SR. Can you please share queries to extract the d…Amit Sutar 26 views 1 comment 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
PublicReportService - generateReport failedWe have a report in this path: /Custom/Customer Relationship Management/Data Warehouse/Res/Informes_Parametros/SpaceConfigurationDS_Analisis.xdo We reviewed the permissi…
-
Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…Sudara 379 views 2 comments 0 points Most recent by DileepDasari-Oracle Reporting & Analytics for Fusion Service
-
Which table are we going to use for Redwood Trading Partner Items?After migrating Trading Partner Items to Redwood, their data now resides in both EGP_TRADING_PARTNER_ITEMS table and EGP_SYSTEM_ITEMS_B table. Is this how it's going to … -
Bursting on the basis of weekelyHi everyone, We are using Oracle BI Publisher Bursting to generate and distribute data files. Since the data volume is dynamic, the generated output can exceed the 10 MB…
-
Custom OTBI Dashboard Appears Blank in Redwood ServiceSummary: Hi Team, I have created a custom OTBI dashboard for Service, which contains multiple custom analyses/reports with drill-down functionality to view the underlyin…
-
Is there an MCP available for OAS?We have recently explored the MCP server for Oracle Analytics Cloud and wondering if an MCP server is available for OAS as well. Please share some resources to set it up…Venkatesh Prabhu 15 views 0 comments 0 points Started by Venkatesh Prabhu Reporting & Analytics for Sales
-
How to convert an existing OTBI report with prompts and filter conditions to BIP reportSummary: We have requirement to convert the OTBI report to BIP report. The OTBI reports has prompts and filter condition. How can we convert the same in BIP report witho…
-
Supervisor dashboard showing incorrect Results in Oracle Fusion ServiceThe Longest waiting chat in the Supervisor Dashboard is not getting refreshed for a particular Chat queue. The Longest active chat talk time for agent was increasing mor…
-
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …
-
Oracle Cloud Database Tables for Approval Workflows in Oracle Cloud Financials ApplicationSummary: Approval Workflows like Supplier Registration Approval, Document Approval, etc in Oracle Cloud Procurement Application have POR_AMX tables that we can query in …
-
FDI configurable account analysis does not have information on receipt accounting transfer ordersSummary: Content (please ensure you mask any confidential information): The FDI configurable account analysis (CAA) seems to exclude transaction details for receipt acco…Walter L Gess 31 views 0 comments 0 points Started by Walter L Gess Reporting & Analytics for Fusion Service
-
How to identify Region/Location names on Transit time tables?Summary: On the transit time tables (WSH_TRANSIT_TIMES/WSH_TRANSIT_TIME_VALUES), we have the From & To Location and Region ID's. So, which tables can be used to map thes…Rudra_2024 33 views 3 comments 1 point Most recent by Catherine Alequin Reporting and Analytics for SCM
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…
-
Application compser smart action- view quote error CX moduleSu Application compser smart action- view quote error CX module Content (please ensure you mask any confidential information): Version (include the version you are using…Kammarapalli Venkatesh-Oracle 3 views 0 comments 0 points Started by Kammarapalli Venkatesh-Oracle Reporting & Analytics for Fusion Service
-
How WFTASK to FND_BPM_TASK_B and WFTASKHISTORY to FND_BPM_TASK_HISTORY_B tables mapDear All, We are looking proper documentation for mapping WFTASK to FND_BPM_TASK_B and WFTASKHISTORY to FND_BPM_TASK_HISTORY_B because we are facing the issue when we ar…
-
Building OTBI security role by Subject Area for Oracle Fusion HCMSummary: We have requirement to build security roles by OTBI subject area. Content (please ensure you mask any confidential information): Looking for step by step instru…Krishna Palvadi 32 views 0 comments 0 points Started by Krishna Palvadi Reporting & Analytics for Fusion Service