OTBI
Discussion List
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v… -
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 3 views 0 comments 0 points Started by Tauqeer Farhan Reporting & Analytics for Sales
-
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …Chandramouli Yangareddy 19 views 4 comments 0 points Most recent by Chandramouli Yangareddy Reporting & Analytics for Fusion Service
-
How to add a new page for the inforletSummary: I was able to add a few report to an existing page. but I want to be able to crete a new page and add all my reports. I added my report using the page Composer …diego m schenquerman 8 views 1 comment 1 point Most recent by Ahmed Maher Kadeh 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 Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
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 14 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 222 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 46 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 195 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 604 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 57 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 …
-
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I…
-
Is there an easy way to add the infolets from classic Inventory Management page to Redwood page?We are going through the process of enabling Redwood pages for Inventory Management. We have enabled the Redwood Inventory Management landing page but noticed that the i…
-
Job Offer DFF values not appearing in OTBISummary: We are trying to pull a Job Offer Descriptive Flexfields (DFFs) OTBI report for India, the values are appearing blank. Interestingly, we can see the correct val…
-
OTBI Learning Records Real Time Subject Area: Example reportshttps://community.oracle.com/customerconnect/discussion/647682/learning-records-subject-area Summary: Workforce Learning - Learning Records Real Time Subject Area Provid…Abdul Rauf Mohammad-Oracle 5.7K views 51 comments 21 points Most recent by Abdul Rauf Mohammad-Oracle Learning
-
How to Obtain History of Last Updated Date and Owner for ReportsSummary: How to Obtain History of Last Updated Date and Owner for Reports Content (please ensure you mask any confidential information): Is there a way to obtain a list …
-
Syntax Error in OTBI AnalysisSummary: Syntax Error in OTBI Analysis Content (please ensure you mask any confidential information): Hi, I'm trying to create a new OTBI Analysis. I selected "Workforce…Barile Alberto 3 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for HCM
-
Explain Differences in Payroll Balance Core Assignment and Core Relationship RunsSummary: When reporting using Subject Area Payroll - Payroll Balances Real Time, could an expert please explain the differences in the following Base Dimensions: Core As…
-
Notification upon Assigning Expense Report to AuditorContent Hi All, Does anyone know if there's a task notification sent to either BPM or email once a user has an expense report assigned to them for auditing? I don't see …
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Requisition PDF Report With Data Model Not Showing in the email notificationSummary: We have customized the RTF file for Requisition PDF Report With Data Model and can view the customizations in the Purchase Requisitions/My Requisitions/View PDF…