Category 81
Discussion List
-
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 21 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Is there any documentation available on using AND, OR, and groups in OTBI report filters?Summary: I am trying to set up filters in an OTBI report to pull a subset of employees for an assignment in Oracle Learn. I need to select a group of employees and then … -
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 41 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Colorado state employee retirement benefits year end reportingWorking with a school district in Colorado whose employees are participants of PERA. PERA has a very specific requirement for reporting year end data in the exact EFW2 S…Muriel Sindyla 11 views 1 comment 0 points Most recent by Rajesh Tota Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B… -
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the …JohanneAM 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to report on Owner Person Email in Workforce Management - Checklist Real Time subject areaSummary: Content (please ensure you mask any confidential information): We are building an OTBI report to display Journey tasks metrics using the Workforce Management - …Giuseppe Cannova 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Created new Measure with conditions incorrect result, Workforce Management - Workforce Assignment RTSummary: Hello all, I have created a new measure - Count of Female Managers - FILTER("Worker Assignment"."Assignment Count" USING ((DESCRIPTOR_IDOF("Workforce Management…Ian.Gooderham 11 views 2 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
OTBI get name from Person Number in an analysisSummary: Hello, is there a way to get an employee's name from a field that stores their person number? For instance, "Feedback Response"."Created By" in the Workforce Pe…CClark30 48 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Ability to Hide Future Hire Recored for Line Manager viewSummary: Future hire records who all are considered as sensitive hires are needs to be hidden fro Line Manager's view before theire DOJ Content (please ensure you mask a…Maran Aswin 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Person address data not displaying for user - BI reportSummary: I created one BI report and it has SSN and person details including address. When I ran the report, it shows all the details. When user ran it, the address fiel…Peoplesoft 35 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
List of standards reports and infolets in Oracle HCMHello, Is there a list of standard infolets and reports in Oracle HCM that companies can use please ? Thank youHiba Ghoualmia 254 views 4 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
How to cancel double row in changes BIP report?I have a BI PUBLISHER report that shows changes in addresses and marital status of an employee. I use the table HRC_EVT_OBJ_CHANGE_COMPONENTS, The problem is that it sho…Alex_Balanovsky 13 views 1 comment 0 points Most recent by User_4XX09 Reporting and Analytics for HCM
-
OTBI Questionnaire text column how to set the questions inproper to order ?Summary: Hi Team, We were developed new report by using Check list real time subject area to get onbaording Questionnaire text of employees but issue questions are inpro…AjayKumar Maddipati 32 views 12 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Duplicate record in analysisSummary: Duplicate record appears when pulling data from Workforce Management - Document of Record Real Time Content (please ensure you mask any confidential information…Steph Yeung 51 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 249 views 5 comments 0 points Most recent by Narula Shray Reporting and Analytics for HCM
-
Need help in retrieving PLAN MANAGER in workforce compensation planSummary: Hi Experts, I was trying to retrieve workforce compensation plan manager. I could not find comp plan manager as filter when searched under Matric Manager in Wor…Ganesh Purnima 13 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 53 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
accrual balanceSummary: I have a report on front-loaded plans to show Accraul, leave taken, Leave scheduled, Adjustments and Accrual Balance. Now we have made some adjustments for empl…Wouter.Schaap 32 views 1 comment 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
OTBI Report Not Returning employment contract detailsSummary: Created an OTBI report using subject area "Workforce Management - Employment Contract Real Time" to extract contract details. However, the fields when added fro…User_2025-02-11-02-55-52-410 32 views 16 comments 0 points Most recent by Samir Patro Reporting and Analytics for HCM -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 74 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Getting inconsistent data from event date fields. Can anyone help explain this or how to fix this?Summary: While creating an analytic for the state activation and completion, by job application, it created multiple lines. To solve this, we have in the past been able …Faraz123 42 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 53 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
what all types of the condition/logics can be used in e-text templateRequired Types of logics, condition and syntax for e-text templates in BI PublisherVinay Prasad 2 views 2 comments 0 points Most recent by Vinay Prasad Reporting and Analytics for HCM -
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 2 views 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Prompt not working in a logical sql analysisSummary: I created a logical sql analysis (see image1). And I also created a dashboard prompt (see image2). I filtered the "Calendar_Year" as 'Is Prompted' but for some …
-
Tables to fetch queries used in DataModelsSummary: Hello Team, Is there any specific tables that are being used to fetch queries used in Data Models? Is there any way to achieve this? Thanks, Paramesh Content (p…Kurva Paramesh 21 views 3 comments 0 points Most recent by Kurva Paramesh Reporting and Analytics for HCM
-
Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime OTBI AnalysisSummary: Columns from Grade and Worker folders in Workforce Management - Eligible Jobs Realtime not showing results Content (please ensure you mask any confidential info…
-
OTBI prompt set default values for date between first and last day of current yearI know that I can set a default for a prompt as todays date using the SQL expression select current_date from "Workforce Management - Worker Assignment Real Time" I thin…