Reports
Discussion List
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…James Hoffmann 117 views 22 comments 1 point Most recent by James Hoffmann Reporting and Analytics for HCM -
Server Message Block(SMB) protocol in BI ServerSummary SMB protocol to connect to Active Directory serverContent Hi All, We would like to send a CVS report from our HCM BI Server to AD server. Our AD team has asked u…Alvaro Couto 18 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM -
Performance Document Submission Date and HourContent Hello experts, How can I track the Performance Document Submission Date and Hour in reporting? Are there any field in OTBI reporting that allow me to get these i…Samanta Lorando 14 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM
-
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 643 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM -
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 109 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 86 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 455 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 28 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 52 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 49 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 167 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 38 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 35 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 56 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 34 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 236 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 90 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 70 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 306 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 36 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 28 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 30 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 74 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 137 views 2 comments 0 points Most recent by Crystal Starr-Oracle Reporting and Analytics for HCM