Reports
Discussion List
-
VBC HCM tables available for BI Query in lab pod? POCSummary: Are the Value By Criteria tables available for BI Query Data Model? Content (please ensure you mask any confidential information): Hello: I'm performing a Proof… -
Narrative reporting default rounding when scaling valuesMy client wants their narrative report to display in millions, but once the report is scaled it automatically rounds the numbers eg 50,900,000 displays as 51 but my clie…
-
Person id equals to 0 using the Person Profile Real time subject areaSummary: Person id equals to 0 using the Person Profile Real time subject area Content (please ensure you mask any confidential information): Hi experts, we are facing t…Oriana L. 21 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Infolets - hide 'Edit Titles and Views' buttonIn the Analytics/Infolets section on the HCM homepage, employees have access to a button in the top right of each infolet to either 'Edit Title and Views' or 'Hide'. Is …Edward_Cowne 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Remove Edit Capability from the Reports Shared Folder but Retain Edit Capability in the My FolderSummary: We are trying to update report permissions to remove the edit capability from the shared folder but retain the ability to edit in reports in My Folder. We have …G. Class-Peters 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.Shanna Oppenheim 31 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
oracle epm narrative reporting, can I choose a specific day for running reports. e.g 31/12/2022Summary: My client wants the ability to run a report, and the two grids on the report show for example, 31st June 2023, and the second grid to show 31st Dec 2022. Is thi…
-
Narrative Reporting Font in Embedded Doclet Revert in Document after Refreshing ContentHey everyone, I've run into what I believe to be a bug. I made a tabular report in Management Reporting that was first in Arial but has since been changed to Times New R…
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 294 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
-
How to get Oracle Cloud Connect? (Query only tool like SQL Developer)Summary How to get Oracle Cloud Connect? (Query only tool like SQL Developer)Content Hello, Does any one know how to get Oracle Cloud Connect? It is a query only tool li…
-
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 11 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM
-
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct…
-
How to handle "Personnel File Request" in Oracle HCMSummary: Hello, Per Personnel Records Review Act, Current and Former employees can request their Personnel File information from the employer. I would like to know the f…Deepa Kannan 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 321 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 81 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Extracting All Location TB Data in Data ManagementWe would like to inquire whether there is a method to extract all location data from the data management in FCC. We understand that non-consolidation reports, which cont…PAMUDI 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
How to get dimension security groups working in the new reports module?Summary: The new reports module seems to not enforce dimension security and our users are able to see entities outside of their security group that's assigned in the dim…
-
Management Reporting: Function for Trailing Twelve Months (using Range & Period Offset NOT working)Summary: I have a TTM (trailing twelve month) P&L report that works perfectly when i pick any period except DECEMBER. When I pick December, it gives me some strange outp… -
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay https://us.v-cdn.net/60…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql to get period end active head countSummary: Hi Does anyone have sql to get active head count at the end of each month/quarter? Thanks in advance. Content (please ensure you mask any confidential informati…
-
How to put formula with text data in Management reporting?How to put formula with text data in Management reporting? The Formula is: [IF(E9="PRE",I9*6,I9*6*85%)] [E9 & I9 are cell values and "PRE" is Text data to be picked by t…