OTBI
Discussion List
-
How to force repeat on rows in pivot tableSummary Trying to build a pivot table using the report editor with repeating valuesContent Has anyone been able to force a repeat on a row value in a pivot table? The ex… -
How to fetch log error from ESS Job ''Run Convert Pending Workers Automatically Process''Summary: Need to create an report(BI/OTBI) to fetch data of "Run Convert Pending Workers Automatically Process" job log error Content (required): Version (include the ve… -
Industry field for otbi subject aresSummary: Please help in getting industry field for otbi having subject ares: 1.order management-fulfillment lines real time 2.order management-order headers real time 3.…
-
What is the Subject area for Career Statement?Summary I want to know which subject area give "Career Statement" in OTBIUser_2025-01-27-23-54-00-342 114 views 24 comments 1 point Most recent by User_IHDYF Reporting and Analytics for HCM -
25D - Text Object "Contains HTML/Javascript/CSS Markup" Option remvoedHello, We've recently upgraded our DEV environment to 25D. We're now finding that the option to include text that contains HTML has been removed. Was this documented any…Rob F 41 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
User facing Issue while saving OTBI reportSummary: The user is getting the following error while saving an OTBI report: Catalog object privilege validation failed for user to path . You do not currently have suf…
-
Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amountsSummary: Payables Invoices –Transactions Real Time Subject Area is not returning correct The OTBI Report with subject area Payables Invoices – Transactions Real Time has…Kavitha Nanjundaiah-Oracle 6 views 0 comments 0 points Started by Kavitha Nanjundaiah-Oracle Reporting and Analytics for ERP -
Payables Invoices –Transactions Real Time Subject Area is not returning correct Invoice line amountsSummary: Payables Invoices –Transactions Real Time Subject Area is not returning correct The OTBI Report with subject area Payables Invoices – Transactions Real Time has…Kavitha Nanjundaiah-Oracle 1 view 0 comments 0 points Started by Kavitha Nanjundaiah-Oracle Reporting and Analytics for ERP
-
Enable All or Multiple selections from a Pivot Table prompt in OTBISummary The Pivot Table prompt should allow the selection of all or multiple items.Content We have a requirement to allow the selection of All or multiple items from the…User_2025-02-10-09-42-00-128 328 views 9 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Searching on HZ_ORGANIZATION_PROFILES_Hi all we need to create a report, to run weekly, that searches for Accounts/Organizations on which a specific field changed in the last week. Any idea how to avoid a FU…
-
Schedule Item Where Used for Business Intelligence and Expand Structure for Business IntelligenceSummary: We need an advise on how best to schedule below 2 ESS jobs which are required to populate OTBI related columns(Where Used Items and BOM explosion columns). ESS …Kumar Nandan-Oracle 12 views 0 comments 0 points Started by Kumar Nandan-Oracle Product Master Data Management -
How to Call a Value Set with Parameters in Groovy (OM Extension – Fusion)Summary: We have a requirement to populate a DFF at Order Line level in Oracle Fusion Order Management based on the value retrieved from a Value Set by passing a runtime…
-
OTBI Analysis - DFF Throwing ErrorSummary: I'm building an OTBI Analysis on the Product Management - Item Catalog Category Hierarchy Real Time subject area and pulling several DFFs under the Category fol…
-
Unable to find the subject area for the context segment of work order for OTBI reportHi Everyone, We’re working on an OTBI report for Work Order details and need to include the Context Segment field. However, this column doesn’t appear in the Work Order …Tauqeer Farhan 4 views 0 comments 0 points Started by Tauqeer Farhan Reporting and Analytics for SCM
-
Need asset key details in project - Assets real time subject areaSummary: I’m unable to locate Asset Key details in the Projects – Assets Real Time subject area, which is required by the customer. Is Asset Key available in this subjec…
-
OTBI Agent sends spoiled action linksSummary: OTBI Agent sends spoiled action links Content (please ensure you mask any confidential information): Hi experts, I am working on the new job applications list O…Volodymyr Faranosov 11 views 3 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM -
Download in bulk AP invoices in PDF - one pdf per invoiceSummary: How to download in bulk the AP invoices in PDF - one pdf per invoice? Content (please ensure you mask any confidential information): Hi, We need to download in …Teodora Bulancea 333 views 2 comments 0 points Most recent by Vinuth Hosur Payables, Payments & Cash Management
-
Check format using oraMICR fontSummary: Check format using oraMICR font Content (please ensure you mask any confidential information): Hello, I am implementing a check format for JP Morgan's payables …MARIANA25 221 views 9 comments 0 points Most recent by Jeetendra Achary-Oracle Payables, Payments & Cash Management -
How to set a Presentation Variable in a Dashboard Prompt as a DateSummary: How to set a Presentation Variable in a Dashboard Prompt as a Date Content (please ensure you mask any confidential information): Hi, we created a Dashboard, wh…Barile Alberto 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
User inadvertently unreconciled old transactions from 2021 to 2024.Summary: User inadvertently unreconcile the old transactions from 2021 to 2024. Now user want to reconcile back the transactions all at once. In SR agent suggested to us…
-
How to derive Running Average of Monthly Attrition rate in one OTBI reportSummary In one OTBI report, I would like to see, the monthly attrition rate and monthly running average attrition rateContent Can anyone please help me how to do this? I…Suresh Pallapothu 191 views 10 comments 0 points Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM -
Transaction ID is missing Human Capital Management - Approval Notification Archive Real TimeSummary: We are trying to develop a report with below two subject area Workforce Management - Worker Assignment Event Real Time and Human Capital Management - Approval N…
-
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 621 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Does viewing the Invoice template in the UI require the BI Admin role?Summary: We have a custom role that includes the BI Admin role. We are now limiting user access in OTBI by removing the BI Admin role from the custom role. After removin…
-
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…User_2025-01-28-18-21-52-276 51 views 2 comments 0 points Most recent by Anjula Mittal Reporting and Analytics for ERP
-
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Approval Hierarchy and Position Tree ReportHi everyone, I'm looking to build a report that includes approval hierarchies based on position trees defined in the Manage Position Trees setup, along with the related …