OTBI
Discussion List
-
SQL query to generate Fiscal Classification Code on customer profile & site levelSummary: Need help in determining SQL query to retrieve fiscal classifcation code from customer profile & site level. Content (required): Hi all, What SQL query should I… -
Data modelling in OTBI?Summary: Hi In Payables (and therefore also in the Procurement subject areas such as Procurement - Spend Real Time) it sometimes happens, that an invoice is matched with…Anders W. Langholm 21 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
How to put current financial year filter to date columnSummary: hi we are developing an Otbi report to find out the revenue recognition amount for the current financial period, can any one suggest us, how to put the filter o…
-
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaRamaKrishna-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 32 views 0 comments 0 points Started by Ananda Bhargav Potluri Reporting and Analytics for ERP
-
Editing a page using sandbox subjected to a user roleSummary: Content (required): Hi All, We have a requirement to publish the dash boards created using OTBI analysis in the 'My Dashboard' page. However, the published dash…Vipusha Chandrakumaran 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Which function can be used to display only one value from multiple values result?Summary: Display the first value from a result including many values Content (required): We're using an OTBI analysis for delayed PO deliveries and we've supplier's deta…
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 193 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
Supplier Qualification Infolets page showing initiatives status graph by login baseSummary: Supplier Qualification have Infolets page showing initiatives status by graphical view by the login base and customer want to see the globally ,how many initiat…SivaRamaKrishna-Oracle 32 views 3 comments 0 points Most recent by SivaRamaKrishna-Oracle Reporting and Analytics for ERP
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows Financials OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was availa…Ibrar Hussain 32 views 2 comments 0 points Most recent by Ibrar Hussain Reporting and Analytics for ERP
-
Analysis - SQL expressionSummary: How to get first month of previous date - SQL Expression (Criteria ) Content (required): We have created a Analysis report and business needs to schedule this a…
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Is it possible for an analysis to link to a dashboard prompt?Hello, I would like to link one analysis to the prompts on a dashboard which will then update another analysis. Is that possible? Thank you, Julia Oracle Fusion v23AJulia Looi 32 views 1 comment 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
OTBI Dashboard combining two subject areas of two different modulesSummary: We want to prepare an OTBI dashboard having 2 analysis. First analysis will pull the data from Procurement contracts module for lets say 10 suppliers and then s…Vicky Adwani 84 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment…Anders W. Langholm 185 views 5 comments 0 points Most recent by Julia Looi Reporting and Analytics for ERP
-
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
View Contract Authoring Party in OTBI?Summary: We are trying to see which contracts were created with an "external" authoring party or an "internal" authoring party, as well as which contracts had the contra…Jennifer Popowicz 41 views 0 comments 0 points Started by Jennifer Popowicz Reporting and Analytics for ERP -
Error Code : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Hi All, I created a custom OTBI report. I have used two subject area : Subledger Accounting - Journal Real Time and Payables Invoices- Transaction Real Time The…
-
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …Santhi Sree 103 views 11 comments 0 points Most recent by Santhi Sree Reporting and Analytics for ERP
-
Ability to create a Analysis report in OTBI from Manage External fileSummary: Hi How can we implement a process where a third party stores/sends/puts a file in a designated place, and we pull data from that file to create an OTBI report? …
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
Subject Area - Payables Invoices - Transactions Real Time - distribution amountSummary: Using Payables Invoices - Transactions Real Time, The Invoice Distribution is getting incorrect amount after adding Overridden account concatenated segments Col…JSalarza 93 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…Janitha Perera 665 views 9 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 125 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
User unable to create report in OTBISummary: User unable to create report in OTBI Content (required): Is there a request that must be submitted for users who have access to various subject area, but are un…CraigX 111 views 5 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
OTBI Report Showing Budget Measures for All TasksHello, I am trying to create an OTBI report that shows the following Tasks for a project starting with the "Project Control - Budgets Real Time" but when I add the Budge…
-
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 42 views 3 comments 0 points Most recent by Santa_B-Oracle Reporting and Analytics for ERP
-
OTBI Analysis - How to pass only Date for column that is having date and timeSummary: Content (required): The below condition is failing as Application Creation Date is returning date with timestamp and Current_date is returning only date. Applic…DPM 414 views 4 comments 0 points Most recent by User_2025-07-18-16-26-02-907 Reporting and Analytics for ERP
-
Customizing data model in BI Publisher (Cost Detail Data Model)Summary: I would like to add some fields to the data model "Cost Detail Data Model" in Assets Balances. Content (required): I have copied the file to the custom folder, …Anders W. Langholm 139 views 3 comments 0 points Most recent by Akshay Acharya-Oracle Reporting and Analytics for ERP
-
Unable to see Creation date of Project Enterprise Resources in any subject areasSummary: We have below requirements:- Report to be sent to resource pool manager when a resource with back dated date is entered (for ex: Resource is created with date 0…