Reports
Discussion List
-
In Salary report one employee showing two records, difference is one is old salary second new salarySummary: HI Team, In Salary report one employee showing two records, only difference is one is old salary and second one new salary , how can we get latest record (New s…AjayKumar Maddipati 61 views 8 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM -
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai… -
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 11 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Enhanced Analysis with parameters changesSummary: Created a Reports and Analytics Analysis which others users can run. Then I made modifications to the Analysis, saved it and now the others can still only run t…David Kubiak 11 views 3 comments 0 points Most recent by David Kubiak Reporting and Analytics for HCM
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 1 view 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 71 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 21 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
OTBI Learning course detailsSummary Need help to find attributes in subject areaContent Hello everyone, I am having trouble to locate the attributes for the following fields in learning subject are…User_2025-02-05-11-42-08-011 55 views 5 comments 0 points Most recent by VenkataSubbareddy Reporting and Analytics for HCM -
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 32 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Setup table to pull Approval rulesSummary: Setup table to pull Approval rules Content (please ensure you mask any confidential information): Hi, Could you please advise setup table to pull out Approval r…Bhavna-Civeo 52 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Date Calculation formulaHi, I've a requirement where I have to show some data based on future dates and also print dates like First Calendar Date of Next Month, Last Calendar Date of Next to Ne…Ninja 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 21 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Track changes to Primary National Identifier (social)Summary: Track changes to social (Primary National Identifier) Content (required): Have a requirement to identify changes (within the last 30 days) to a person's Primary…
-
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it…
-
Quick Action Employment Start DatesSummary: Report to identify details when Quick Action Employment Start Dates is used Content (required): Need a report that shows when a Hire Date is changed when using …JHaden3 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get previous experience of employee plus current company experience in OTBI or BISummary: Hi Team, we have requirement to get the previous experience of employee in OTBI is possible. In BI , we used (ff_user_column_instances_f fucif.value as experien…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Maintain Meta Model and IndexHi, We have a Maintain Meta Model and Index process in error in scheduled processes. This was scheduled by someone who is now a leaver, so may be the reason for the erro…Daniel.McDermott 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sample OTBI Report and Dashboard Workforce Compensation moduleSummary: Content (required): Hello experts, our customer want to see some delivered OTBI Analysis and Dashboards for workforce compensation module. I've tried to open th…Valerio Curzi 427 views 16 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Vacant Positions in SQLSummary: Hi I have had a request through to list vacancies per Position Code/per CC. But instead of having one row per vacant position, it needs to have as many rows as …
-
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report?
-
Connect Oracle cloud HCM to MS power BI reportSummary: Connect Oracle cloud HCM to MS power BI report Content (please ensure you mask any confidential information): Hi, Is it possible to connect Oracle HCM data sour…Bhavna-Civeo 71 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Where are calculated measures housed in the catalog for OTBI ?I've created measures for different reports (not sure which ones), but want to re-use them. Where can I locate them in the catalog?
-
Aggregate all notifications from Oracle HCM Cloud into single daily email/ report.Hi all, We have a requirement in which we are looking for a way to a aggregate all notifications from Oracle HCM Cloud into a single daily email or a report, sort of lik…Ioannis Adamou 61 views 2 comments 2 points Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des…Anil Pillaresetty 282 views 21 comments 1 point Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages?Summary: How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages based on logged user. Content (required): We have a Dashboard; i…Ravindr-Oracle 104 views 5 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Learning Ad hoc Access Group Deleted From UI are showing Active in BIP tablesSummary: I am fetching all the learning items along with access and access group assigned to them. Once I created access using Access tab under Learner tab I am able to …Kamini Kaushik-Oracle 31 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM