OTBI
Discussion List
-
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 651 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 65 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 160 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
-
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can OTBI analysis be triggered based on an event?Summary: We have a requirement to send NIR Completion FYI Notification to users of other modules (Costing, Pricing, Manufacturing etc) so that they can begin their setup…
-
CASE when help for balance valueSummary: I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance ty…Greg Rank 21 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report for reverse terminationsSummary Report for reverse terminationsContent We are currently looking to build a report that has those who may have been processed as termination but then had the term…Preston Schultz 125 views 7 comments 0 points Most recent by Abderrahim Reporting and Analytics for HCM
-
OTBI formula needed for multiple IF THENSummary: I have a simple report that uses the subject area Workforce Management - Worker Assignment Real Time. The report contains Person Name, Job Code, Job Name, Depar…
-
Embed Report in UI AppSummary: Content (required): I am trying to add a report in the UI in the onboarding App- Is this possible to do? see image I tried using page composer but it doesn't gi…
-
Custom Course Completion Certificate for Specific BusinessSummary: Business is looking to have course completion certificate for their learners. Content (required): One of the businesses is looking to have a specific course com…