Reporting and Analytics
Discussion List
-
Labor Costing Overrides and Manage Rate Schedule BICC Extract PVOs NeededI am trying to extract Manage Labor Costing Overrides and Manage Rate Schedules Data through Oracle Fusion BICC PVOs. I am unable to find the exact PVOs for this data. P…SAI KRISHNA SANGEM 21 views 2 comments 0 points Most recent by SAI KRISHNA SANGEM Fusion Applications Administration -
What is this report symbol meaning?Please help me to understand what is this symbol on left of a report name. Regards, MeeraMeera Saseendran T 11 views 3 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
where is almacenes all my data generated in fusion applications?My question is, how can I access all the data generated in my Fusion applications? I want to replicate my OAC instance in Power BI. I have an ADB instance, and I've conn…Víctor Nuno 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How to hide Custom ESS Jobs from the end userSummary: We need to build a solution where we can hide the custom ESS Jobs created for running the integration reports. These jobs should only be accessible to the user …Kunwar Prashan Srivastava 82 views 7 comments 0 points Most recent by User_N4K98 Fusion Applications Administration -
tax invoice print amount in wordstax invoice print amount in words in below the one lakh is showing Forty-One Thousand Nine Hundred Ninety Rupees And Forty Paise***** and above the Two Hundred Seventy-F…
-
Any way to use regex in OTBI?Summary: Is there a way to leverage regex in OTBI in some manner? I have seen methods to leverage it in OBIEE with the following syntax: EVALUATE('regexp_replace("Activi…
-
Change "from" address and seeing recipents on scheduled reportsContent Hi Gurus, I have two questions in schedule report Can we change the from address for the schedule report? Can we see the list of recipient email address in the t…Mohana Gopal S-Oracle 52 views 7 comments 0 points Most recent by Santosh kumar purusottam Reporting & Analytics for B2C Service -
How to extract holiday list ?Hi, Is there any way, we can export holiday list of each SLA? Regards, MeeraMeera Saseendran T 41 views 1 comment 0 points Most recent by George Caragicu-Oracle Reporting & Analytics for B2C Service
-
OTBI Report to pull Opportunity details with team membersSummary: Need an OTBI report on Opportunity and associated team members Content (please ensure you mask any confidential information): How to expose Opty team members de…S.Kumar 73 views 6 comments 0 points Most recent by AMIT KUMAR YADAV Reporting & Analytics for Sales
-
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 162 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM
-
ORA-01427: single-row subquery returns more than one rowSummary: Hi All, We encountered the below error in a specific report DM both while running the report and within the DM itself. After identifying and resolving the issue…Abhijit N 34 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Video: Adding an Express Report to the Sales DashboardAdding an Express Report to the Sales Dashboard From the Express Reporting series https://videohub.oracle.com/embed/secure/iframe/entryId/1_hdg0pttk/uiConfId/35965902 -
The report prompt doesn’t appear on the same page when I apply the report filter.Summary: We created a report-level prompt, not a dashboard prompt. We need the prompt and the report to remain on the same page, but when we apply the prompt filter, the…Kanne Ramu 21 views 1 comment 0 points Most recent by RVohra Reporting & Analytics for Fusion Service
-
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 11 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 21 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 31 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 11 views 1 comment 1 point 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 2 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 112 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 31 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 11 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 33 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