OTBI
Discussion List
-
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 34 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Tracking Vendor Registration Duration in Redwood Supplier RegistrationSummary: We have a business requirement where the client needs to track the total time each vendor takes to complete their registration after clicking the external Redwo… -
In which Subject area to find "Negotiation and Renewal" information for Contracts for OTBI analysis?Summary: While using the OTBI analysis under Reports and Analytics tool in Oracle we noticed that there was missing information under the "Enterprise Contracts - Contrac…
-
SQL Query to get Work Definition and resourcesSummary: Hi, Can anyone provide SQL query which will fetch Work Definition and the Resources linked to it? We have Work Definitions defined in Maintenance Cloud and want…
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…Mike Pee 14 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting and Analytics for ERP
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 33 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:Shreya Agarwal-Oracle 13 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 196 views 5 comments 0 points Most recent by Emily Downum Payables, Payments & Cash Management
-
Manage Delegations ReportSummary: Is there a seeded report that would list all the active employees that are able to create expense reports for employees? There is not a way to download to excel…
-
RSUM Not working for running cost totalHi, I tried using the RSUM function to get a running total of the project actual costs (Actuals column). However, that function is not working as I expected in the last …Julia Looi 52 views 4 comments 0 points Most recent by Chaunae Walton Reporting and Analytics for ERP -
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" is returning blankSummary: Has anyone get to the bottom of this, I am trying to bring back "Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" But it is coming black as blan…
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 387 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
New accounting period open but not showing in any LOVSummary: Below we have a new opened period - "the pd 13 is specifically for audit adjustments and we'd always enter them on the last day. It's separate from Sep-13 becau… -
Sql query to get expense report attachment contentHello, Is there any way to retrieve the contents of expense report attachments using an SQL query? I need to include them in an RTF file. I want to generate a report tha…
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…User_2025-02-05-18-37-12-438 90 views 5 comments 3 points Most recent by Pratik Raval Reporting and Analytics for SCM -
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…Srushti 92 views 18 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"?Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"? If so, what is the Subject Area? I've tried several "Knowledge" SA's, and a few "…Phillip Jones 61 views 17 comments 0 points Most recent by KMChris-Oracle Reporting and Analytics for HCM -
Custom Pick Slip ReportHi Team, We are trying to build a custom pick slip report which will sort the locator by A to Z and called by Schedule Pick Wave. We need the right parameter name for th…
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
How to move OTBI & BIP reports from one instance to anotherSummary: How to move OTBI & BIP reports from one instance to another instance? Looking for the easiest way to achieve this. Content (please ensure you mask any confident…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 33 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 21 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI report is not showing po number for delivered requisition linesSummary: OTBI report is not showing po number for delivered requisition lines Content (please ensure you mask any confidential information): PO line status is closed but…
-
how to get current status of the negotiation in OTBI reportSummary: How to get current status of the negotiation in OTBI report. when I try to retrieve negotiation and its current status, it giving multiple status against each n…
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 101 views 6 comments 0 points Most recent by Suneha .-Oracle Reporting and Analytics for HCM -
Add columns to Subledger Period Exception reportSummary: How to customize the Subledger Period Exception report to add more columns in the report output and provide option to run the report in OTBI. Content (please en…