OTBI
Discussion List
-
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…Khel 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Values not populating in 'Recruiting - Recruiting real time' subject areaHi Oracle community, When we create an analysis using the 'Recruiting - Recruiting Real Time' subject area, filter the results to show only the Recruiting Type 'Offshore…Alyssa T. 41 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 91 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How to build a report to show as when a specific report has been run and at which time?**This post was created as part of a How-To Service Request (SR) Summary: I need to report to show as when a specific report has been run and at which time. Version (inc…Priscila Terazawa - Support-Oracle 61 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Add KPIs and Negotiation Dashboard to Redwood Sourcing Landing PageSummary: Is it possible to add OTBI-based KPIs and visualizations to the Sourcing Landing Page in Redwood, specifically to build a negotiations dashboard (e.g., invited …
-
Goods Received Not Invoiced Report SecurityHello, Did anyone experience issues with the security of the OOTB report: Goods Received Not Invoiced (GRNI)? We understand that the privileges required to access this r…
-
Learning Communities - Database SchemaCan anyone confirm how I would go about reviewing the Database schema for Oracle? I have some basic SQL knowledge that I have been able to leverage in OTBI/Data Models b…
-
24C New BIP report Journal and Transaction Details Report Unable to Select From & To Period ParameteSummary: 24C New BIP Report: Journal and Transaction Details Report: Unable to Select From & To Period Parameters Content (please ensure you mask any confidential inform…
-
Looking for report listing users and assinged user role with start and end date of role assignmentSummary: Report listing active users and current and past assigned roles Content (please ensure you mask any confidential information): Client is looking for a report th…
-
How can we obtain the current Task Type of Sales Order line using SQL QueryHello, We are updating EFF of a Sales Order Line using OrderFulfillmentResponseService. Sales Order Lines can be in different status during the following update. We need…
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 173 views 7 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
How to Include the Weekends and Public Holidays in the OTBI dashboardSummary: How to Include the Weekends and Public Holidays in the OTBI dashboard to the below code snippet. Content (please ensure you mask any confidential information): …
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 213 views 5 comments 0 points Most recent by Angela Valcelli Reporting and Analytics for ERP
-
How to freeze dashboard filter prompt in OTBIHi Experts, We have a requirement to freeze dashboard prompt in OTBI report like we did in Excel header if we are scrolling the dashboard we are unable to see the prompt…Anilkumar12 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Add Learning Incident Comment into ReportSummary: I had created a Learning Incident report so that we can see who had reported the incident. Learning Admins receive notifications when incidents are reported but…
-
Anyone had any issues with Self-Paced Learning content completions showing on reports?Summary: We have a few custom-built reports, that show results of completions for Courses and Specializations. While testing Self-Paced Learning, those completions are n… -
Sample report (preferably OTBI) of candidates that have applied using multiple emailsSummary: Does anyone have a report (preferably OTBI) of candidates that have applied using that one email. In essence, same candidate name and address applying with mult… -
Retrieving Enrollment Questionnaire DataSummary: We're configuring a learner enrollment questionnaire to obtain event registration information (e.g., name, DOB, travel information, allergens, etc.) I created t… -
OTBI report looks different when opening from ERPOTBI report looks different when opening from ERP than when opening it from OTBI. I want it to look like in ERP, but I do not understand why it will not do this. The fie…
-
Remove duplicates in an OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, I have a table that include several completions of a course by the same person. I want … -
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How can I report via OTBI on 'Source' field in Payables - Transactions Real Time?Summary: We have a request from the Business to include 'Source' field in a dashboard utilising Payables - Transactions Real Time. We've used the Invoice Source Code in …Fiona Marran 1 view 0 comments 0 points Started by Fiona Marran Payables, Payments & Cash Management
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 374 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
REDWOOD: Descriptive Flex Fields for Learning Request are not appearing on Approval WorkflowsSummary: Hi there, Currently we have DFFs set up on our Supported Study Course Offerings (Qualification for Role and Study Assistance courses). Since 24D was applied and…
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Report on Messages sent to Candidates using a message templateSummary: Content (required): I'm looking to report on Email messages sent to candidates who've submitted a job application. Any thoughts on which subject area/dimension …Susan Anderson 81 views 5 comments 2 points Most recent by User_JI4P7 Reporting and Analytics for HCM -
How to Enable the "Primary Project Manager" in manage project resource using API or FBDISummary: Hi I create project resource (project manager) using Import Project Enterprise Resources FBDI. But, the imported resource is not imported as primary project man…
-
I would like to customize the standard OTBI Trial Balance report in Oracle Fusion to meet our specifI would like to customize the standard OTBI Trial Balance report in Oracle Fusion to meet our specific reporting requirements. I am not sure about the exact steps involv…Puran Joshi 41 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
where to add parameter effective date conditions to OTBIHi All, Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date para…
-
Where in BI can I find fixed data of a marked for released order—item, qty, date, org, source org?Summary: Once a planned order has been marked for release, how can I find these information in a BI table? I would expect to find the order details—item, quantity, organ…C:BRANCHI 11 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration