OTBI
Discussion List
-
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 211 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 114 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 802 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 152 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…
-
Data Model link between FSCM and OBIEE latencySummary: Data Model link between FSCM and OBIEE too slow. Content (please ensure you mask any confidential information): When I create a financial data model that links …
-
How to run report to pull specializations and courses on a single report?Summary: I need to run a report with all specializations with the courses in the specializations with course sequencing position. I don't need any user information, just…
-
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Which table stores the PO fund check information?Hi all, I'd like to create a report about PO line funds check. May I know which table stores the information about PO funds check status? Thanks in advance! -
Budget Vs Actual reportSummary: Is there a Budget Vs Actual vanilla report/ OTBI report? Content (please ensure you mask any confidential information): Version (include the version you are usi…
-
What is table and column name for project budget dateSummary: Hi All We want to know the date of final approval of project budget with current baseline or current and original baseline. We need this: Please help us to find…
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject…SERGIO BARRETO 735 views 9 comments 0 points Most recent by MFlannery Reporting & Analytics for Sales -
Unable to open reports under Reports to work area mapping in oracle fusion?I am currently experiencing an issue with accessing the reports under the "Reports to Work Area Mapping" section in Oracle Fusion. Could anyone kindly assist me in resol…
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b…sailesh_cloudare 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
BI publisher reports using Custom Subject Area objects show Slow PerfomanceSummary: Hi, we defined several custom objects in our sandbox and created Custom subject areas to develop reports by using fusion bi publisher In general, reports are wo…Joseph Rodriguez 22 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP