OTBI
Discussion List
-
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
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
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 624 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 52 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 162 views 1 comment 1 point Most recent by User_5XX7A Payables, Payments & Cash Management
-
How to join two subject areasSummary: Hi we need to join worker assignment real time and documents of real time and may i know what are the join columns of two subject areas Content (required): Vers…AjayKumar Maddipati 41 views 2 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Fusion 22A/22B : Post P2T Issues in BISummary: Oracle has brought a big change in OTBI/BIP configurations during P2T where configurations will be copied to the Non-Prod instances from the Prod instances. Thi…User423246 71 views 3 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for HCM -
possible to change the My negotiations infoletSummary possible to change the My negotiations infoletContent Is it possible to change the My negotiations infolet? the infolet is not bringing the information from the … -
OTBI Absence report shows different end dates on different browserSummary: Content (required): We have an absence reports which shows the employees absence. Absence type, start date and end date. However depending on which browser I us…Nicolas Vahman 71 views 9 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM