Category 81
Discussion List
-
Phone numbers repeating instead of suppressing duplicatesSummary: Mobile phone and home phone number columns are repeating even though they are duplicates and the columns are set to repress. Content (please ensure you mask any… -
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 15 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Where is the LONG URL stored for candidate source tracking?Summary: I am trying to locate the LONG URL that is captured as part of Source information mentioned in the second paragraph of this oracle help document. Does anyone kn…MarkHodges 8 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
Response ScoreSummary: Hi, Does anyone know where can I find the Response Score (if it is the correct answer - 1 or the wrong answer - 0) in OTBI? I've tried under Questionnaire Respo…Vasco 15 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Workforce Performance - Performance Task Status Real Time showing incorrect assignment informationSummary: The Workforce Performance - Performance Task Status Real Time subject area seems to be displaying incorrect assignment information for employees that have had t…CClark30 28 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle 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 52 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
What is the OTBI Subject Area for State Wise Minimum Wage?Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. …Ramya Rajendran 26 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull latest termination date AND/OR null term date based on Person Number & Latest AssignmentSummary: I'm using an OTBI report to pull a distinct count of # of employees at a specific location between two dates. This report includes fields like Job Name, Hire Da…CGardner01 276 views 6 comments 0 points Most recent by Bhaskar Konar 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 21 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 15 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to use 1 common filter for graph and tableSummary: Hi Experts, I created an OTBI analysis and want to add one common filter for graphs and tables. Can someone assist me with how to use all filters for both? Than…
-
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…
-
Job Change ReportSummary: I have a Job Change report that I was sent and I need to add a few fields to it. It was built in Logical SQL and I'm having trouble adding a few fields. Any hel…
-
I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review MeetingsHi team I hope you are doing well. I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review Meetings (Box label, Rating, and manager name) Kind regard,Mohamed_Shafay 56 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Cross Subject Area join between Checklist and Helpdesk Request SummarySummary: There are Checklists created for certain Helpdesk Service requests. We need the data from both checklist and helpdesk on an OTBI Analysis **** Dashboard. Is it …Vibha Pandey - Oracle 7 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Birthday Notification to be sent with Custom text on ImageWe have requirement to send birthday notification to employee by keeping RM , HRRM , Employee direct reportee and RM direct reportee in CC The content of email is :- Dea…Surbhi Jat-Oracle 98 views 0 comments 0 points Started by Surbhi Jat-Oracle Reporting and Analytics for HCM
-
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 … -
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 82 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
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 3.2K views 6 comments 0 points Most recent by Stefan v. Glabbeek HCM Extract
-
Query of Contents at the Activity LevelSummary: When Creating an Activity, and adding the Offering Content how does Oracle query the data coming out of the Results? We noticed that sometimes when searching ev…
-
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …Naved Khan 1.1K views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
BIP Report to get Employees with Bank Accounts not assigned in a Payment MethodSummary: Hello everyone, I am trying to create a report where I want to get a list of employees who have bank accounts that are not tied to any Personal Payment Method. …Tom John Bontoyan 69 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Need help to build a sql to get approval transaction historySummary: We have a requirement to capture approval transactions and the respective data like what changed in the transaction. For example If it is for Location Change,wh…Praveen D 155 views 5 comments 0 points Most recent by Hrushikesh Pentewad 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… -
REQUISITION_POSTED State Code Giving Strange Resultshttps://us.v-cdn.net/6034893/uploads/SEVJVQA956IF/u-s-req-posting-time.txt Hello, I have a need to find the most recent date a requisition was posted and unposted. For c… -
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 43 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM