Reports
Discussion List
-
SQL query time out error in BI ReportsSummary Getting SQL query time out error in BI ReportsContent Hi Experts, We are getting SQL query time out error in BI Reports. have made changes Query Time out to 1000…User_2025-02-06-19-27-47-357 115 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Job seniority date reportSummary Job Seniority Date reportContent I just created a rule in "configure seniority date" section for job, level workrelationsihp. Then i ran the populate process aga…Adil_R 102 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Identify in the Learning Catalog a learning item corresponding to a SCORM objectContent Hi, I have imported in the "Learning Catalog" some courses provided by Skillsoft. When a learner does a course, in the SCORM tables (those starting with WLF_SCOR… -
Line Manager Dashboard DocumentationSummary Line Manager Dashboard DocumentationContent Hello, Is there documentation available for details of the dashboards available in HCM like Line Manager Dashboards. …Murthy Kodavati 500 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payroll run Costing Results informationSummary We are trying to display Costing results information after Payroll ran.Content Hi All, We are able to get the Payroll run costing results through "Payroll – Payr… -
Custome Talent Profile Printing Sections that Employees Don't Have AccessContent We have created custom Skills and Qualification Print. First we have taken a copy of delivered RTF template and a copy of delivered data model and have created a…Misbahul Khair 33 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report on 20A approval data comparison featureContent I am trying to report on the new data comparison feature that was released with 20A. I want to be able to capture all of the approvals that are open along with t…Brandon Roberts 59 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are …Ryan_Sullivan 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce ManagementSummary Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce Management - Worker Assignment Real-Time subject areas in Fusion HCMCon…Mahendra 174 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fiscal CalendarSummary Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar.Content Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year …Chris Campbell 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calculated item for % assigned to courseSummary Learning DashboardContent I`m using a new calculated measure to work out the 'Capacity % Filled' for each of the courses but it won't calculate correctly. Any id…User_2025-02-06-11-18-47-896 39 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Cost Center Manager SQLSummary I require the table/link for the cost center manager fieldContent Hi I am currently creating a report that requires the cost center manager field for a departmen…User_2025-02-06-00-21-58-611 59 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Can you find what fields are used in reportsSummary With upgrade to talent, how can i find the reports that the using the old fields?Lynn B 39 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 241 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Create Infolet icon is not available on homepageContent Hello Experts, I have enabled HCM Infolets tab in analytics section on homepage. However, I am not able to see Create infolet icon. I have seen couple of posts r…Hetal Vaghela 98 views 10 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Printable Department Hierarchy chartContent Hi All, Can someone share a sample for department hierarchy printable chart? I tried with the link https://cloudcustomerconnect.oracle.com/posts/9510552320 ,But …Nivya Mathire 74 views 8 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Recruiting OTBI Report: Job requisition completed: phase and status of candidate selected brigs an eSummary I´m creating a report listing all job requisition in phase open with state complete, cancel or closed and we need to show the name of selected candidate if are. …Christian_Kaladjian-Oracle 315 views 2 comments 0 points Most recent by Christian_Kaladjian-Oracle Reporting and Analytics for HCM
-
OTBI : non-Fusion data sourceSummary Adding non-Fusion data source connection is not supported and will be deprecated in a future release.Content Got this message on the Admin page for data sources.…User_2025-02-05-23-02-10-916 42 views 10 comments 1 point Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM -
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 33 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 33 views 2 comments 0 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
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 87 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 55 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 31 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 39 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 141 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 … -
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 41 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 54 views 6 comments 2 points Most recent by Laksh Kapoor Reporting and Analytics for HCM