Category 81
Discussion List
-
Restricting Data for Direct reports of a Line ManagerSummary: Hi All, How do we restrict Line manager access to only his/her direct reportees Learning Items in OTBI Report. Can you let me know the steps ? Content (required…Veena P 71 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.2K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Adding a number format for OTBI reportSummary: I have created an OTBI analysis to get the grade related min, max and average values. Content (please ensure you mask any confidential information): The OTBI an…Ayesha Iroshani 222 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewThere was an error rendering this rich post.AjayKumar Maddipati 81 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
how to update position, job and location using hdlSummary: want to change employment data using HDL Content (required): I'm new to OTBI and want to change employment data for columns like Position, Job, Location. From w…
-
Missing a voided check in reportSummary: Missing a void check in pay_ce_transations Content (please ensure you mask any confidential information): Hi, One of our report to fetch a list of voided checks…
-
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. CRitika.ray-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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 11 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 1 view 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 11 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 21 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 51 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 21 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 282 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 23 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 11 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 53 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 1 view 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 91 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