Reporting and Analytics
Discussion List
-
FDI is not accessible for some users only in some locations due to sign-on policy accessSome users that were supposed to have access to FDI cannot access the tool any more ( only for some locations) they still access our HRIS using their addresses IP but no…Ayoub Afrass_1 12 views 3 comments 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration -
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 23 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
How to find the path for OTBI behind seeded infolets in Oracle?Hello, There is a seeded inventory dashboard in Oracle fusion, On-Hand value. I am trying to understand how to get to the actual OTBI it is invoking to get this data. I …Sheetal VBCS 33 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Cycle count adjustmentI have to make an cycle count history report BU wise – for this I am using INV_CYCLE_COUNT_ENTRIES table, in the frontend when i am checking the data for Transaction Typ…Rajendra.12 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…Ramsha Zameer 12 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…Alok5Kumar 12 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Table to get "Reference Type" in depletion layer?Summary: I am looking for a table that contains the "Reference Type" field in the depletion layer as in the screenshot below. thanks in advance! Content (please ensure y…Edgar11 3 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Privilege required to run "Generate Audit Report" ESS jobSummary: Privilege required to run "Generate Audit Report" ESS job Content Hi - would anyone be able to confirm how we can see which privilege is required to allow users…JimCC 88 views 4 comments 0 points Most recent by Marius Matei-Support-Oracle Fusion Applications Administration
-
Unable to see secondary ledger in FRS list of valuesWe have secondary ledger for Germany and Luxembourg, but the same are not available while selecting ledgers in FRS report.Hemanth Buccapatnam Tirumala 21 views 4 comments 1 point Most recent by Diksha0912 Reporting & Analytics for Fusion Service
-
Reports is showing different count between test and Prod data after P2TSummary: we run a report in test and in prod after p2t and we notice that there is a huge amount of data that is not showing in test, i though there is a difference betw…
-
Details about Signals to report User Logins via Redwood SalesSummary: We raised an SR before SR 4-0000908263 in which we reported that logins are not being saved for users. We are informed that the Subject area only tracks the log…Carlo Orolfo 32 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
sFTP credentials to be included in refreshSummary: Earlier in 2025, it was identified that sFTP credentials are no longer including in P2T refreshes. SR 4-0000092603 was raised and I was informed the present P2T…Rachel Phillips 13 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Create Data Model for Retrieving Custom FCL Field Values for Opportunity HistoryHello, I’m working on building a data model/SQL query in Oracle Sales Cloud OTBI to retrieve historical records for Opportunities, and I’ve run into a question regarding…
-
How to extract more than 65000 records per excel sheet with BIP ReportSummary: Hi, Using Excel template, we can get output in XLS, XML and CSV formats. With XLS, if we have more that 65K records, it will create multiple sheets. With CSV, w…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 32 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How to link MPA, GL, and Invoice distributions in one report without duplicates?Summary: Duplicate Records Due to Lack of Direct Link Between MPA and GL Tables in Invoice Accounting Report Content (please ensure you mask any confidential information…Dnyaneshwar B 32 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas…Jai.S.Chavan 11 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
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 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Adding Pending Approver to a ReportWe need to add the next approver to a Report. We are unable derive the next approver (to whom the requisition is not yet assigned for approval) for requisitions which ar…Eddie Zucker 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get the approval history for Claims?Hello. I am trying to build a custom report that would get the approval history for claims (approvers, latest date of submission, etc.). Does anyone have any idea on wha…missy_21 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…srikanth gollapally 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Error adding PVO to BICCHave SR open—no useful response yet so looking for other response. Error adding an existing PVO in BICC shows this error " [BIACM0185] Error saving data store due to [BI…JDC 34 views 3 comments 0 points Most recent by Mark Di Ponio Reporting & Analytics for Fusion Service
-
Connect to OAC via a REST serviceHello.I wanted to ask about a feature I need to create for my company.In this case, I need to download CSV files from OAC. I have some reports that were provided to me, …wilberth Canales Romero 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to enable drill-down for BIP reports.Summary: Need to enable drill-down feature for BIP report in oracle fusion cloud. Content (please ensure you mask any confidential information): We have created one regi…
-
PO PDF templateWe have created a custom PO PDF template for the customer The user is able to download any PO PDF when the document amount < = 999 $/Rs/Euro(Any currency) But for amount…Kinjal Patel-Oracle 41 views 2 comments 2 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service
-
How does the data get restored into a useable format so that reports can be generated?Hi Team, Could you please help with the following query. Client is running SaaS Fusion ERP, HCM, SCM, and a few others. Client is dissolving and going out of business Cl…Vbhat_19 41 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
External logging to Sumo Logic or SplunkHi, any guides how to configure our new Oracle ERP Fusion to forward its logs to an external logging SAAS like Splunk or Sumo Logic? Logs like who is logging on to our F…
-
Link Action in the Analytics ReportSummary: The Link Action is not returning the correct result. The URL is not working as expected in the defined parameters. The URL below is directing to another page as…
-
Rel 13.20B User Adoption – Object Activity and Resource System UsageContent User Adoption metrics help CRM stakeholders continuously measure the success of their CRM implementation. Using these metrics, CRM business leaders can obtain cr…Sudharshanan K B-Oracle 1.4K views 25 comments 21 points Most recent by Pavan Kumar Thummalapalli Reporting & Analytics for Sales
-
How to change column sorting in Express Report?Summary: How to change column sorting in Express Report? Content (please ensure you mask any confidential information): The output is always sorted by the first column/g…Chin Chi-Oracle 31 views 5 comments 0 points Most recent by Chin Chi-Oracle Reporting & Analytics for Sales