Get Started with Redwood: Oracle Cloud SCM and Purchasing
OTBI
Discussion List
-
Risk Management Access Violations by User ReportSummary A dashboard displaying top 10 users with control violations. Below this is a detailed view by role for a specified control and user showing the conflicting acces…Stephanie Golly-Oracle 128 views 2 comments 1 point Most recent by Uma Maheswari Reporting and Analytics for ERP -
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 71 views 3 comments 1 point Most recent by Renganathan V Reporting and Analytics for ERP -
OTBI Complete List of Subject areas and ESS Jobs to populate with dataSummary Does someone have a complete list of OTBI subject areas that require ESS jobs needed to populated the dataContent These are the only Subject areas that I am awar…amy hardtke 755 views 6 comments 3 points Most recent by Rich Merkel Reporting and Analytics for ERP -
OTBI Analysis Subject Area to Extract Employee Data for Customer CreationSummary: What subject area(s) can be used to extract a list of Employees created in HCM who have not yet been setup as Customers in Receivables? Content (please ensure y…Francine Gemora 21 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
OTBI GL Subject Area: 'General Ledger - Journals Real Time' unable to find the 'Approval Date'Summary: Hi All, While developing OTBI report for General Ledgers, We are unable to see the 'Approval Date' for the journal in 'General Ledger - Journals Real Time'. Kin…Venkat_P-Oracle 103 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…Nidhi Chhajed 1.3K views 8 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
I couldn't find the user entities that included the work structure dataSummary: I used HCM extract to extract person assignment and work structure data, but I couldn't find the user entities that included the work structure data (position,l…Salma Mohamed Salem 44 views 1 comment 0 points Most recent by Simona Chircu - Support Oracle-Oracle Reporting and Analytics for ERP
-
OTBI Remove All Rows SummarySummary: Content (please ensure you mask any confidential information): When exporting an OTBI analysis in the format of xlsx, the last row is a merged and centered tota…
-
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha… -
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?Sandeep Nihalani 110 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
General journals - transaction IDSummary: Hi all - within OTBI is anyone able to let me know where I can find a transaction ID or a global GL transaction number or similar? I'm trying to add it into an …Christopher McDermott 23 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…VivekKandasamy-Oracle 53 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Can we triggle process in OTBI dashboard?Summary: Can we triggle process in OTBI dashboard? Content (please ensure you mask any confidential information): For example, can we triggle "Create Accounting" process…YiwenYang 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Can we hide the OTBI Seeded Folder list in the shared folder?Summary: Is it possible to hide the OTBI seeded folder list in the shared folder and will just only show the custom folder? Content (please ensure you mask any confident…Altagracia Javier 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
It is possible to include the CX module in the OTBI?Summary: It is possible to include the CX Module in the OTBI even if CX have a separate UI from the Oracle? Content (please ensure you mask any confidential information)…Altagracia Javier 21 views 3 comments 0 points Most recent by Altagracia Javier Reporting and Analytics for ERP
-
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh…Swapnil Kashid 1 view 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How can we merge multiple OTBI report lines into one lineWe are building one report which contains project wise team member details. As per the requirement, we should have one line in the report for each project displaying eac…Sanket.Kakde 429 views 7 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Need OTBI to bring the newest site only (Latest creation DateSummary: I created an OTBI report for Supplier and Supplier Sites. I need to enhance the report to bring only one site for 1099 purpuses. The site needs to be the one wh…Pablo Schenquerman 42 views 6 comments 0 points Most recent by Pablo Schenquerman Reporting and Analytics for ERP
-
How to get data for Audit Reasons column in OTBI like the Expense Auditor Dashboard ?Summary: We are working on a custom dashboard for Expense auditors and one of the fields requested in 'Audit Reasons'. The subject area 'Expense- Expense Transactions Re… -
Invoices Paid on timeSummary: Hi Business is trying to generate the invoices paid on time report in Fusion Cloud Not able to trace the seeded / standard report for the same. Can you please g…SaurabhSinghal26 61 views 6 comments 0 points Most recent by Prateek Bajpai Reporting and Analytics for ERP
-
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 35 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
OTBI Analysis - General Ledger - Journal Real Time : No output after MigrationHi, I have migrated OTBI report to one of the demo environment but I am not getting any data in the output. There are no filters in the report and I have validated that …Karun_Jain-Oracle 1 view 1 comment 0 points Most recent by Karun_Jain-Oracle Reporting and Analytics for ERP
-
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…User_2025-01-29-20-33-47-986 162 views 6 comments 1 point Most recent by Tim Sweeney-279789 Reporting and Analytics for ERP -
Schedule in Analytics is Greyed-OutSummary: The Schedule button is Greyed-out Content (please ensure you mask any confidential information): Please help! Version (include the version you are using, if app…Dorren Veil Laniog 138 views 2 comments 0 points Most recent by Dorren Veil Laniog Reporting and Analytics for ERP -
Replacing Project attribute with Organization name causes severe performance issueSummary: We enabled Project DFF and included the attribute as a filter as organization name in OTBI. The report runs normal if we filter for specific orgs but when submi…
-
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 212 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 31 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP
-
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…FirozahamedSK 39 views 2 comments 0 points Most recent by FirozahamedSK Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 268 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 304 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP