Reports
Discussion List
-
Need help configuring BPM Workflow Task for Issue NotificationsSummary: I have tried to customize the Issue Notifications Catalog workflow template for the Create Issues task under Project Management, but it is not reflecting my new… -
Need help on the Attrition % formulaSummary: 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…Shreya Datir 61 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report for PC log in vs Mobile log in on browser vs Mobile log in on the appHi there, Is there a report, or which tables could we use to build a report, that identifies whether a user log in to HCM is from a PC or mobile. We found "Device_Type" …
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
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…User_2025-02-04-23-22-13-274 113 views 9 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM -
Report with Multiple Prompts or Current POVSummary: I want the user to be able to select their POV for more than one dimension. Content (please ensure you mask any confidential information): I'm trying to create … -
The limit of 6000000 rows in the report is before suppression or after?I am using the descendants function for two dimension combinations in rows which creates a lot of rows and the number goes above 6000000. But most of the rows at these c…
-
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…stusc 51 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 …
-
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 …Brenda_W 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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,Bala Krishna B 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Shreya Datir 61 views 13 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
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…
-
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI? -
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.Saher 22 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
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…Kevin Robertson 52 views 15 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
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…Shilpa Varghese 247 views 4 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
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…
-
Edit prompt option not working in smartviewHi Team, We have generated MR report in the smartview but the option of Edit Prompt in the Smartview ribbon is appearing as greyed out , not able to select the prompt in…
-
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 …User_MC37Q 120 views 13 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
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…Shreya Datir 41 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
guys, Has anyone already included the standard journal report in the fccs book?Summary: I have created some books within fccs and the user asked me to include a standard journal report, but I was unable to do so. Content (please ensure you mask any…Silvia Arraiol 11 views 1 comment 0 points Most recent by Komala Reddy-Oracle Financial Consolidation and Close
-
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 …JDCal 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
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 …Chetana Pawar 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
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…
-
Looking for Department column which contain value of PSSR Requisition DFFhttps://us.v-cdn.net/6034893/uploads/CLUU6PV3IEH7/department-column-step-by-step-doc.docx https://us.v-cdn.net/6034893/uploads/3J6ABUS2ZEIC/department-column.docx Summar…Pooja_123 21 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
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 … -
EPRCS CbCR error when generating XMLSummary: My first time trying this and receiving an error as noted below. I assume I am missing some metadata in TRCS on the CbCR forms? Can anyone point me in the right…Brian Robinson 41 views 5 comments 0 points Most recent by Michel Schoolenaar-Oracle Tax Reporting (Direct Tax)