OTBI
Discussion List
-
Code Combination ID field from Payable Invoices-Transaction Real Time subject Area for Invoice LineSummary: Distribution tab details are not available for an Interfaced Invoice prior to validating the invoice in Oracle fusion. We are trying to create an OTBI to displa…Sifat Shaikh 81 views 1 comment 0 points Most recent by Swapnil Nagvekar-Oracle Payables, Payments & Cash Management -
Difference between "PO order date" and other datesSummary: While create reports under "Purchasing real time" subject area in OTBI, we have multiple time/dates available. I need to concept of "Order Date" and how does it…
-
How to add values from column to Dynamic column in OTBIHi All, We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement. We…Chaitra Lakshmi Krishna 41 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Convert Fact columns into Measure type in OTBI to get subtotalSummary: Hello, We are building a basic report and we try to view total for Total, Taxable Monthly, Non Tax Monthly etc based on Accounting Date. The issue is that all t…Raluca Balan-Oracle 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Advanced filtering OTBI Analysis reportI have a report for a course. I have selected the filter for the Sub Status = Completed, Not Started, Withdrawn, Deleted. However, although I want the results to pull th…
-
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
How to get Award Approval Date in OTBI?The item in OTBI has Award Date and Award Completion Date, but the item in Award Approval Date does not exist. Where can I get it? -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
OTBI - Performance Subject area & field to pull Evaluation Topics, Perfomance and Core Value ratingsSummary: We need a report that pulls the manager ratings and comments from the Evaluation Topics section for the performance and core values. Content (please ensure you …Denise Izzi 133 views 2 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav…
-
BIP Reports Metadata tablesSummary need Metadata tables for BIP reportsContent I am looking for the fusion table(s) that store metadata of reports (such as created by and timestamps). can someone … -
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 22 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
Control Budget data in OTBISummary: Hi We have some users who do not have the budget manager role. Can we write OTBI reports or BIP reports for them to view the real-time data (these users don't h…
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI ReportHi All, How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI Report like below image?. Please share us your Ideas or Implementati…Sukumaran Ayyaswamy 31 views 3 comments 0 points Most recent by Manasi.Singh Reporting & Analytics for Sales
-
Succession Plan ReportHow to view All Private succession plan available in system in OTBI ?prags 61 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tip on how to remove the dashboard header when embedding in a screenSummary Tip on how to remove the dashboard header when embedding a dashboard into a custom pageContent I have been asked a few times recently if it is possible to embed …Caroline Gladwin-Oracle 389 views 7 comments 10 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 43 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Requisition PDF Report With Data Model,Custom translation file does not workSummary: 1-We want to customize the layout for the new (Requistion PDF report with data model) 2-After create a new template with locale (English) Language 3-We extract …Mustafa Abu Dayeh 12 views 2 comments 0 points Most recent by Mustafa Abu Dayeh Self Service Procurement
-
Difference between OTBI subject area "Real time" and those without "Real time"Content Hi all, Please explain as to what is the difference between the OTBI subject area "Real time" and those without "Real time" . Best Regards, VipushaVipusha Chandrakumaran 70 views 7 comments 2 points Most recent by RyanPasca1 Reporting and Analytics for ERP
-
Disable email notifications for Non Catalog Learning ItemsSummary: Hello We would like to disable any notifications for non-catalog learning items added but can;t see any documentation on how to do this. It isn't controlled via…
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 31 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…Jo Kelly 247 views 4 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Balance Sheet by Project: Does this necessitate a project GL Segment or is there another way?Summary: We are in the design phase of a Financials and PPM implementation. Customer desires Project Balance sheets. Other than creating a GL segment for project (not be… -
Is there a way to review users' usage of self service procurement?Summary: Is there a report which we can run to review when users last used their access to self service procurement, in order to manage which users require access? Conte…