OTBI
Discussion List
-
HCM Compensation/Payroll Element Entries History Real Time Excluding Inactive / Terminated EmployeesSummary: Payroll - Element Entries History Real Time does not appear to be returning data if the employees latest assignment is inactive (the employee is terminated). Co…bwdata 49 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a table which holds the certificate information within the security consoleSummary: Is there a table which holds the certificate information within the security console for users. I need to see what certificates employees have associated with t…
-
Report on Active/Inactive UsersWe have a list of users (not employees, these are users created in the security console; our implementation partner) and I want to report on these users and whether or n…Alex Cardenas 516 views 9 comments 1 point Most recent by Girish Bhatia Reporting and Analytics for HCM -
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need to pull in Seniority Date using SQL and add to an analysisSummary Adding Seniority Date to my Logical SQLContent Hi All, I hope someone is able to help me out. We currently have an Analysis that we were using to produce a repor…User_2025-02-04-08-51-08-912 800 views 3 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
Access run history & older report outputs of OTBI scheduled reportsHi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output o…Ameya_J 23 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to build an analysis report of all pay periods that exist to dateSummary: I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is t…sarah_1000 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Link Produce Costing Setup Details with Assignment DataSummary: I am trying to link data from the following two subject areas:- "Payroll - Payroll Costing Setup Details Real Time" "Workforce Management - Worker Assignment Re…Mark Stoker 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Headcount is not being populated in Work Measure tableSummary Some employees have rows for HEAD others don'tContent Hi There, Does anyone know why HEAD information is populating for some employees but it is not for others? … -
we joined two subject areas but when we apply single country it is woking fine but multiple not workSummary: Hi All, we joined two subject areas but when we apply single country it is woking fine but multiple not working. stlll searching mode ? subject area: workforce …AjayKumar Maddipati 22 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 44 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 131 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…jahanavi metta 54 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Dashboard prompt for effective date reporting possible?Summary: Hi all, I have added SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; into the advanced tab under prefix for a OTBI analysis …Ian.Gooderham 135 views 8 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…Harish S 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star…ClaudiaManea 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …Harish S 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 13 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Importing Oracle JET Visualizations in OTBIWe have an ask from the Customer if we can import Oracle JET Visualizations in OTBI We checked the above link to explore Oracle JET Visualizations but not really sure on…Chinmay Gharpure-37456 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Error when copying a report shortcut to another folderSummary: We are trying to setup a folder containing shortcuts to reports that are located in various folders across the OTBI tool, in order to simplify access to commonl… -
Succession Plan Report IssueHello there, We are trying to create an OTBI Report on Succession Plan Details .We have attempted to use all related subject areas for succession plan , but we keep enco…prags 21 views 3 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
Termination Approval Process ReportHi… does someone have a report, either an OTBI or BIP, that captures the full termination process with comments, who it is/was assigned to, and status. We are having iss… -
Matrix Managers field onto a reportSummary Need to pull Matrix Manager field onto a standard OTBI reportContent Need help to understand how can I pull Matrix Manager field (Type as Matrix Manager in myHR)…Abhishek Bagh 230 views 3 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time - no data being returnedSummary: Trying to build a report showing employee bank account details from SA 'Payroll-Personal Payment Details Real Time' - I have the required roles (Payroll Mgr etc…
-
If a EFF does not have a value is there a way to pull it into reporting?Summary: We have some positions that have Extensible flex fields entered for Background checks and Licenses - but some of the positions do not have this yet (so essentia…THawkins_LGI 61 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte…
-
How do I remove notes formatting in reportI have a reprot that pulls notes information which users can format. How do I change the output to where the special characters do not show up on the report?erpexpert03 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM