OTBI
Discussion List
-
ERP - Testing Automation ToolsContent We would like to know of any success stories of companies who have automated their testing in Oracle ERP (Financials or Procurement). I've been looking around, a…Rihan Jameel 62 views 3 comments 3 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
Dashboards graph PropertiesContent Hello! I added some pie charts in a Dashboard but they are displaying misaligned even if they have the same graph properties. In attachment a screen showing the …Chiara Arcidiacono 30 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 32 views 1 comment 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Anniversary ReportSummary Anniversary ReportContent Hi ALL, Need help in creating a report which populate employee who will complete there 1 year anniversary with company tomorrow. ex. Em…User_2025-02-07-19-03-14-525 103 views 16 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
How to Report available working hours of all Employees in a department excluding Absence HoursSummary OTBI Report for Available Working Hours of All Employees using either FTE or Normal Working Hours from Employee Assignment by excluding the Absence Hours during … -
Custom Columns with field from different Subject AreasContent Hello, I am working on a report that has 2 subject areas (SA). I am trying to include a column with a formula (CASE WHEN statement) using fields from the 2 subje…User_2025-02-05-06-26-19-951 57 views 5 comments 1 point Most recent by user5070067 Reporting and Analytics for HCM -
Custom View Creation in FusionContent Dear All, Once of our Customer is migrating to Cloud from EBS, They have a custom report in R12 which they want to create in Fusion cloud. For Custom report in R…Khaleel Shaik-175919 70 views 1 comment 1 point Most recent by User_ZLFIU Payables, Payments & Cash Management -
PPM Cloud - OTBI - Project task's labor resources - Table or OTBI subject area?Content I'm trying to create OTBI report where should be project tasks and labor resources assigned to the tasks (see attached picture). What is db table or OTBI subject…Jaakko Kiviharju 50 views 4 comments 0 points Most recent by Pradeep Balakrishnan Project Management -
How to link or add Negotiation details like Negotiation Number, Award Date etc. on PO or AgreementsContent Is there any way to link the negotiation details (negotiation number and award date) or be transferred automatically from negotiation to PO or agreements that ar… -
Is it possible to apply positive depreciation when asset cost is Zero?Summary Is it possible to apply positive depreciation when asset cost is Zero?Content Hi, Is it possible to apply positive depreciation when asset cost is Zero? I tried …Balakrishna Sivappagari 26 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Assets -
recruitment facts/metricsContent Is there a way to pull # of applicants submitted to Manager, how many of those were rejected - or each phase how many touchpoint did recruiter make with applican…Riti Malhotra 44 views 2 comments 0 points Most recent by Dhiraj Hadkar Reporting and Analytics for HCM -
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in… -
End date for scheduled processSummary Need to be able to report on end date used when process scheduledContent Hi, I need to create a report that will show the end date of the schedule created for a … -
Analysis failing with error: Exceeded configured maximum number of allowed output prompts, sections,Content Hello Experts, I had built a dashboard using the Absence Calendar Details Real Time subject area having two sections - Summary and Detail Analysis reports. I had…Akash Kiran Jana 27 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Report for overtime hours and regular hoursContent We have a requirement to develop a SQL report based on Over Time hours and Regular hours capturing from a third party device. Suppose we are not creating any pay…User_2025-01-28-21-18-43-496 246 views 3 comments 0 points Most recent by Sudakar Babu Sunkesula Reporting and Analytics for HCM -
Last person who have made changeSummary Hi I need ton know who's the last person made change on a person's role or privilege.Content Hi I need to know who's the last person made change on a person's ro…sasamimi 44 views 1 comment 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Proper Case Function in OTBIContent Is there a function in OTBI that transforms character strings from their current state into PROPER case format? For example: 'JOHN SMITH' or 'John SMITH' to 'Joh…Dustin Dominic 41 views 2 comments 2 points Most recent by Dustin Dominic Reporting and Analytics for HCM -
Percentage split cost centres in OTBISummary Unable to find percentage split cost centres in OTBI on payroll relationship levelContent Hi, I am trying to create an OTBI report which displays employees who h…User_2025-01-30-03-54-32-528 113 views 12 comments 2 points Most recent by Urvashi Jain-261257 Reporting and Analytics for HCM -
Dynamic printing of column labels in OTBI or BI PublisherSummary Dynamic printing of column labels in OTBI or BI PublisherContent Hi All Kindly share your experiences on how you have been dynamically creating reports with titl…User_2025-02-08-03-05-58-849 18 views 1 comment 2 points Most recent by User_VLBBP Reporting and Analytics for HCM -
Document Records Details and Corresponding ApprovalsSummary Document Records Details and Corresponding ApprovalsContent Hi, Are we able to produce a report which details the Document Records and the corresponding Approval…