Reports
Discussion List
-
While the ESS job names are visible in the ui, they are only partially displayed in the BIP ReportSummary: While the ESS job names are visible in the user interface, they are only partially displayed in the BIP Report, with approximately 50% of the job name informati… -
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty…Challa Vidyasagar 295 views 3 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM -
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >…
-
how to add two sum rows in a single pdf page for two accounts - in PBCS/EPBCSHi Folks, When we select parent hierarchy for account, we will get two or more accounts in the rows for a report. earlier we have SUM for all the accounts which will be …
-
OTBI Data Discrepancy for "Performed Action" Approve in Procurement - Requisitions Real TimeSummary: Hi Community, I'm encountering an issue in OTBI (Oracle Transactional Business Intelligence) when retrieving data from the Subject Area: Procurement - Requisiti…
-
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…
-
Connect Two Subject Areas Without Common Attribute or Dimension in OTBI (Answers Report)Hello experts, I need assistance with connecting data from two different subject areas for a report in OTBI: Receivables - Transactions Real Time Subscription Management…Valerij Astafev 31 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
How to reference another cell for a formulaSummary: I have an excel report that I need to re-create and there is a column that is essentially, (Parts Cost Budget/Revenue)* Actual revenue But when I create a formu…
-
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In…User_2025-02-04-08-51-08-912 55 views 2 comments 0 points Most recent by Saisandeep Nutheti Reporting and Analytics for HCM -
Need SQL Query for Project Custom ReportSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task …Awal 63 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
What is the Retention policy for BIP Jobs run in Fusion ERP Cloud?Summary: What is the Retention policy for BIP Jobs run in Fusion ERP Cloud? Do we have more information on maximum value/minimum value for retention? Also Is there a cos…Abhilash K - Deloitte USI 15 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Pivot Table in OTBI Not Displaying Response Value DataSummary: Where I need to transform data from a vertical format to a horizontal format using a pivot table. My original data looks like this: Buyer Name Question Name Sup…Warunyu.N34 33 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …Manuel Riobóo Córdoba 31 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Keyboard Accessibility Tab Order in Oracle Analytics Cloud Fusion Data IntelligenceIs it possible to set a tab order for a Keyboard Accessibility requirement in Oracle Analytics Cloud part of Fusion Data Intelligence? It currently take 30 tabs to get t…Yagnesh_Analytics 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Enter prompt variable in SOAP executeXMLQuery requestSummary: We have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report…Nick H 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create and submit BIP reports by batch (request set)Summary: How to create and submit BIP reports by batch (request set) Content (please ensure you mask any confidential information): There is a client requirement to run …Babasaheb Bhujbal 24 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Need to generate and include a sequence number in custom BI publisher eText template for non paymentSummary: Need to generate and include a sequence number in custom BI publisher eText template for non payment Content (please ensure you mask any confidential informatio…Ishtiaque AHmed 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…Sankhya 21 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to create deep link for Items in Product Information Management module?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…S Javir 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Applying filter to report attribute but keep the rank as unfiltered.I am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes. Is there a way I can apply filter on an attri…Raghu_Nandan 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Artifact Updates Report do not reflect monthly updatesThere was an error rendering this rich post.Dj1987 41 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Migrated financial reports from reporting web studio to reports and we are encountering errorsSummary: We migrated financial reports from reporting web studio to reports and we are encountering the following errors in each report: "The text object "Text2" uses Fo…User_LY017 31 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Function in FRS Webstudio report to go back on GL Average Daliy Balance Cube on an exact dateOur client wants to run Daily P&L built on GL Average Balance Cube using FRS and compare current date PATD balance to same day PATD balance for last month. This is also …
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…Ridma Karunanathan 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
admin is unable to see contents in user foldersSummary: In the past we have been able to see the contents in a users folder when in Admin view. Now we can no longer see the files. Has anyone else experienced this iss…
-
EPM Automate Compare Snapshot report not returning results when snaphots are differentSummary: Its running ok but the report is saying there are no differences. Getting this to work would make our audit/controls process a little less onerous as it would a…Jeremy Stubbs 51 views 10 comments 0 points Most recent by Kedarnath Amidalamatam Financial Consolidation and Close -
Lease Options tableSummary: What FLA table contains Lease Options? https://docs.oracle.com/en/cloud/saas/financials/25a/faula/create-options.html Content (please ensure you mask any confid…
-
Deep Link Issue in Oracle Lease Accounting moduleHello, I am reaching out to raise an issue regarding the deep links in Lease Accounting module as we are facing with the issue of Lease accounting deep link is not avail…