Reports
Discussion List
-
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 21 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM -
BI Report Logo not displaying when exporting report to MS WordSummary: BI Report Logo not displaying when exporting report to MS Word. Content (please ensure you mask any confidential information): I have created a BI report. I use…IanDeKoker 51 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM -
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Employment Terms Assignment Number in OTBI Report AnalysisHow do you retrieve Employment Terms Assignment number format? into an OTBI Report Analysis in the format needed for use in spreadsheet loader template?
-
I am having trouble adding Job Code, Job Title, and Department to this Address Change ReportSummary: Hello, I need to add Job Code, Job Title, Department and HR Status to this report and I am having trouble doing so. My current code is attached. Any suggestions…
-
Static URL is not working on page entry under sandbox for navigation to BI custom folderOn Springboard we have created NIB Custom Report tab under we have created icon to navigate to BI catalog to custom folder. When we click on Global HR folder for the fir…Anjali_Jaiswal 102 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
OTBI Analyses erroring due to "Termination" columns - View Display ErrorSummary: Since the 24A upgrade was installed, we have (at least) two analyses that are now erroring out. They worked perfectly before the upgrade, but now they throw a V… -
Can I make a leaver report as a graph showing reasons of termination?Summary: I have made a leaver graph in excel showing leaver reasons by month and have tried to recreate in Oracle, the leaver reasons are appearing, but not the correct …Matthew Gooch 21 views 4 comments 0 points Most recent by Matthew Gooch Reporting and Analytics for HCM -
Just went live and delivered reports don't return data. Need help troubleshooting Absence Calendar.Summary: I am brand new to Oracle and trying to figure out why we're not seeing data in the delivered reports. The one I'm working on now is the Absence Calendar. I've r…Dana Lockwood 51 views 8 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM
-
OTBI Dashboard we getting below error ?Summary: Hi Team, we have custom old dashoard but when we run the we getting below error. May I know what is the error and how can I rectify the issue! Thanks, Ajay Cont…AjayKumar Maddipati 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 21 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Bi Publisher. How do you show parameter values used for the reportSummary: We would like to show on the BI Publisher report output the parameter values used to create the report. Can anyone help with this please. Thank you. Content (pl…Kevin Robertson 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 31 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…Nishu_Kumari 41 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Manager not able to see the anything in reportHi Everyone, I have created 2 reports and deployed it for the Line managers to be able to run and self serve but when they run they cant see the results. Details of the …Girish Bhatia 31 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Creating a book of report booksSummary: Is it possible to run several report books in one go - i.e. to have a "book of books"? Content (please ensure you mask any confidential information): We have be…Erringc 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
How to build outlier graph as attachedSummary: We are trying to build a outlier graph as attached, Please help how we can build the same Content (please ensure you mask any confidential information): outlier…Deendayal Gupta 31 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
HCM Extract to compress multiple reports in a Single Zip FileSummary: I'm loading Job Requisition Template Description. For this I combined ClobFiles and JobRequisitionTempalte.dat into .zip file manually, i 'm able to load data ,…
-
Security and OTBI AgentsSummary: Hello everyone! I've just started at a new company and have found out that internal policies mean we cannot use OTBI Agents at all (even to send reports without…
-
The custom report spacing is not aligned in PDF and Word formatSummary: A custom report is built for the contract purpose. With the PDF version, the format and the spacing are accepted by the UAT. When the report is generated in a W…
-
Length of Service calculation OTBISummary Calculation of LOS based on either Current Date or Termination Date for former employees.Content I am looking to calculate an individual's length of service base…Stephen Prentice 616 views 8 comments 0 points Most recent by Rahul K-Oracle Reporting and Analytics for HCM
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 1 view 1 comment 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Last Standard Process date column in payroll reportHi There, Hope you are good! I m looking for creating report with last standard process date for terminated employees in order to run HSDL for final close for these term…Priya1 11 views 2 comments 0 points Most recent by Raju Sandepogu-Oracle Payroll and Global Payroll Interface (GPI)
-
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
opening of Outlook and send mail for rejection of performance assessmentsHi code is written so that mail is sent for rejection of assessments. when we click it will redirect to outlook. mailto:fusion_notifications@XXXX.com?subject=%20Reject%2…Shanmukhi 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Inbound Integration HCM Extract - Zero RecordsSummary: Hi All, I face a unique scenario where my HCM Extract may not always generate HDL Data records to be loaded to HCM Data Loader. Due to this, a blank .zip file g…VinayDama 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
BI Report job success but email not deliveredHi, We have come across an issue with one of our bursting reports wherein the Report job is showing as Success, but the email is not being delivered. Can someone help wi…Praneeth K 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM