OTBI
Discussion List
-
Customer statement for ad hoc queryingSummary: I need a report (BIP or analysis), that gives me the possibility to create an ad hoc Customer Statement. Content (required): The seeded report "Generate Custome…Anders W. Langholm 51 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Requires to create a role to create reports onlySummary: We have a requirement to create a role that have access to create reports only. Where any Financials or SCM or any other modules are not given access to create …Janitha Perera 173 views 3 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…Donald 355 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
OTBI Report parameters and export optionsSummary:. 1.Check to have the parameters section display always after report is run instead of having to go to catalog and come back again to rerun the report. Update OT…
-
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us…
-
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 638 views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
How to add new Column in seeded Subject area Receivables - Transactions Real TimeSummary: I need to add column as Ready for XML (select READY_FOR_XML_DELIVERY_FLAG from RA_CUSTOMER_TRX_ALL ) Content (required): Version (include the version you are us…Amol Pachpande 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 71 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
Does exist a Job to update data in OTBI ?Summary: Does exist a Job to update data in OTBI ? Content (required): Dear All, we need to know if exist a Job to update data in OTBI. Thanks, Elisa Version (include th… -
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 81 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 1.6K views 5 comments 0 points Most recent by Hugo Martínez 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 91 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 847 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 494 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 517 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 22 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 35 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