OTBI
Discussion List
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 84 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
How to delete shipments history collected from OPS for last one monthSummary How to delete shipments history collected from OPS for last one month. We used seeded collection to collect shipments history from fusion (OPS).Content We are tr…Omkar Panda-Oracle 63 views 4 comments 1 point Most recent by Omkar Panda-Oracle Supply Chain Planning and Collaboration -
Report Job History does not display informationSummary OTBI Report Job HistoryContent OTBI Report Job History displays for a few seconds and then screen mostly vanishes in Production.User_2025-02-10-21-24-50-036 48 views 5 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM -
Is there any query available to get the GL Transfer Date of a given AP InvoiceSummary Is there any query available to get the GL Transfer Date of a given AP InvoiceContent We are developing a custom report in which I have to get following two info…Dharmendra Shukla 1.8K views 3 comments 0 points Most recent by Dharmendra Shukla Payables, Payments & Cash Management -
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 38 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
OTBI ReportSummary OTBI Report on CashflowContent Can anyone helps us to get the simple OTBI report on Cash Management including primary things like balance sheet , income statemen…Shweta Agrawal-243936 55 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
OTBI Multi-Language SupportSummary This white paper explains how OTBI supports multi-language translation, the current limitation and the planned enhancementContent OTBI supports multi-language tr…User720640-Oracle 762 views 3 comments 7 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Configuration Fusion HCM OTBI SecuritySummary This white paper is a guide in how to configure security for HCM OTBI.Content This white paper addresses how to: * Grant line managers and employees the ability …Rebecca Emerson 550 views 3 comments 12 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Restricting BI Answers Access for Fusion Application UsersSummary This paper outlines steps that customers can take to restrict user access to BI catalog.Content This paper is published by Oracle OTBI product development. By de…User720640-Oracle 278 views 3 comments 9 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 712 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Busting OTBI Myths - NOT INContent Myth: OTBI can't give me a list of workers without goals (or absences or ...) There are a few ways to perform a "NOT IN" query. The easiest and most performant i…Julian Challenger-Oracle 103 views 1 comment 2 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Filter - AnalysisSummary Filter - Leads created in the current weekContent Hi all, Do you know how to add a filter to an analysis (OTBI) so that it only brings the Leads created in the c…Hernan Imas 18 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Procurement Master Content DocumentSummary This document will allow you to find Oracle Procurement cloud-related KM notes which are not only distributed throughout the document from flow basis but also ar…ROHIT.R-Support-Oracle 174 views 5 comments 3 points Most recent by Saravanan Subbaiya Self Service Procurement -
How to know total inventory consumption during the period along with quantity, unit cost and amount.Summary How to know the total consumption during the period Item wise or Inventory Org wise along with quantity, unit cost and consumption amount.Content Hi Team We want…
-
How can i get DFF field in the Formula based Depreciation Methods?Summary How can i get DFF field in the Formula based Depreciation Methods?Content Hi Experts, I am trying to derive the depreciation rate based on the Descriptive Flexfi…User_2025-02-06-12-01-21-534 51 views 2 comments 0 points Most recent by Saipriya Vaidyanaathan-Oracle Assets
-
Use of Variable prompt in OTBIContent Hi Experts, Greetings of the day!! Can someone please let me know the use of variable prompts in OTBI analysis. Regards, Divya Version 21ADivya Sree Kollipara 47 views 2 comments 0 points Most recent by Divya Sree Kollipara Reporting and Analytics for HCM
-
Is it possible to use bold characters and underlined text in a burst notification?Content Hi, We have a requirement to send out a burst report to all our PO owners about how much of it is invoiced, funds remained on POs etc. The Procurement team gave …
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …User_2025-02-05-06-55-02-399 175 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re…Mohit Gupta-45440 347 views 26 comments 1 point Most recent by User_2025-02-11-15-16-39-434 Reporting and Analytics for HCM -
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…User_2025-02-06-09-29-18-902 179 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo…
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 41 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…