Reports
Discussion List
-
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, …JanardhanaKondaveeti 221 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 22 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 131 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 -
Custom BI Reports and tables performance issue in fusionSummary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week. Could you please provide d…Venkatesh Emani-Oracle 31 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
UPPD without producing report ESS Process is running for more than 4 to 5 hoursSummary: UPPD without producing report ESS Process is scheduled on daily basis and it is running fine, completing in 60-90 minutes. But when we run this process during p…
-
Opportunity market place report - Self service PUBLICSummary: Do you have any report available that could help me to provide a listing of all jobs available in opportunity marketplace ? The report should be public (linked …Jacqueline GRANDIN 21 views 3 comments 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
I want to automatize the collection of query data for query tracking aggregation processSummary: Optimize ASO aggregation by enabling query tracking Content (please ensure you mask any confidential information): Hello the community, we want to automatize th…
-
Sickness Absence ReportingSummary: We have work schedules entered for all employees showing their working days. We need to export this in our absence reports so we can calculate working days lost…Karen Wilson 11 views 4 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
How should I find the full names of the people in the approvers column in the fa_fusion_soainfra.WFTHello, I use the APPROVERS column in the fa_fusion_soainfra.WFTASK table in my report, but the username is included there. I need approvers display name information. Can…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
I am looking for the UE and DBI for pulling Period name from the Person Results Page.I am looking for the UE and DBI for pulling Period name from the Person Results Page. Thanks in Advance!
-
How can we associate multiple Leases to each other?Summary: We have a customer requirement to group Leases together, e.g. multiple car hire leases grouped through a Master Hire Agreement. I have thought of some potential…Janelle Azimullah-Oracle 21 views 2 comments 0 points Most recent by Janelle Azimullah-Oracle Lease Accounting