Category 81
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, JebaJebarsan Thangam John Durai Raj 11 views 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM -
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 …Rengaraj G 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
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…Ashok Kumar Sharma 11 views 6 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
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…Pankaj_Singh 192 views 2 comments 1 point Most recent by Pankaj_Singh Reporting and Analytics for HCM
-
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…Vibha Pandey - Oracle 11 views 2 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
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 …Oriana L. 23 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
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…Michael Angelo Lucena 1 view 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM
-
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…Paul Morrissey 51 views 4 comments 1 point Most recent by Paul Morrissey Reporting and Analytics for HCM
-
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…THawkins_LGI 11 views 4 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
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…Bindu Vasa 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Susan Anderson 101 views 11 comments 0 points Most recent by User_MN692 Reporting and Analytics for HCM -
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…Parul007 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where in UI in Talent Management can we see the the below codes?Summary: Code 1 Document Status: SELECT distinct HRA_EVALUATIONS.STATUS_CODE FROM HRA_EVALUATIONS ,HRA_TMPL_PERIODS_VL WHERE HRA_TMPL_PERIODS_VL.TMPL_PERIOD_ID = HRA_EVA… -
Assignment Changes L-SQL Query IssueHi all, I've been using and adapting Julian's L-SQL query posted here: https://community.oracle.com/customerconnect/discussion/32323/assignment-changes-within-date-range…MikeW 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Suresh Manoj Kumar-Oracle 21 views 5 comments 0 points Most recent by Suresh Manoj Kumar-Oracle Reporting and Analytics for HCM -
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…
-
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…
-
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…Mark Jayson Tamaray 32 views 8 comments 0 points Most recent by Mark Jayson Tamaray Reporting and Analytics for HCM -
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 …Oriana L. 21 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
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 …Mostafa Yassin 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…Anjali_Jaiswal 153 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Learning Enrollment status blank in OTBISummary: Content (please ensure you mask any confidential information): Hello Experts, we are trying to create an OTBI report with the Subject area: Learning record real…
-
OTBI report for salary basis history exampleSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample OTBI report tracking the employee salary basis history with a…Valerio Curzi 125 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Payroll Data to Transaction DetailsHello I am looking to create a report that shows pay element details linked to the transaction data. We issue Special Payment to several of our employees. When it is ent… -
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…
-
Federal Tax Withholding Filing Status - Pulling Data from TablesSummary: The Federal Tax Withholding Filing Status seen from the front end of the application is displaying a status that does not correspond with the Filing Status seen…ChicagoConsultant 22 views 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM