Reports
Discussion List
-
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident… -
Need query to get the list of all roles for a given roleThere was an error rendering this rich post.Niranjan_DTCC 41 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Is it possible sort the Index(Table Of Content) while Exporting Report BookSummary: The report book generates the report for all the entities in different sheets of excel with first sheet as Index sheet. Is it possible to sort this index while … -
HCM Extract reference root data group attribute in child nodeSummary: I have a custom extract to pull payroll balance for employees. It has 2 data groups. The first data group has balance values and child data group has employee d…
-
Which view/tables to access to create a report to capture User Login IP Address?Summary Which view/tables to access to create a report to capture User Login IP Address?Content IP Address of Application user in Fusion HCM is to be captured in a repor…Setu Shah-27233 493 views 11 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for HCM
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 61 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Leavers Work ScheduleSummary: Hello, Is there a way to bring historical leavers Work Schedule and Work Schedule End Date? I am currently using the Workforce Management - Person Real Time sub…Dan_Hinsley 11 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …Janardhana Kondaveeti 216 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Why does the query in the dataset take an extended time to process?I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the…
-
Recruiting Real time Subject Area - Candidate Pool missing data?Summary: Hi Experts, I’m wanting to create a Candidate Pool analysis report using the Recruiting Real time Subject Area. I cannot find a data field to capture the start …
-
How do i create a member formula to pull for children as wellI would like to create a scenario member with a member formula that will calculate the variance between two columns in my management report. Then when I drill into the, …
-
Report Formatting - Dynamic Portrait vs Landscape or Book overrideSummary: When building a report, is there any way to have it dynamically set portrait vs landscape based on POV or to have a book override the page orientation that is s…
-
NR Report Rounding Cell Value WrongIssue Summary: I have a report in NR which, when rounding the value 0.00499964375194395 to 2 decimal places, returns a value of 0.01. Details: The report is built in Nar…
-
Need to Split Job.Job Name into 3 different fields - Primary, Secondary, TeritiarySummary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as Primary Secondary Tertiary Unmapped Unmapped HEAD OF AGRICULTU…Pradnya_Pampatwar 21 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Admin tool or (other method) to identify all OTBI Subject Areas that my company can accessSummary: Is there an admin tool (or other method) to identify all OTBI Subject Areas that my company can access? Content (please ensure you mask any confidential informa…
-
How to connect to SQL Server to report in context to PPMSummary: We want to develop a BI report to get data from PPM costing and also want to fetch related data from a SQL server DB. Please suggest how we can connect to SQL s…
-
Is there a report available to export out of EPCM to get driver data for all rules?Summary: We are needing to get a report of all rules and the driver that is being used in those rules. Currently we export the Model Documentation and create formulas to…Crystal Eide 31 views 7 comments 1 point Most recent by Crystal Eide Profitability and Cost Management -
What Process Populates the Projects Essbase Cube?Summary: What process should be run to initially populate the essbase cube and/or keep it updated and what parameters should be used? Content (please ensure you mask any… -
I cannot find a job offer listed in the transaction logs form 9-22-22 for a specific employeeOne of our job offer from 9-22-22 was selected audit sample. EY is asking that we prove that this job offer was submitted with the correct job descriptions. When a job o…
-
Set Custom Context Values for Child UESummary: Content (please ensure you mask any confidential information): Hi team, On an extract with the structure as below, I'd like to understand if there's a way to ov…
-
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)Mustafa Abu Dayeh 1 view 0 comments 0 points Most recent by Mustafa Abu Dayeh Reporting and Analytics for HCM
-
Database table that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real TimeSummary: Can someone provide the Database table name that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real Time specifically looking for the Calcula…Laura Goodall-Brown 21 views 2 comments 0 points Most recent by Laura Goodall-Brown Reporting and Analytics for HCM -
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 132 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Talent Review - no results OTBISummary: We have created a custom Talent job/data role which contains the relevant security access to view Talent in My Client Groups. We now want this custom Talent rol…Jo Ord 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM