Reports
Discussion List
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,…AjayKumar Maddipati 63 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Modified payslip Data model bursting is not workingSummary: We are trying to achieve the requirement to send payslip for ex-employees over personal email address, Below is the custom bursting data model that we modified.…Rama123-Oracle 1 view 1 comment 0 points Most recent by Faithe Chu-Oracle Reporting and Analytics for HCM -
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 32 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Payroll Relationship - Element Duration Dates - Final Close DateContent Hello, We're keen to build a report that shows the final close date using OTBIEE Answers (subject areas), however when included this appears to be on the relatio…Kevin M Storrie 193 views 12 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM -
How can I combine termination count and hire count in one analysisSummary: I have attached two different analysis One is showing hire count and other termination count But the requirement is that I need to have both the columns in the …Shreya Datir 32 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD…Aishwarya_15 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not working for Recruiting - Recruiting RealtimeSummary: For my OTBI analysis, I applied the prefix mentioned in the documentation for the Recruiting - Recruiting Real Time subject area under the Time Reporting headin…A.J. 25 views 3 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Move to HR blank in analysisSummary: Move to HR blank in analysis Content (please ensure you mask any confidential information): Hello experts, we are creating a custom OTBI analysis where we need … -
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e…AjayKumar Maddipati 54 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 13 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Benefit Participant Eligibility Employment Assignment Category TableHi, We are trying to create a report to fetch Participant Eligibility information. But not able to figure out the Employment Assignment Category information. Can anybody…
-
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 83 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…Amrita_Pritam_Nayak 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Dashboard prompt is not workingSummary: Hi, I have created an analysis using logical sql and passed parameter i.e. presentation variable inside logical sql. But when I am using dashboard and dashboard…Shreya Datir 43 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
User login details reportContent Hi Team, We have a requirement to see the list of users logged into the Fusion application on a specific day, in a format like the below sample: User Name | Logi…Arun Kumar Krishnan [AK] 617 views 3 comments 2 points Most recent by Naveen.yadav Reporting and Analytics for HCM -
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na…
-
Duplicate lines of data for employee in Worker Assignment Real TimeSummary: I have developed an analysis export which brings all current assignment data for an employee based on the Worker Assignment Real Time subject area. However, the…Dan_Hinsley 11 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 12 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Reporting: Active on a requisition within candidate pool reportingSummary: We have a candidate pool report utilising 'Recruiting Events Real Time' Subject Areas which lists all candidates in our Pools, their current state/phase, prefer… -
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…
-
Looking for query to fatch the specific security profileSummary: Content (required): Hi Expert, We are looking for a SQL query to get the list of roles that are attached with a specific security profile like a document securi…
-
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h…User_2025-07-18-07-07-18-338 3K views 6 comments 0 points Most recent by Stefan v. Glabbeek HCM Extract
-
Can we change the Date format to Text in OTBISummary Can we change the Date format to Text in OTBIContent Hi I would like to know to know if we can use any of the functions in OTBI to change the date format to Text…User_2025-01-30-21-52-52-008 241 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI report paramters not working in DasboardSummary I attached BI report to dashboard and created date paramter in dasboard prompt with same name as BI parameter.But not getting ouputContent Hi, I attached BI repo…User_6I33I 29 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Approval Path- Info is locked- Recruiting.Summary: Is there a way to see the approval flow on pending requisitions. Right now, only the person who submitted it is able to see where it is in the approval path, No… -
Date Range Parameter value should be defaulted to previous year in OTBI ReportHi Team/Raghavendra Raghunath-Oracle, We have created an OTBI report it's working fine. However in the Prompt parameter we wanted to default the filed values as below; S…Mahendra Y 35 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to edit and disable delivery option of Oracle HCM Fusion HCM Extract in 24BWe would like to disable the delivery option of HCM Extract and edit one of the Data group filter in 24B. As we do not have Advance edit option enable.Bindu Janoti-Oracle 94 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM