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 3 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…SivaKrishna-Oracle 12 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 2 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…
-
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 82 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…SivaKrishna-Oracle 12 views 3 comments 0 points Most recent by SivaKrishna-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 11 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 52 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 21 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 31 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 32 views 3 comments 0 points Most recent by User521494-Oracle Reporting and Analytics for ERP
-
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …
-
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 22 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… -
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 4.9K views 137 comments 41 points Most recent by User_BO0MP Reporting and Analytics for ERP -
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 D Clark 12 views 0 comments 0 points Started by Jennifer D Clark 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 33 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? …
-
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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…user12240811 11 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 31 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…Sasidhar_Araja 23 views 0 comments 0 points Started by Sasidhar_Araja 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 82 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 32 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 42 views 5 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP