Reporting and Analytics
Discussion List
-
Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per… -
BI Report Pulled Into a Dashboard Displays the Parameters in TEST Environment but not PRODIn our Production environment I pulled a report into a dashboard and I can’t view the report parameters when I open the dashboard. However, when I create this report and… -
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 90 views 1 comment 1 point Most recent by Rakesh_Kumar_Sahu Reporting & Analytics for Fusion Service -
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…MaheshRayudu7 2 views 1 comment 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM -
How to get all the tables used in “Inactive Users Report" ESS job in Oracle Fusion CloudHow to get all the tables used in “Inactive Users Report" ESS job in Oracle Fusion Cloud.Nivrutti Tangde 17 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Workforce Management -
Send a Document of record as attachment through OTBI analysis output via emailDear All, We want to send by mail the output of an OTBI Analysis we have, but we need to send with it an attached file. The file that we need will be the CV of an employ… -
Schedule User and Role Access Audit Report with output destination as emailHi Team, We want to schedule "User and Role Access Audit Report" and its output file to be emailed to IT team email id. Currently, we are able to schedule report but una…Anupam Rana-Oracle 23 views 3 comments 0 points Most recent by Anupam Rana-Oracle Reporting & Analytics for Fusion Service -
Parameters and lists of Value in the analysis are not inherited into the BI Publisher Data ModelHi, Expert I encountered the case that I developed an Analysis and Prompts within it. Subsequently, I built a new Data Model, designating the Analysis as the dataset, bu…ICE Pratchapon 63 views 1 comment 0 points Most recent by ICE Pratchapon Reporting and Analytics for HCM -
Is there a report available for all transaction across all module for leadership prospective ?I am looking for a report available in Oracle Fusion for all transactional across all module for our leadership review ? For e.g. ESS and MSS links , how many time speci…Devesh Shah 22 views 8 comments 0 points Most recent by Devesh Shah Reporting & Analytics for Fusion Service -
ERROR CODE OAMP2OPY:OPR4ONWYI am attaching the screenshot of an error - How to debug it? What could be the issue? Please help.Neelotpal01 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj…Curtis Allen 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Requisition Email Approval templateI am currently working on updating the custom requisition email approval template. As part of the testing process, I have enabled the BIP_CLIENT_REFRESH_TME profile opti… -
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 35 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Getting error 401- Unauthorized error while calling WebService from Oracle Fusion BIPWhen we are calling Webservice from Oracle Fusion BIP , OIC is triggered but going into error 401- Unauthorized, however we are using the same User Name in OIC and BIP b…Hitesh Jasuja-Oracle 64 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
I have build the report using service request object with custom subject area but getting error.Summary: I have build the report using service request object with custom subject area and trying to map the reference number to SR number (custom object custom field) b…Manjula Bellamkonda-Oracle 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
PVO that has attribute columns in per_location_details_fSummary: We are on FDI 25.2—looking for a PVO which has the attribute columns in the per_location_details_f table in Fusion. Content (please ensure you mask any confiden… -
Missing Data Repsonse using soap UIcould you please check this payload--> csv …Anjali Kumari Gupta 11 views 1 comment 0 points Most recent by Anjali Kumari Gupta Reporting and Analytics for ERP -
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 52 views 3 comments 3 points Most recent by Umar Reporting & Analytics for Fusion Service -
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 15 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM -
How to determine the correct PVO to use for data augmentationSummary: Attempting to create a data augmentation for the Fusion Data Intelligence package to include an Accounting date from the Fusion ERP environment. We are needing …jstruth 13 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP -
Multiple Delivery By options in Oracle BI ReportSummary: Hi All, I have developed Oracle BI report in fusion, facing an below issue - I have 4 data sets A,B,C,D and joined A-B and A-C-D, included KEY in all the datase…Avilash1265 2 views 1 comment 0 points Most recent by Raghavan p-Oracle BI Publisher Learning Center -
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…Opkey PA 80 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service -
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
BICC external storageSummary: We have to send bicc files to external storage allocated in a s3 site. wich kind of serviceName i'll request from my aws technician to make bicc get container n… -
Need a SQL of employees who are missing costing details on the person/ assignment costing.Employee who are missing costing detailsSARAORC 12 views 1 comment 0 points Most recent by VIKURAMA-Oracle Payroll and Global Payroll Interface (GPI) -
Why is country code "CZ" missing in fusion.psc_com_country_bSummary: Why is country code "CZ" missing in fusion.psc_com_country_b to convert country codes between ISO 3166-1 alpha-2 and ISO 3166-1 alpha-3 or ISO 3166-1 numeric. C… -
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 13 views 0 comments 0 points Started by Karthik Chedella Reporting and Analytics for SCM -
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 164 views 3 comments 1 point Most recent by Erick.B Reporting & Analytics for Fusion Service -
What is the BICC PVO for FND_VS_VALUES_B Fusion table that has the attribute values?We are on FDI 25.2. I have found some PVOS like FscmTopModelAM.AnalyticsServiceAM.ValueSetTypedValuesPVO in BICC that map back to the valueset/code data in Fusion data b… -
In Cloud Fusion need ability to audit changes in the admin profile optionsI need the information whether it is the correct Oracle doc or just an answer on how to enable and then report on how to report on any changes made using manage admin pr…Mike P 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service