To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
Discussion List
-
interactive output format query parameters are not working when new fields are addedhi all, I have a BI report which i have built with the report out put format as interactive. this report has two input query parameters. i have recently add two new attr… -
Is it possible to track BIP report logs where user has not submitted a report jobSummary: A user logs in to Report & Analytics and opens any custom BIP report to view/export output, without submitting a report job. We are looking to get table/report …
-
Sp HTTP 500/504 errors when using SOAP API in using BI PublisherSummary: My team makes calls every 30 minutes to BI Publisher through a SOAP API to retrieve information we need to update tables on an on prem database. We are making t…
-
Extract data from Oracle Fusion via BI Publisher to perform calculations and then load them into EPMHello! I have some Oracle Fusion data in BI Publisher. I need to use this data as a basis for performing some calculations and then load the calculated information into …
-
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?
-
FDI Report AccessHi, I am currently unable to see any workbooks in the FDI environment but a different user is able to for the same environment. What would I need to change for my accoun…
-
NoHttpResponseException/time out error using the web service ExternalReportWSSServiceSummary: We are trying to run a BI report using ExternalReportWSSService and it is frequently timing out/giving NoHttpResponseException. The BI report takes between 2 to…
-
In which table the details entered while converting the pending worker to employee manually storedWhile converting pending worker manually, we are editing the details of the pending worker and submitting, then it is in approval state. Before getting approved, is the …
-
Possibility to combine multiple rows into one cell in Oracle SQL data base.Summary: I have a query regarding the possibility to combine multiple rows into one cell in Oracle SQL data base. We have tried STRING_AGG, LISTAGG and WM_CONCAT, but no… -
How can we enable audit in Fusion BIP layer to track who executed what query and when?As we do not have any way to restrict a user with Reporting and analytics access in Oracle Fusion to view data of certain tables. Hence, we're looking to explore the aud…
-
How to restrict user to create/edit an OTBI AnalysisSummary: Need to assign access to the users only to create/edit OTBI Analysis without giving the access to DM and Reports Content (please ensure you mask any confidentia…
-
Portuguese language conversionHi, We have a requirement to convert Receipt amount in words to PORTUGUESE language. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, …
-
Can we build a BIP report for the child processesCan we build a BIP report for the child processes that are run after after load interface file for import.
-
ESS API to submit job or retrieve job output in non-default formatI am looking for a way to retreive a non-default formatted output for an ESS job through an API. I need to submit the actual parent ESS job that runs the BI report for t…
-
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …
-
Need PVO's for below Tables for BICC ExtractSummary: Need PVO's for below mentioned tables for BICC Extract: 1) gl_coa_tree_versions_aggr_dtls 2) hr_operating_units 3) gl_seg_val_hier_rfNiharika Paramkusam-Oracle 32 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle
-
How to add Header and footer in Each group of E-text Template ?I have e-text fixed base position template in which I want to add header and footer in each group of template. I made variable in SQL query but my requirement is not ful…
-
Can we create custom folder in UCMHi Team, Can we create custom folder on UCM.
-
Not able to print parameter values in BIP report, using if condition in Excel rtf templateUsing if condition in excel template had validated values if parameter is null , should return all as values selected is ALL, see below All But when i am populating spec…
-
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.
-
Query or tables Details on LDAP User and Policy Stripe ColumnsSummary: Could you please provide me with the table names or the queries related to the following two columns: LDAP User Policy Stripea Content (please ensure you mask a…
-
Which table contains Credit Management, Credit scoring model detailsCould you please provide the name of the backend table where the details of credit collection data points, such as category, data point name, DataPointId, data type, and…
-
how to convert Universal time to CDT timeSummary: PROCESSSTART is displaying as 2024-06-06T06:03:22.173+00:00 (Universal time) in table fusion.ess_request_history. Could you please Help how to convert Universal…
-
Data flow in fusion.ess_request_history table while Running the BIP Report which was scheduled.Below are values populated in fusion.ess_request_history table while Running the BIP Report which was scheduled. state value is 3(Running),processend is NULL value and E…
-
Purchase Order PDF Report with conditional sub templateSummary: We have a requirement for one business unit to issue 4 completely different purchase order PDF's based on shiptolocationname. We have the sub template working w…
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …
-
How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…
-
data is not populating in fusion.ess_request_history if we run the BIP report manuallydata is populating in fusion.ess_request_history for only scheduled reports data is not populating in fusion.ess_request_history if we run the BIP report manually Step1)…
-
how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…
-
I need Time Elapsed from Report run History in Fusion HCMI ran the report in Fusion HCM I need to know how much time taken to complete the report Is there any way to know how any records in report out put https://us.v-cdn.net/…