Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Can we recall the triggered emails from scheduled reports via the system ?Hi All, Is there any possible ways to recall the triggered emails from scheduled reports via the system ? Regards, Jeba -
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …
-
Customize/remove action button in infolets for fusion HCMSummary Customize/remove action button in infolets for fusion HCMContent We have a requirement where action button of infolets needs to be hidden for users. Please share…
-
Logical SQL: How to Calculate Response PercentageHi Community, I have BU, ResponseCount and BUTotalCount columns in my Logical SQL based report. Response Count: It is number of responses from employees on a questionnai…
-
User Entity to extract Absence plan enrollments of an employeeSummary: I have a requirement to extract all absence plan enrollments of an employee , using HCM Extract. I am looking for a User Entity which can suffice this need. The…
-
Embed a Link on the Dashboard to take to Submit a Flow page in HCMSummary: Like Deep Links/Action Links, can we have a LINK on the OTBI analysis/dashboard to let the User submit an HCM extract via the Submit a flow page. Content (pleas…
-
How to Create a BI report for BPM worklist fields in addition to TXN action and action Reason.Summary I have created a BI report for BPM worklist, along with action and action reaction from TXN header table which is and extract from XML_data_cache filed, but it i…
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to … -
How to compare BU to TRU.I was wondering if there's a way to compare BU to TRU. I've tried using different logic to compare the two, but haven't had much luck. TRU has the official name, while B…
-
Reporting on future dated positions using OTBI 'Position Real Time' subject AreaSummary: Is it possible to report on future dated positions using the 'Position Real Time' subject Area in OTBI? Content (required): I current report on all active posit…
-
Formula for "Begins with"Summary: How to write a Formula that says If Department Begins with 3 THEN "Division1" I know how to write the standard formula using CASE(IF) but not sure what function… -
Restrict Diversity fields from Person Real Time Subject AreaSummary: Subject Area - Workforce Management - Person Real Time Folder - Person Legislative Information Fields - Gender Identity, Sexual Orientation User should have acc…
-
How to insert cover art image on Learning Catalog Course (Not stored as a BLOB file) in a BIP reportSummary Trying to insert cover image of course in OLC in BIP ReportContent Hi Team, In Oracle Learning Cloud, we can upload Cover Art images at course level and the imag…
-
Fact Definitions - Candidate Tracking Real TimeSummary: Content (required): Where can I find the definitions of facts in the Candidate Tracking Real Time Subject Area? I'm looking for the difference between 'Number o… -
Legends not appearing correctly in graph viewHi, I have to create a graph where I have to show voluntary termination and total termination in one graph(region wise). I have created the graph but in the legend it is…
-
Assignment Changes L-SQL Query IssueHi all, I've been using and adapting Julian's L-SQL query posted here: to try and return previous roles for employees. It all works great until we have someone who has t…
-
Employee / Line Manager / HR Specialist seeded analyticsSummary: Customer want to know any seeded list of Employee / Line Manager / HR Specialist analytics or dashboard Content (please ensure you mask any confidential informa… -
Ability to embed an OTBI report into a Redwood pageSummary: We have requirements to call an OTBI report from redwood page , its applicable ? if yes , what are the required steps to do that? Content (please ensure you mas…
-
Show all employees whether they have been on a course or not.Summary: I am trying to gauge an approach to producing a list of employees with the courses that they have completed/in progress etc. using the subject areas for "Workfo… -
Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES?Summary: As stated in the question title: Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES? We know that PGP Encryption … -
Delivered reports are available only in english?Summary: Hello, I would like to know if the delivered reports are available only in the english language. Thank you. Content (please ensure you mask any confidential inf…
-
Learning Calendar not showing in reportHi All We've adjusted and using Learning calendar from Demo environment report and using it for almost year. But in the last 1-2 months the calendar is no longer showing…
-
SQL Query to fetch SOE balances and elements.Summary: Hi all, I am working on a BIP report where I need to fetch all balances , earnings and deductions elements name along with it's value whatever is present in the…
-
How to show Attachment Link in the ReportSummary Is there a way to show actual attachments link in a report whether in analysis or BIPContent Is there a way to report on actual attachment which was attached as … -
EIT Field value is not displaying in OTBI-AnalysisContent Hello Community, We have created an Analysis in OTBI, with simple fields from the "Workforce Management - Worker Assignment Real Time" subject area, which work v… -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne… -
OTBI icon with starSummary: Regards Oriana Content (please ensure you mask any confidential information): Hello experts, does anyone know what this icon refer to? I basically have an otbi …
-
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
enable password to custom OTBI Text FileSummary: Dear, Customer request to enable in custom Report password security, as following User Run the Custom Text File Report User Download the File to Open that file …
-
How can we change BI report name dynamically while downloading as per selection parameter.I have created a BI report as 'Job Application Report' and in this report I have created many parameters. One of them is the parameter name 'Requisition Name'. And After…