General Transactional Reporting (OTBI)
Discussion List
-
Reports performance issueSummary: Report ending up with exception "oracle.xdo.template.ProcessCancelledException: FOBlock was cancelled after 0 seconds" Content (required): How to improve report… -
Workforce Management - Checklist Real Time doesn't contain Pending WorkersSummary: I need to report on those colleagues who haven't completed a certain checklist task prior to employment which would mean reporting on Pending workers. However a…
-
Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d…
-
BIP - How to pivot to display questions horizontally as the heading using answers instead of measureSummary: BIP - How to pivot to display questions horizontally as the heading using answers instead of measures, displaying respondents as the first column Content (requi… -
Changing date format to remove comma - OTBI ReportSummary: Been working on an Absence Calendar for a Dashboard and the prompt for Year dislays as '202,0'. Is there a way to change the format so it displays as '2020'. Co… -
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…
-
Subject Area for Area of Responsibilities (AOR)Summary: I am looking to see if it is possible to build a custom Subject Area for the AOR I know that the AOR doesn't already exist in the Subject Areas but we have many…
-
How to remove value from Dashboard PromptsI have created a Dashboard along with Prompts. I have taken business unit name as Prompt but it is pulling business unit ID and i am trying to remove it but I am facing …
-
Multiple Subject AreasSummary Report fails when adding fields from two different subject areasContent I am pulling fields starting from the Workforce Management - Worker Assignment Event Real… -
Communities in LearnSummary: Hi, I am working on LEARN report. I have to pull 'communities' field into my analysis can anyone provide me the specific Subject area and field name through whi…
-
Access denied error when user is Saving Current Customization of a DashboardSummary Access denied error when user is Saving Current Customization of a DashboardContent Hi All, we are facing a situation where when user is trying to save current c… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…
-
Fusion Dashboard AuditSummary: Fusion Dashboard Audit Content (required): Hi Team, We have requirement to extract the list of HCM dashboard name, dashboard path and how may user has ran the d…
-
How to export all rows at one go in OTBI DashboardsSummary: Hi, We have Dashboard created with OTBI Report , when we export data by OTBI report 1440 records are exported. But when we export by Dashboard only 13 rows are …
-
Missing fields in Subject Area Workforce Management - Worker Assignment Real Time?Summary: While attempting to add a field to the query, I found that I can't locate a couple of other fields that are already on the query Content (required): I am trying…
-
How to create a report containing past, current and future approvers of purchase requisitions?Summary: I would like to create a report with the summarized version of Purchase Requisition's Action Detail that contains all the stages and participants/approvers from…
-
Need to find where the Certificate Number is in the Subject AreaSummary: Need to retrieve the Certificate Number under Licenses and Certifications for an employee "- All Profile Content"."Content Type" = 'Licenses and Certifications'…
-
Return in Dashboard is not returning to previous page rather it is returning to main page. Any idea?Summary: Return in Dashboard is not returning to previous page rather it is returning to main page. Any idea ? Content (required): from main page we drill down to second…
-
Invoice number as a hyperlinkSummary Invoice number as a hyperlinkContent Dears, the attached is OTBI report showing invoices status Unpaid or Partily paid. My question is : How I can make the invoi… -
OTBI REPORTING CAPABILITYContent Can we do all sort of reporting with otbi or do we need bi publisher for customizable reporting
-
Am I the only one who finds bursting to be extremely frustrating and arcane?Summary I need a working sample - please helpContent I have been scouring Oracle forums for a week to find working samples. I have tried following the arcane instruction…
-
Pivot table in BI PublisherSummary Can't change Formula value to 'No Formula'Content Hello guys, I am struggling to change the function of measure section of my pivot table in BI Publisher. In OTB… -
Suppressing measures with OTBI report does not workSummary Any way to suppress measures while reporting with OTBI?Content I have a requirement to report the Purchase Orders and the related vendors invoices in Procurement…
-
OTBI Report Date Format changes when exporting to ExcelContent We are trying to change the formatting of a column in OTBI report by changing the column properties of each date columns. We are using the following format: Date…
-
Consolidate MultiList values into single fieldSummary We need to be able to see all of the multi list values against a sku in a single fieldContent We have several MultiList fields in our sku attributes. When report…
-
Issues in creating dynamic hyperlink and passing parameter from BI Publisher RTF templateSummary BI report parameterContent Hi, Would like to pass parameter from BI publisher report to another BI report using hyperlink. the parameter is called "parc" in the …
-
OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleSummary OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleContent Hi, OTBI Analysis Prompts NOT SEEN when I run the report in supply ch…
-
OTBI Payroll Distribution reportSummary Need a model for a employee-level payroll distribution report for a range of periods.Content Has anyone developed an OTBI model for employee-level payroll distri… -
Run an analysis (agent) as target user, but deliver to proxy userContent We have some sensitive data which are automatically shielded off through HR roles in the BI Catalog because they are obiee analysis in hcm subject areas. We have… -
How to fix an RTF report related error in OBIEESummary In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the errorContent Hello Oracle Team, In OBIEE, w…