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.
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Reporting & Analytics for Fusion Service
Discussion List
-
Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil… -
Is there way we can get the "Import Asset and Assignments Process" import errors detailswhen we run the "Import Asset and Assignments Process" to import the Capital assets the load interface file import success and errored at import job and we are trying to…
-
Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…
-
How to map interfaces and database tablesSummary: How can I find which database tables (in BIP) are used in Fusion Web Interface Content (please ensure you mask any confidential information): Version (include t…
-
OTBI Report - Effective Start Date UnionI am creating an OTBI report to extract Union member, Union of the employees and the date from which the employee joined the union. I am using the following subject area…
-
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…
-
Please let us know, can we use excel template with xlsx extension for getting outputs in BIPPlease let us know, can we use excel template with xlsx extension for getting outputs in BIP
-
BI Publisher Report Issue -"Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df."Dear experts, In some of the Data Model (Fusion SaaS) , I am below error when I open the datamodel. "Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df." Also I… -
DFF values not appearing in OTBIHow do you get a DFF LOV results values to appear in OTBI reports and analytics? Seems as though I am able to return every value and DFF results value field into the rep…
-
recruiting events analyticsHello, I would like to have some analytics or dashboards for metrics regarding recruiting events and campaigns in Recruiting. Is there any predefined dashboard, or a way…
-
Report Analysis adding multiple subject areas (more than 2) errorHi there, we have a scenario where we have added a new subject area to an existing report that is already set up with the Dimensionality flag, so one would assume adding…
-
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
How to use event triggers to send a reportI created a report in OTBI that returns urgent requisitions that were not processed by the buyer, but I would like to send this report to the buyer when an urgent line r… -
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…
-
Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web…
-
E-stamp & signature for Standard Reportshello, I need a solution to put E-stamp and Signature on standard and customized reports , for example Payslip report
-
Support for Bank's Latest CiphersSummary: Support for Bank's Latest Ciphers Content (please ensure you mask any confidential information): I recently received an email from Bank regarding an update to t…
-
How to show Average First Response Time and Average Handling Time on a graph for Service RequestsSummary: We have a detail report by service request that uses certain calculations to take into account the number of hours worked a day by CS. We have the following wor…
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…
-
Can I use output from one BI report as input to another BI report?Summary: Content (required): I know that I can create multiple templates for my output, but that would require me to run the data model again. I'm looking for a way to p…
-
Organization name need to be replaced with department name.Summary: Hi All, Can some one help me on changing the Organization name instead of Department name in below query Content (required): In the query its is fetching old or… -
Looking for sql to find day/timestamp of employee's policy acknowledgmentI am looking for the table(s) to find the signature day/timestamp for a policy that was 'signed' during an onboarding journey. I started in PER_ALLOCATED_TASKS - is that…
-
Need to Stop Showing Business Unit Code in Report HeaderHi All, I have created Report using Oracle FRS and in the report output i need to stop appearing this BU code. Please Advice -
A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…
-
SQL to get employees and their dependents enrolled in a benefit planLooking for "SQL to get employees and their dependents enrolled in a benefit plan" to build BIP Report. -
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, Nagendra
-
What is the table that stores error records for Depreciation Override of Asset using ADFDI?Hi All, We are using ADFDI to Override the depreciation of Asset. After importing the records we need to generate the error report for failed records. Which table stores…
-
We need to download the report for the audit purposeSummary: We need to download the report for the audit purpose. System changes log Authorization change log; add modify, delete. From where we can get this detailed repor…