Popular Tags
- Reporting 1,300
- OTBI 1,221
- Analysis and Data Visualization 800
- BI Publisher 683
- FDI 660
- Analysis 623
- Administration 503
- Oracle Fusion Analytics 474
- OBIEE 391
- BI Publisher Data Models 285
- Answers 253
- Analyses 247
- Developers 230
- Analytics 198
- Data Connectivity 196
- Security 195
- HCM 186
- Data Modelling and Datasets 186
- Report Output 165
- ERP Analytics Content 157
- BIP 149
- Agents 146
- BI Publisher Report Templates 140
- Packaging and Licensing 128
- Home and Catalog 123
Report
Discussion List
-
I need to Employee Signed Date and Manager Signed Date from the position description documenti need a SQL query to fetch the Employee digitally Signed Date and Managers digitally Signed Date from position description Document which is attached in DOR. Please let… -
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base…Amulya Kadiyala 19 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Why does the subject area 'Sales - CRM Customers' is not showing results promptly?Maybe you can help me identify the reason why the subject area for accounts is so slow at showing results. Or is it better to create a custom subject area?Ivony Ann Paula Salango 31 views 5 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Excel is not considering my date value as date even after I tried many formatting? Need suggestionI am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel…
-
What is the difference between Refresh Data and Reload Data within the functional areas?I would like to know the difference between these two options within the functional areas, because we made an update in the financial categories of the accounts but the …SERGIO BARRETO 26 views 1 comment 1 point Most recent by Sumanth V -Oracle Oracle Fusion ERP Analytics
-
Can you reference other parameters in the initial value's logical SQL?For our projects report, we'd like to create a project manager parameter where we set the the project manage equal to the display name so that when project managers acce…Caroline Blanchard 41 views 5 comments 1 point Most recent by David Saggioro Oracle Fusion Data Intelligence -
2Not able to calculate aggregated amounts for 'Discount' Column in Purchase Order Line Detail FolderWe have a requirement to generate reports in FDI that display the following metrics for Purchase Orders (POs): PO amount before discount Discount amount PO amount after …
-
Bursting ReportHi everyone, I need your help regarding bursting report. I created two Data models G_1 and G_2. In G_1, The query fetches the list of employees whose probation is about …
-
Try to find in which table I can find Default Expense Account discerptionHello everyone, I am working in BI Report and I am trying to find Default Expense Account discerption. I found the code but I could not find the discretions. the code fo…Khalid Aldosari-Oracle 17 views 5 comments 0 points Most recent by Gianni Ceresa Oracle Transactional Business Intelligence
-
recruiting - recruiting real time Candidate AttachementHi Experts, I'm trying to fetch candidate attachment files/URLs by using this recruiting - recruiting real time OTBI. Unfortunately, I can't see any attachment files or …Saher 12 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Custom report to monitor login activityLeadership would like a custom report to monitor login activity. We'd like to know which users logged in last week and which application/function they used. Sample outpu…SusanSandifer 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence -
Pulling Employee Balance Result value in Person Result.Hi Experts, I have a report requirement that needs to pull the value from 'Person Result > Calculate Quickpay > Balance Result > Value'. Is there any sample query that I…
-
Prevent merged rows in xpt template when there are line breaksSummary: I run into a problem when generating a report where a field contains line breaks. The row expands to the number of line breaks present in the field. I can't fin…Edisson Gabriel López 57 views 1 comment 1 point Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Hiring manager and recruiter's full names not displayed in anaylsisHello experts, we are creating an otbi analysis with the following info: job req number, hiring manager’s and recruiter’s full names. However these last 2 info appear fr…Oriana L. 46 views 4 comments 0 points Most recent by Oriana L. Oracle Transactional Business Intelligence
-
2To include audit or update information in the saved customization report in OTBIUser cases: There are multiple users encountering deleted saved customization report in OTBI and it happens intermittently every year. Description of need: To have an au…
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeHi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area : Procure…Deepak Bhatt 13 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Combining Recruiting - Recruiting Real Time and Recruiting - Recruiting Event Real TimeHi All, I have created a report using 'Recruiting - Recruiting Real Time' and one of the column Rejection/Withdrawal Reason("Recruiting - Recruiting Events Real Time"."J…Robinson Ng 63 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Transactional Business Intelligence
-
Is there a cost report which end user can query for FAW infrastructure costs?Is there a cost report which end user can query for FAW infrastructure costs in OCI or maybe through another way?Tareena 3 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence
-
4Scaling settings to show chart value numbers as it is instead of rounding it up to Thousands (K)Hello everyone, I am using Oracle PLM Cloud Version 24A (11.12.24.01.0) And I am creating a data model with FSCM Database source and then I am creating report template o…User_P3QO5 22 views 0 comments 4 points Started by User_P3QO5 Oracle Analytics Cloud and Server Idea Lab -
max aggregate function returning multiple rows when used in Analysis toolHello I work in a Windows environment and I am using Oracle HCM Analysis tool to alter a benefits report to only show the latest benefit by date. I am using the 'Benefit…Robin Olsen 12 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Fusion Data Intelligence