Category 81
Discussion List
-
Document Of records- Headcount - Document Count inconsistent resultSummary: I am trying to create a report with employees who have updated their 2nd covid vaccine on the DOR. I am able to get the count correctly. Then I am trying to get… -
Issues Reporting on Development Goals after a Global TransferSummary: We are facing an issue in reporting (both OTBI and BIP) where an employee adds development goals and shows on our reports as expected, but after they have a glo…Gabrielle Ungaro 31 views 6 comments 0 points Most recent by Gabrielle Ungaro Reporting and Analytics for HCM -
Enforce 2 decimal places after a column result in s query.Summary: The table column can have values like 2,3,56.78,34,8 etc. We need something on the query such that 2 must show up in query result as 2.00, 67 as 67.00,45.6 as 4…Aloka Bhattacharya 151 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
HCM Extract and Bi Publisher delivery option auditHi Whatever change has been made to the delivery option in both HCM extract and BI Publisher. Does the change and the user who made changes gets audited?? If Yes, could …
-
Filter to bring back the greatest Response Attempt NumberSummary: Content (required): We have an OTBI report using looking at employees Performance Review Rating (workforce performance - Performance Rating Real Time), for most…Joe Dorrian 21 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Promotions and Transfers Reports and Data ModelsSummary: Business need for two reports: promotions and transfers showing From and To information Content (required): Hi, everyone. We are looking for an example of a rep…Michael Cashin 211 views 3 comments 0 points Most recent by User_VB02H Reporting and Analytics for HCM
-
Non-Hired ApplicantsSummary: I need a report that lists all non-hired applicants in the past year. Content (required): Looking for a way to list all candidates that applied for open positio…Scott Conaway 21 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Documentation or Use Cases for putting reports on pages that use parametersSummary: Displaying reports on various pages that require page filters Content (required): We have successfully been able to add OTBI analysis to pages and filter on the…Karen Costakes 21 views 2 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Tax rates vs Tax codes SQL from HMRCSummary: How to query how much percentage of deduction is associated for each tax code based on HMRC definitions? in which tables this data avilable? for example for BR …ViswanathaReddyKetireddy 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly executed) Is there any way to find. ThanksMohammed Rafi 141 views 3 comments 2 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Unable to get data in HCM Extract linked BI report after 21D updateSummary: I have created a dummy extract, and have linked a BI report to the Extract delivery option (as we need to use autoload parameter in HCM extracts, data is coming…User_2025-02-11-23-20-16-609 61 views 0 comments 0 points Started by User_2025-02-11-23-20-16-609 HCM Extract -
HCM Extract failing at runtime for Name PAY_PAYPROC_UNKNOWN_ERRSummary: Hello, The HCM Extract validated and compiled with no errors is failing at runtime for below mentioned errors: Name PAY_PAYPROC_UNKNOWN_ERR Token1 null Token2 n…
-
Table for Names details in Usernames page for External usersWe have a requirement to pull all External user's usernames (users without person record) with other details like FirstName, LastName and Email displayed in "User Inform…Santhosh Bachu 52 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
[Alert Composer] Alerts are Working at the Course Level but Not at the Offering LevelSummary: Alert is not working at the offering level. I refereed oracle document (Doc ID 2610054.1) but don't know how to implement the rest API. If anyone has experience… -
Resource Alert: Waitlist Exit AlertSummary: Hi All, I am working on a resource alert(alert composer) to achieve those learner details whose offering status change from waitlist status to some other learn …Arti P 31 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
Why I am getting no results after using Workforce Management - Documents Of Record Real TimeSummary: Why I am getting no results after using Workforce Management - Documents Of Record Real Time . When I am using column Person Number and Document Type there is n…RakeshK 21 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Purge deleted learning item gives an errorSummary: Content (required): Hi there, We managed to delete some legacy records as explained here. The next step is to purge them, as explained here. The template we use… -
Job offer letters issuei am working on recruiting module in HCM Cloud i wanted to create Job offer letters. we have mulcible templates for same requisitions using some conditions in main templ…Akram1206 31 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Loss of benefit eligibilitySummary: Content (required): I am trying to report on employees who are losing eligibility to benefits based on recent life events processing. Can anyone help me with th…Scott Paulin 11 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Is there a way to track the 'Recommended Candidates' from the AI database tables back to the req?Summary: The aim is to develop a report to analyse how many 'Recommended Candidates' are actually being hired. Hence, looking for a way to report this using the AI table…Dheepak Jeevaraj 11 views 0 comments 0 points Started by Dheepak Jeevaraj Reporting and Analytics for HCM -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would…Revital Mefano 21 views 2 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
How to "decode" Notice Period UOMSummary: How do one decode Notice_Period_UOM in SQL/Query Builder Content (required): How do one decode Notice_Period_UOM in SQL, so that the output display e.g. days, m…
-
OTBI Concat FormulaSummary: Concat formula Content (required): I need to create a field in OTBI to show last name, first initial. Is there concat formula I can use to show this? Version (i…User_2025-02-06-00-25-02-334 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Date Parameters in Headcount AnalysesSummary: I am just starting in OTBI Development and trying to understand how I achieve the desired analytic with results based on comparative dates. Content (required): …
-
HCM Extract Rule Extract related to FF - Logging helpSummary: How do you output log information from a custom Fast Formula that is run from a HCM Extract? Content (required): I have a HCM Extract with an attribute of type … -
OTBI Report (Count Distinct - Accomplishments)Summary: Hello, I'm running an OTBI report. Is there a way to use count distinct in Accomplishments? Subject Area: Workforce Profiles - Person Profile Real Time But the …Hazel De Castro 344 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Accrual balance with different start dates for plansSummary: my customer is an international company and the various countries have different accrual plans. For most countries the plans start at January 1th of a year, but…Wouter.Schaap 11 views 4 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
how to send a email and place file in sftp server using BurstingSummary: how to send a email and place file in sftp server using Bursting Content (required): My Requirement is to place a file into SFTP location and sending a email no…Pritam Das 211 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Having an issue while opening Analysis with HR Specialist roleSummary: I have an issue when I'm trying to open an OTBI analysis from the user account with Human Ressource Specialist role. But no issues occurred when I open it from …Evgeniya Repnina 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Schedule process report output to emailSummary: Schedule process report output to email Content (required): We have a few reports which can be run using the scheduling process. Few Examples User and Role Acce…AvaneeshJain 44 views 2 comments 0 points Most recent by Matt Luscombe Reporting and Analytics for HCM