OTBI
Discussion List
-
What Table is the Role Code found in?Summary: Writing a query and Need to know what Table the Role Cod is found in? Content (required): -
Trying to create an OTBI Filter to convert string to DATE with current YEARSummary: Hi, I am trying to create an OTBI analyses that takes a DFF ATTRIBUTE5 in text format with the month and day, and then compares it to the date of the current ye… -
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…Mickel.Rmeily 52 views 4 comments 0 points Most recent by Mickel.Rmeily Reporting and Analytics for ERP -
Security Reporting: Who Logged in and When and did whatSummary: Content (required): We need to report on the following areas: Who logged in/out and When? What actions the user has done? Which Pages the user accessed? Which T…
-
What is the difference between Order Date and Creation Date?Summary: Content (required): What is the difference between Order Date (Time folder) and Creation Date in Procurement - Purchasing Real Time subject area? As per the ana…
-
Asset Transactions Real Time'. Which subject area can be joined to get the project informations.Summary: Hello Team, I am using this subject area to get the asset transactional details. I need project information. Which subject area can we join so that we can get t…Suhitha K-Oracle 22 views 2 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
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 180 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 402 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 982 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 74 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 102 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 32 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 126 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.9K 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 75 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 933 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 640 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…