Reports
Discussion List
-
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 -
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…MandeepKGupta 96 views 3 comments 0 points Most recent by Daisy Quebrata-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 -
difference between Narrative Reports and EPM Cloud Reports (found in PBC)Summary: HI, I have been creating reports using EPM Cloud Reports, but not in NR yet, can anyone tell what is the difference between these two? I haven't seen NR interfa…
-
Merge Row Header cell with Text Data CellsSummary: I have long Heading in a row which is wrapping in the Fixed Column Width option. So when I try to Merge with a Data Cell (empty cells in a text Row), the Merge …
-
Time Zone in the DateTime functionSo when I select ET time on in user preferences, in the DateTime function the time zone returns as EDT. I have two questions for this. Will this automatically update to …
-
Possibility to have several logos associated to the same reportSummary: REPORT Module - Dynamic Logos Content (please ensure you mask any confidential information): Hi all Is there a way to associate several logos to the same Report… -
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…User_2025-02-05-16-57-43-236 35 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
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 33 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 … -
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 126 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
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…
-
Narrative reporting default rounding when scaling valuesMy client wants their narrative report to display in millions, but once the report is scaled it automatically rounds the numbers eg 50,900,000 displays as 51 but my clie…
-
Person id equals to 0 using the Person Profile Real time subject areaSummary: Person id equals to 0 using the Person Profile Real time subject area Content (please ensure you mask any confidential information): Hi experts, we are facing t…Oriana L. 21 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Infolets - hide 'Edit Titles and Views' buttonIn the Analytics/Infolets section on the HCM homepage, employees have access to a button in the top right of each infolet to either 'Edit Title and Views' or 'Hide'. Is …Edward_Cowne 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Remove Edit Capability from the Reports Shared Folder but Retain Edit Capability in the My FolderSummary: We are trying to update report permissions to remove the edit capability from the shared folder but retain the ability to edit in reports in My Folder. We have …G. Class-Peters 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.Shanna Oppenheim 32 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
oracle epm narrative reporting, can I choose a specific day for running reports. e.g 31/12/2022Summary: My client wants the ability to run a report, and the two grids on the report show for example, 31st June 2023, and the second grid to show 31st Dec 2022. Is thi…
-
Narrative Reporting Font in Embedded Doclet Revert in Document after Refreshing ContentHey everyone, I've run into what I believe to be a bug. I made a tabular report in Management Reporting that was first in Arial but has since been changed to Times New R…
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 298 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
-
How to get Oracle Cloud Connect? (Query only tool like SQL Developer)Summary How to get Oracle Cloud Connect? (Query only tool like SQL Developer)Content Hello, Does any one know how to get Oracle Cloud Connect? It is a query only tool li…