OTBI
Discussion List
-
How can I get values entered on a prompt displayed on an OTBI report?Summary: We have a Termination report that prompts for Termination Dates From & To (Work Relationship Details."Actual Termination Date"). Is there a way to see the dates… -
Is it possible to get 'Last Update By' from Recruiting Subject Area in OTBISummary: We have a OTBI Reporting Requirement to display 'Last Update By' for a job application. I can see that 'Job Application Last Update Date' is available under Rec…Antonio Moldovan 31 views 4 comments 0 points Most recent by Antonio Moldovan Reporting and Analytics for HCM
-
Emailing an OTBI Analyses does not send data for prompt selectedSummary: OTBI Prompt data selected does not match data when emailed. Detailed overview: I have a prompt built into an Analyses report, that enables a manager to select t… -
Roles and Privileges to run "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time"What Roles and Privileges to run "Costing - Receipt Accounting Uninvoiced Receipt Accruals Real Time". There are two seeded roles linked to this task: Cost Accountant (O… -
How to create report future "approver details" of requisitions in "Pending Approval Status*Summary: Customer requests a report listing future approver details of requisitions with “Pending approval” status. Content (required): The intent is to answer questions…
-
Need query to get the line level error message from the sales orderSummary: We have a business requirement to display the Error Message from the line level of the sales order in Fulfillment lines. We are getting error throw back end que…
-
How to identify Parent Buy Items from BOM Structure?Summary: We have no. of BOMs for our Manufacturing and need to identify Standard Buy Items and Parent Buy Items (not child Buy Components under a parent Buy Item Structu…
-
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Phani S-Oracle 496 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Payables Subject Area - what is the field to pull the comments at header levelI'm trying to create an OTBI payables report that pulls the data located in the comments field box, at the header invoice level. Where do I find it?Melissa Chan 51 views 4 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 443 views 5 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Notes on Payables Invoices in OTBI Subject AreasWe have received a request from the business to include manually entered notes against Payables invoices in certain existing OTBI reports. After reviewing all the Payabl…Simon Wall 171 views 2 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management -
Is it possible to combine one Finance subject area and also HCM subject area in a single OTBI reportSummary: Is it possible to combine one Finance related subject area and one HCM related subject area in a single OTBI report. Content (please ensure you mask any confide…Akhila N 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Veteran Self-Identification Status - no results in OTBI Person Real Time SA **Updated**Summary: I have the 'Veteran Self-Identification Status' along with the other Veteran statuses in multiple analyses and dashboards. Recently, sometime after 8/15/2024, t…Susan Anderson 111 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 779 views 5 comments 0 points Most recent by Gokul Reporting and Analytics for HCM -
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a…Mark Stoker 132 views 2 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
When I prints checks in AP, the first page starts a little higher than remaining pagesSummary: We have to print AP checks to a check stub. So we prepared the rtf. But in the pdf version, the first page always starts a bit higher than remaining pages. All …Bindu Jayakumari 11 views 1 comment 1 point Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Is it possible to use multiple letters in the 'begins with' filterSummary: We have some OTBI reports that we use an agent to schedule and they have gone over 25k rows so now they are not including the full data set (currently 44k rows)…CarolineH 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
PO Work Confirmation report with Invoice detailsSummary: PO Work Confirmation report with Invoice details Content (please ensure you mask any confidential information): Can someone help me provide a sample report cata… -
OTBI with Deep Link Sample Report for Purchase OrdersSummary: Hi, we have a requirement to enable drill feature on Purchase order number in the OTBI report. Clicking on PO number should enable to navigate to the Applicatio…
-
OTBI : How to customize the seeded OTBI dashboard and analysis used in the dashboardSummary: Hi All, I have to customize the line manager dashboard -> Absence (tab). When I click on edit dashboard -> edit the analysis, I can see the analysis. But I want… -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 101 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…Luis Orihuela 11 views 3 comments 0 points Most recent by Luis Orihuela Reporting and Analytics for ERP
-
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
Funds Available Balance reportProblem Summary Funds Available Balance report Problem Description As per "Using Financials for the Public Sector" guide under: Surplus Funds to Carry Forward A sample o…