Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Need a query that combines both termination transaction details with the employee details.Hi I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for … -
Issue getting most recent/max date for "Offer Extended" Recruiting EventSummary I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows retu… -
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal… -
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
Setting some dashboard analytics to a date in a hidden dashboard prompt (e.g. 'Previous Year')Content This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM … -
When pulling fields from two subject areas, it often breaks and returns 0 resultsSummary: When trying to create an Analysis from two subject areas it doesn't work. Example: Workforce Management - Person Real Time I have the following fields: Address …
-
Positions report with no open requisitions or current incumbentsHello, Currently we are looking for a report regarding Position details where there is no Open requisition linked or no current incumbents mapped. Many thanks,
-
Not getting correct count in the termination count column.Summary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…
-
OTBI Caclulation Issue [nQSError: 22025] Function Cast is called with an incompatible type. (HY000)Summary: Hi everyone, I'm finding troubles when summing 2 columns in OTBI. Content (please ensure you mask any confidential information): Hi everyone, I'm finding troubl…
-
How to confirm the normal transmission of the bursting.Summary: How to check if a bursting has been successfully sent. Content (please ensure you mask any confidential information): Nice to meet you. My name is Keishi. Now I…
-
SQL query for linking between life event and benefits plansSummary: Need sql query or back end table for the linking of add life event(BEN_LER_F) and benefits plans(BEN_PL_F) Content (please ensure you mask any confidential info…
-
Number of active/Inactive users in Oracle HCMSummary: Hi All, Do we have any standard report to see the number of active/inactive users in the system? If someone has this report please share. Thank you.
-
OTBI Presentation Variable Date Prompt no Longer Functions ProperlySummary: Recently all our absence reports within our Production environment that use a Date Presentation variable as a prompt have stopped producing the required results…
-
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil… -
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…
-
Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "Summary Getting error "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" when Limit By has "All Prompts" selectedContent Hi , I am facing a issue. I have … -
How to display month names instead of numeric values in OTBI analysisSummary: I have created a graph through OTBI analysis. But month is coming as numeric values. How to show month name ? Content (please ensure you mask any confidential i…
-
Query to retrieve the employee seniority dateSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve Seniority Date for employee person number 1775. In case of Rehir… -
Restrict Report data based on security profileSummary Restrict Report data based on security profileContent Is there a way to restrict report/analysis output data based on security profile. We have created a data se…
-
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …
-
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …
-
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
Where can I find Talent Review Columns of Task Subject, Task Status, Task Owner and Task Due Date?Summary: In what table can I find Talent Review Columns of Task Subject, Task Status, Task Owner, and Task Due Date? Content (required): Here is a brief description of t…
-
Looking for Department column which contain value of PSSR Requisition DFFSummary: I am looking for Department column which is populated with new value using DFF. Please find attached doc for reference. Content (please ensure you mask any conf…
-
Enable to get the output from the "Person Profile Real Time” subject areaSummary: Enable to get the output from the "Person Profile Real Time” subject area Content (please ensure you mask any confidential information): Hi experts, we want to … -
Is it possible to show/identify the job family for the Line Manager in OTBI Analysis ReportAs per business requirement I am creating a OTBI Analysis report to identify/highlight job family (Thru Conditional Formatting) for direct manager. For example, if a Dir… -
Query that fetch Grade Rate Value for a certain personSummary: Hello! I need help to get a query that passing the assignment_number of an employee I can get the value field of a Rate Value inside the Grade of a person. Exam… -
Oracle Recruiting Internal and External Selected Canidates - OTBI ReportSummary: We have requirement to show selected internal and external candidates in an OTBI report. Please advise. Please provide a sample report. Content (please ensure y…
-
SQL Query Timeout is greyed outSummary: SQL Query Timeout is greyed out. I have logged into xmlpserver but is still unable to change the SQL Query Timeout. Is this field no longer updatable? Content (… -
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…