Reports
Discussion List
-
What's New in 20.05?Summary ... a really good feature, IMO!Content Here we are again.... given the current, worldwide situation we all find ourselves, I'll share a quick update that someone…Mark Rinaldi-Oracle 171 views 6 comments 16 points Most recent by User_2025-02-06-11-55-10-982 Planning -
Question in the behavior of scheduled BI jobs.Summary How the scheduled BI jobs will behave during the Oracle monthly and Quarterly maintenanceContent During the Oracle monthly patch or Quarterly updates, how the sc…GTS Narayanen 29 views 2 comments 0 points Most recent by GTS Narayanen Reporting and Analytics for HCM -
Joining Workforce Management & Expenses Subject AreasSummary Seeking to merge details from Expenses subject area in to Workforce Management reportContent I have multiple HR-centric reports the draw on the Absences, Compens…User_2025-01-28-21-32-42-630 29 views 2 comments 0 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
Row Sum Function Does Not Work CorrectlySummary Sum function on rows not accurateContent I am converting reports from FR to MR. Several reports have row formulas using the Sum function. It appears to not be wo… -
Definitive solution for Error 500Summary Forget Accounts toolContent Hi All, When a user id gets changed in Fusion Applications, the subsequent login for accessing of the BI application (Reports & Analy…Alvaro Couto 95 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM -
Logical SQL - adding column selectorSummary Is it possible to add a "column Selector" to a Logical SQL report?Content Hi, I am trying to add a "column selector" to a logical SQL report. I would like to giv…Mitch_123456 50 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Get a list of languages for people in the systemContent Hi, We have 10,000 people in our HCM instance. How do I bring back each individuals language skills So given a suffix or a person_id, I want to bring out the fol… -
Need to find the Owner of the BI ReportSummary Need to find the Owner of the BI ReportContent I need to know the owner(who has created) the report for almost 85 reports.is there an easy way to do that. Or do …User_2025-02-05-02-11-29-794 29 views 5 comments 0 points Most recent by User_2025-02-05-02-11-29-794 Reporting and Analytics for HCM -
Excel Template maximum row issueSummary Excel template maximum row issueContent Hi Team , We have created Excel template for one of our report but the number of lines getting exceeded 65536 , so the ou…User_2025-02-05-04-35-46-440 36 views 6 comments 0 points Most recent by User_2025-02-05-04-35-46-440 Reporting and Analytics for HCM -
Calculating Hours for Salaried EmployeesSummary Requirement to calculate hours for salaried employeesContent We have a report requirement that fetches Earnings and Hours for all employees for each pay period. …SuryaMuralidharan 136 views 2 comments 0 points Most recent by Crystal Starr-Oracle Reporting and Analytics for HCM -
How to get the classroom for an Activity learning item?Content Hi everybody, I should report the classroom for Activities but I am not able to get it. I don't find the link between the activity id and the classroom id (this … -
OTBI - How to download Archive file via web serviceSummary OTBI - How to download archive file via web serviceContent Hi, I'm considering to automate below archive process through web service. 1. Navigate to report path … -
Linked Report in Report Package Reference DocletSummary Whenever we rename the report or move it to different folder, the linked report checkmark for that report in reference doclet disappears and resulting into unlin… -
PBCS - Burst reports to Excel in Financial Reports?Summary Can we burst FR reports to ExcelContent Hi, We have an SR on this, but Oracle won't address functionality requests there. We are wondering if it's possible to bu… -
Unable to Export HTML Narrative View for OLC Learning CertificateContent Hello, I followed this post to create an Oracle Learning Cloud certificate in OTBI using HTML with the attached report and Narrate View code. It is displaying pr…User_2025-01-31-00-25-12-234 38 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
List of values as direct reportsContent Hi all, I am building a SQL repprt for the manager and it has a filter to show only direct reports in the list of values. How can I build to security to only dir…Misbahul Khair 51 views 6 comments 2 points Most recent by Laksh Kapoor Reporting and Analytics for HCM -
How to delete duplicated records in OTBI AnalysisContent Hello experts, I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only. However, the analysis return…Valerio Curzi 1.2K views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Infolet Repository Icon not visibleSummary Infolet Repository Icon not visibleContent I have many infolets set to visible on the Home configuration page but I am still unable to view the infolet repositor…Gabriel Stephens 56 views 5 comments 0 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
Understand SQL Query for Talent profile data modelContent Hi Everyone, I have created the data model for talent profile print action with the help of delivered data by oracle. In delivered data model oracle has used a s…Misbahul Khair 106 views 3 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Creating Data Model - Issue Loading PageSummary When attempting to create a Data Model, page only partially loads.Content Hi All, I've been trying to crack my brain at this. I am trying to create a New Data Mo…Shummy 27 views 11 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reports (and Dashboard) SharingSummary Request for best Practice for Reports (and Dashboard) SharingContent Hello all! We have newly implemented HCM Fusion and received little guidance concerning Repo…User_2025-02-05-11-42-08-011 146 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to use DTS in FRS Prompt SectionSummary How to use DTS in FRS Prompt SectionContent Is there any way to use the DTS functionality while FR prompts for a period selection? Thanks PrakashUser_2025-01-30-01-37-34-387 29 views 7 comments 0 points Most recent by User_2025-01-30-01-37-34-387 Planning -
How to get UI value on SQL outputContent Hello Experts, How we can pull or put some conditions to get the result. Eg. There are few fields with drop value like Yes, No but when I am pulling the data thr…Misbahul Khair 22 views 3 comments 1 point Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Want to compile reports and other documents to create convenient and dynamic briefing books?Summary Orient yourself with Management Reporting books.Content Watch to see how to create a single PDF compilation of management reports, books, reports and other docum… -
Unable to view Full-Time Equivalent value from OTBIContent Hi All, We created OTBI report based on "Workforce Management - Worker Assignment Real Time" subject area but unable to view "Full-Time Equivalent" data from OTB… -
Future Terminations and Project CostingSummary Transactions associated with employees that have future dated terminations are excluded?Content We are having an issue with the subject area, Project Costing - A… -
Changing the report header logo based on the legal entity in rtfSummary If legal entity is x then it should show x logo , else if legal entity is y then it should show y logo.User_2025-02-07-09-10-02-492 42 views 5 comments 0 points Most recent by User_2025-02-07-09-10-02-492 Reporting and Analytics for HCM -
Adding security to position report to limit resultsSummary Limiting the results of a position report according to the logged in userContent We have put position hierarchies in place so each position now has a parent posi…s_b 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
GL Account Details Report needed with Project Accounts when usedSummary In order to ensure we can reconcile GL transactions to project accounts a report that contains this data is needed from the GLContent We are in need of report, s…User_2025-02-04-23-07-55-706 70 views 5 comments 0 points Most recent by User_2025-02-04-23-07-55-706 Project Management