Reporting and Analytics
Discussion List
-
SFTP connection is not workingWe are running a BIP report which has bursting SFTP using ESS job. The Job is failing with the below errors. Document delivery failed [INSTANCE_ID=bip.bi_server1] [DELIV…Radhika Sharma 9 views 0 comments 0 points Started by Radhika Sharma Fusion Applications Administration -
Need AP Invoice Review Report showing DetailsSummary: I am needing an AP Invoice Review Report that shows the vendor, invoice number with drill down, invoice line description, general ledger account, general ledger…
-
How to access fa_fusion_soainfra.wftask_sec , FA_FUSION_SOAINFRA.WFTASKHISTORY tables from fusionUnable to access fa_fusion_soainfra.wftask_sec , FA_FUSION_SOAINFRA.WFTASKHISTORY tables from fusion, Getting error as ORA-01031: insufficient privileges. Please let me …Thanigainathan R 22 views 4 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
What is the Vacation Delegation Table in fusionWhat is the Vacation Delegation Table in fusion and what is different between FA_FUSION_SOAINFRA.WFUserVacation and PER_DELEGATED_ROLES I am encountering an error (ORA-0…Mohamed Shaaban 41 views 3 comments 1 point Most recent by BK_Oracle-Oracle Fusion Applications Administration
-
User login/logoff and download historyWe need to determine if our Oracle HCM Cloud application has the ability to provide the following information for a user during a date range Login history (not just last…Rob Turner 22 views 2 comments 0 points Most recent by Rob Turner Fusion Applications Administration -
Generate an audit trail showing employee activity (runs and downloads) for specific BIP reportsHow can we generate an audit trail showing employee activity (runs and downloads) for specific BIP reports? To comply with auditing and security requirements, we need to…Mohamed Fathelrahman NM 2 views 1 comment 1 point Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Trying to run Person Profile and Talent Profile reports in Reports and Analytics but getting no dataWe are trying to run these 2 reports in reports and analytics but we are getting no data back. I tried the Person Profile Excel version as well but the excel is blank. I…Dapper Dandle 22 views 1 comment 1 point Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Sql to fetch payroll costing results accountWe are writing a BIP report to fetch Account details from the Costing Results. Is there any SQL that can get these details after the Payroll is run?JanardhanP 71 views 4 comments 0 points Most recent by Ankush Jadhav -Oracle Payroll and Global Payroll Interface (GPI)
-
Is the join operator ( ) deprecated in Oracle fusion SQLIs the join operator (+) deprecated in Oracle fusion SQL. Can we still use (+) in SQLs or shall we go with ANSI standard for eg: left outer join or Right outer joinSrinivas VRA 21 views 3 comments 0 points Most recent by Srinivas VRA Fusion Applications Administration
-
Need help in fixing the EL expression to handle customer names that include '&'.We have a custom field on the Order Management → Create Order screen that retrieves customer information from a BIP report using EL expressions, based on the customer na…Dineshkumar.A-Oracle 54 views 2 comments 1 point Most recent by User_50N5P Supply Chain Planning and Collaboration -
Not Being able to send the Output to a group mail id (DL/NG) white scheduling a report from BIPWhen i schedule a report from the report and analytics screen giving a DL (Distribution list) /NG in the destination mail id the output is not getting delivered . Did an…Sarath C P 13 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
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
-
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 -
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 -
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 81 views 4 comments 0 points Most recent by Marius Matei-Support-Oracle Fusion Applications Administration -
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
-
Unable to retrieve department and fund date in seeded payroll register report extract xml outputDue to the limitations of the seeded extract, we are currently unable to extract the department and fund information in xml output. We have already raised a Service Requ…AvinashSharma 11 views 0 comments 0 points Started by AvinashSharma Payroll and Global Payroll Interface (GPI)
-
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 33 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…
-
How is the ‘Result view’ generated when the same subject area is joined more than onceWhen I create an analysis and report in Oracle Fusion Cloud and include the same subject area more than once, I sometimes see a “Result view” appear as part of the union…Andrea Lopez 21 views 1 comment 2 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to remove Carriage Return in the CSV files generated by the BIPHello, This is in 25C. We are generating a CSV file out of a BIP report that has output like this. As we can see from the above, line #1,#2 and #3 are part of the questi…Darsh123 21 views 3 comments 0 points Most recent by James McBride Fusion Applications Administration
-
Internal Server Error while calling /biacm/rest/meta/export APISummary: We are encountering an Internal Server Error (500) while trying to get a response from the API endpoint /biacm/rest/meta/export. Has anyone faced a similar issu…PremC 11 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Looking for file path of Audit Report in Oracle FusionSummary: Hi All, We would like to customize "Generate Audit Report" the seeded report provided by Oracle, kindly help us with the report files path so that we can custom…
-
Can we add hyperlink for ESS jobs in fusionHello Everyone, We have a requirement to call the seeded ESS job: Print Packing Slip Report from Manage Work Orders UI. What is the syntax to add through Page Composer a…
-
Inquiry on Standard Report for Tracking Manually Released Invoices by UsersSummary: Is there a standard report available in Oracle Cloud OTBI/Scheduled Processes that tracks and reports invoices manually released by users within a specific peri…Temi A. 1 view 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
How to hide "Reports and Analytics" for a user.We have a requirement to create a custom role a specific user to run only programs using Scheduled Processes. But we are also seeing "Reports and Analytics" even without…Sadanand Gunda 61 views 5 comments 0 points Most recent by James McBride Fusion Applications Administration
-
Documents required for integration of fusion Audit log with SPLUNK.Summary: We are trying to integrate Audit and Admin user activity logs to a log monitoring tool call as SPLUNK. Help us with some documents around the integration is the…Poonam Yadav 31 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Fusion Application Performance MonitoringSummary: We have an initiative and plan to run approximately 40 BIP scheduled reports concurrently, and we wanted to assess any potential impact this could have on the u…JEngalan 22 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Req Approaval TaskWe need to extract data about ReqApproval task configuration for audit purposes. Since there is no schedule process for that, we need to manually prepare the query. We c…Rajinder Singh 21 views 4 comments 0 points Most recent by Rajinder Singh Fusion Applications Administration
-
Tables for BI Consumer role, BI Administrator Role, BI consumer role in oracle fusion HCMSummary: Hi All, I need a table name or query for BI Consumer role, BI Administrator Role, BI Author role in oracle fusion HCM. Need to write a SQL query like, who have …Karthikeyan s-Oracle 111 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM