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
-
CRC 32 - Hash in Oracle fusionHello , We have one requirement where it has been asked to convert the 16 digits column value ( The site ID from Account Payable) into a CRC 32 HASH value. I did not fin… -
Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr… -
Delivery to SFTP completed with failureThis morning a job that send a file via SFTP was not able to send the file, due to the following error: Delivery failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=275301]…
-
Archive Option is Missing in Reports and Analytics to save the custom catalog before a refreshHi Everyone, We have a refresh scheduled for Monday and part of our preparation is to download our 'custom' folder catalog and save it incase we need any of the reports …
-
How to get what are all the Permissions assigned to the report for xdo file and xdm filesHow get what are all the Permissions assigned to the report for xdo file and xdm files through back end (sql script or rest services)
-
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context value
-
Where can i find Item Drawing Number in Oracle Fusion ERP tables ?I Am trying to search for "Drawing Number" in oracle fusion ERP tables, it might be an Attribute but I am not getting in which table I can find this attribute. Please re…
-
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 31 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…