OTBI
Discussion List
-
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…Khush Tiwari 31 views 16 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI Report Usage - Count of Dashboards run (not executions)Summary: I've found the Usage and Performance Dashboard Sample (catalog files attached) and it looks pretty great but we're struggling to make it work for us. We want to… -
Recruiting Dashboard PDF downloadSummary: Content (required): Hello, The functionality used to download a Recruiting Dashboard page doesn't work anymore. We usually used this html code:Giuseppe Iacono 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…Vijay Rajendran 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dashboard / reports on Anytime Doc, Check In...etc.Content Hello! I am reaching you because I am preparing a demo for a client and I would need a dashboard about all the "continuous" performance functionalities (feedback…Virginia M. Calvi 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Dashboard Embedded not workingHello, OTBI Dashboard embedded using Page Composer is not working, where as when I'm running Dashboard in analytics its working fine. I've attached the screenshots and c…san1 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way to have an OTBI analysis house legacy data and act as a reference table?Summary: Is there a way to enter in data into an OTBI analysis and have it act as a reference table? Content (required): We have a data export of historical data from a … -
Create a message before running a BIP ReportSummary: Hi, Is there any way we can create a message to show before running a BIP report with prompts in OTBI Content (required): Version (include the version you are u… -
Is there a provision to hide the formatted or Data option in OTBI?Summary: Feature to hide or unhide the formatted or Data option in OTBI Content (required):We have developed a report with the Pivot option. While exporting the data if …Venkateswaran Murali-Oracle 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
FAH to GL reconciliation reportSummary: FAH to GL reconciliation report Content (required): Hi All, I am looking to prepare FAH to GL reconciliation report. This report should provide the details of a…Mayank Patni 151 views 1 comment 0 points Most recent by Harshad N Godbole Subledger Accounting & Accounting Hub -
Subject Area Contents/GlossarySummary: Is there such a document or Resource as a Glossary of what measures, attributes etc are available in each subject area. Content (required): I am constantly stru…Peter Downer 51 views 4 comments 0 points Most recent by Peter Downer Reporting and Analytics for HCM -
Candidate Success of Hire ReportThis analysis displays candidate information such as past employers, education, certifications, and termination data like last position held and length of service. To ad…Dishti Malhotra-Oracle 51 views 3 comments 1 point Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
OTBI Publisher Report Job Skips even if there is data in the trigger and modelSummary: Oracle BI Publisher Report Job which is scheduled every 30 minutes gets skipped even if data is returned by the trigger Content (required): I have a scheduled r…User_2025-02-07-06-48-53-251 431 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM -
The specified criteria didn't result in any data.Good afternoon experts, could you help me with the following: An employee analysis is being created, when I consult some employee data, such as name, employee number it … -
How to handle HCM department name changes in OTBI analysis report assignmentsSummary: We have written OTBI analysis reports to make learning assignments which include Department is.... Now the Department is changing Content (required): I'm lookin… -
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level…Raghavendra M 645 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
How to CAST Char to DateSummary CAST Presentation Variable of Text to Date Prompt in FormulaContent Age Band on Line Manager Dashboard is based on CURRENT_DATE rather it should based on Dashboa…User_UM4C6 53 views 4 comments 0 points Most recent by Aslam Khuajah Reporting and Analytics for HCM -
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b… -
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…User_2025-02-04-10-47-55-876 64 views 3 comments 1 point Most recent by Harry Oracle Reporting and Analytics for HCM -
How to add any OTBI/BIP report in Simple User Interface - Analytics SectionSummary How to add any OTBI/BIP report in Simple User Interface - Analytics SectionContent Please suggest. How to add any OTBI/BIP report in Simple User Interface - Anal…Avaneesh Jain-5059 70 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
PGP Payment File Encryption and Decryption of MT940Summary Need to sign payment files generated via BI Report with Oracle PGP private key and encrypt the payment file using Bank public PGP keyContent We have this require…Christian9-Oracle 161 views 1 comment 1 point Most recent by User_5XX7A Payables, Payments & Cash Management