OTBI
Discussion List
-
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi… -
Report to have budget transfers (Control budget)Summary: Content (required): We have a requirement to have a report to include the Budget transfers. We tried to get it from the standard reports however, there is no re…
-
how to create a non-sso bi userSummary: how can I create a non-sso bi user Content (required): n/a Version (include the version you are using, if applicable):23A Code Snippet (add any code snippets th…
-
How to modify a seeded dashboard?Summary: Hi. We need to modify some elements of a seeded dashboard according to client requirements. Grateful if someone could provide standard procedures for modifying …ShailenS 104 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
OTBI Data Security - AssetsDo all Oracle saas ERP modules follow data access/role security for access to data. I have a user who has assets data availabiilty but does not have an assets role. Than…erpexpert03 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Is it possible to set up automated reports splitting data by cost centre or spare 1 field?Summary: Business has the requirement of splitting a report by cost centre or spare 1 field and sending to different receipts based on the cost centre. This is to send a…
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Give access of OTBI report to usersSummary: Hi We have build an OTBI report from a user who has BI Author role. And we need to give access of this report to other users. we have used Permissions in the OT…CS_Giri 117 views 2 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 1.8K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the …amy hardtke 77 views 5 comments 0 points Most recent by Emily McAdams Reporting and Analytics for ERP -
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…ks1075 880 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 626 views 8 comments 0 points Most recent by Khassham Khan Reporting and Analytics for ERP
-
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 33 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 34 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 31 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 211 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 31 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 31 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 81 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 190 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