Reports
Discussion List
-
How to create a report with full and part time EMP count as per department ?I have created a headcount report with basic employee info. I want to modify it such that it has Emp ID, Dept ID, Full time & Part Time Empl count. Basically I am lookin…Trupti Khodke 11 views 2 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM -
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 142 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …theachiever_07 131 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center -
Report Job HistorySummary Report job history only goes back 9 months from current dateContent Hi, After a query from an end user in HR we've noticed that the report job history only seems…
-
How to add a count column for employees aligned to a job in OTBI.Summary: I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job…
-
Extracting ORC Responsibilities and Qualification in Custom ExtractSummary: Extracting ORC Responsibilities and Qualification in Custom Extract Content (please ensure you mask any confidential information): Hi Team, Greetings! This ques… -
In which table does the Candidate Selection Process Code field is storedSummary: I'm trying to fetch the Candidate Selection Process code, but couldn't figure it out where this field is stored. Content (please ensure you mask any confidentia…Sujeeth Chinta 782 views 3 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
Draft water mark is missing in the draft fileSummary: Content (please ensure you mask any confidential information): Hi Team, Draft watermark is missing in the draft file. I have used the RTF template in the report…Ashok Dhara 121 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
Making Period and Movement Dense: Report Performance Issues with QTD/YTD ViewsHi everyone, I am looking into making Period and Movement dense in our FCC application and am finding that the QTD/YTD View performance is unacceptable. 1-second Smart V…Matt Maurer 224 views 24 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How does security in Narrative reporting translate to EPBCSSummary: In Narrative reporting, the access is by folder/report, and connections can be established to external data sources for report execution. How does this translat…
-
Is there functionality in EPM to create a relative timespan?Summary: Looking for a way to have reports, automations and various other processes run based on a relative timespan. The goal of this would be to not require updating s… -
How to consolidate multiple extracts in a single extractSummary: Hi, I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a meth…
-
Consolidate multiple extract in single extractSummary: I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a method a…
-
Reports - "Reset to default" in the POV (FCCS)Summary: When doing the setup of a report, I can do a "Reset to Default" in the Point-Of-View of a each dimension. What does this do exactly? Content : Maybe this is a t…Erik De Rouck 43 views 7 comments 1 point Most recent by Erik De Rouck Financial Consolidation and Close
-
Oracle Fusion Application MT Timezone is not reflecting sometimes in OTBI ReportsHi Everyone, I have set the timezone in oracle fusion application as UTC-07:00 Denver - Mountain Time (MT) and now when I am creating an OTBI analysis and using Now() fu…Himansh Agarwal 52 views 0 comments 0 points Most recent by Himansh Agarwal BI Publisher Learning Center
-
How to query rehire contingent workers in BI reportSummary: I need to query for rehires To look for rehires the person has to have an active Contingent Worker assignment from the past and either a pending worker or conti…Vishnupriya 481 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
is there any payment due notification and schedule payment notification?Summary: is there any lease payment due notification and is there any schedule payment notification? Content (please ensure you mask any confidential information): Versi…DL003 11 views 1 comment 1 point Most recent by Louise Gareau - Support - Oracle-Oracle Lease Accounting
-
Query for Project Management (PPM) relatedSummary: I need to include budget details ( labor, materials and expense), forecast details ( labor, materials, expense) and forecast ( labor, budget, expense) in my BIP…
-
Report on Leave of AbsenceSummary: In our company, we use an Action in the Employment page to track if the employee is going on Leave of Absence (e.g. Maternity leave). Then, we use another actio…
-
Bi Reporting Error #221When attempting to open our organisation structure report we are being hit with an error as shown in the screenshot attached. This error is occurring when initially tryi…Jordan Squibb 11 views 0 comments 0 points Most recent by Jordan Squibb BI Publisher Learning Center
-
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 453 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
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 22 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 101 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