Reports
Discussion List
-
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
Looking for Report with Absence Type and it's corresponding Display Name on a TimecardSummary: Howdy, I'm looking for a report that will list the absence management type and corresponding display name by Timecard. See screenshot below. Content (required):…David Rabalais 41 views 1 comment 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Open a WRS from Excel with POVSummary: hello experts, I have some reports (WRS) that I want to open via excel, I can do with shared connections Reporting Settings. In each tab I have a report (I have… -
"Reports" in smartviewWhen opening new generation "Reports" in Smartview, in the prompt for selecting dimensions, there is no search option, how do you all manage if the dimension has 1000 me…User_2025-03-10-22-57-31-218 51 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Planning -
Infolet / Reporting Issue - USER.ID matching to Manager Email AddressHi all, I'm currently working on some infolets for displaying learning information for the managers to use when they load up PeopleCloud and I appear to have run into a …
-
Need to report on Document Record attachmentsContent can we report on Document Records attachments count? Has anyone done it? Can anyone share a report or any with me? Thank you in advance! Version 21BGala Meyerovich 95 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Shared folder report are not recived by users and when only through my folder recived by usersSummary: HI Team, when i scheduled through shared folder BI report are not recived by recipients and when scheduled through my folder only recived by recipients. May I k…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to set up time period for 12 week rolling percentageIn the "Workforce Management - Workforce Trend Real Time" subject area, in the "Workforce Trend" folder, there are the following fields: I need to use these in a calcula…rd17 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Some questions about Query Tracker and ASO AggregationsSummary: I'm no expert on the aggregation functionality of ASO cubes using query tracking. In particular, I'm having trouble with the stated order of operations: 1. Merg…Sabrina Greensea-166456 61 views 7 comments 0 points Most recent by Sabrina Greensea-166456 Planning
-
Options to perform data extraction from FAW DBSummary: We are looking to perform data extraction from FAW and load into a snowflake DB for some strategic reporting solutions. Is there any recommended approach for su…Amrita Gupta-Oracle 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Learning Module | Sql query to get details of default assignment rules of the courseContent I have a requirement where I need to create refresher alerts for mandatory courses – based on the renewal period set for the course. Notification will be trigger…Mani Venkataraman 168 views 10 comments 0 points Most recent by User_14HUA Reporting and Analytics for HCM
-
regexp_replace not working in etext templateSummary: regexp_replace not working in etext template Content (required): We have a requirement to remove extra semicolon from the string. Using regexp_replace, we are a…Meenakshi K 443 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM
-
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi…
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Oracle Fusion - Process monitor - Process "NAME"Summary: Hi All, I am working on creating a report to have the list of job failed in a specific date range. I am able to get the required information from the ess_reques…
-
"Unable to process your request" error in FRS when the default member is set to blank in promptSummary: When the default member prompt is set to blank, it throws an error saying "Unable to process your request." Content (required): The client's requirement is not … -
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
UE availability for Person Deduction Card (PAY_DIR_CARD_COMPONENTS_F) without Effective Date contextSummary: Is there any UE available for Person Deduction Card (PAY_DIR_CARD_COMPONENTS_F) without Effective Date context Content (required): Please be informed that there…
-
how can I get one seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …challa praveen 312 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dependent ReportSummary BIP that provides Dependent info (Name, Person Number, Age, SSN, etc)Content This a BIP that includes Dependent data (sorry, couldn't do an Answers report)Rick P Klassen 193 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
Data Lineage on the FAW HCM LearningSummary: Looking for Data Model / Data Lineage for FAW HCM Learning area. That will have the joins/ information relation between the entities. Can anyone help with that.…Moumita Samanta-Oracle 71 views 6 comments 3 points Most recent by Moumita Samanta-Oracle Reporting and Analytics for HCM -
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 12 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…Paul Younes 552 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …Cansel Karasoy 51 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a…Aaron Reynolds 31 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How…