OTBI
Discussion List
-
Unable to find the Notes and attachments field in OTBI report - Maintenance Subject AreaSummary: As per the customer requirement, need to get the detailed report for to find the "Notes and Attachments" field (Comments) when adding the Work Order Completion … -
Request: OTBI Report to Identify Self-Enrollment Courses and OfferingsWe are looking to create an OTBI report that helps to identify self-enrollment courses or offerings within our Oracle Learning system. Currently, the process for self-en…
-
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom…
-
Request for Source Tables of Task-Level Cost Columns in Project Financial PlanHello Community, I would like to request clarification regarding the source tables for the following task-level cost columns in the Project Financial Plan (navigation: P…Andika Kurniawan 33 views 4 comments 0 points Most recent by Andy May-Coates-Oracle Project Management
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 199 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Deeplink for Review cost accounting distributions drilldownSummary: Hi, we are working to define an OTBI, from Subledger Accounting Real Time are that enables drilldown to Cost Management - Review Cost Accounting Distributions. …Roberto de Santos 12 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Can someone please provide underlying sql query for Available To ReserveSummary: Looking for underlying sql query to get "Available to Reserve" and "Available to Transact" qtys on onhand UI. I tried with joining multiple tables and condition…
-
How to add Year to date activity in financial reportSummary: We are creating a financial report where we want to include current period activity and year to date (accumulated activity). How do you suggest that we include …
-
OTBI How to filter column YTDI have a formula-based column that is based on other columns, and a table prompt using Accounting Period Name. I am trying to make this column to show values in Year-To-…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Graeme Gerber Inventory Management
-
Is the 75000 row limit for OTBI reports just a limit on the output?For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total po…
-
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C…Raghavendra Raghunath-Oracle 2.1K views 47 comments 13 points Most recent by Visvanath-Oracle Reporting and Analytics for HCM -
Not able to retrieve data from Security - Roles and Privileges Real Time subject area.We are not able to retrieve data from Security - Roles and Privileges Real Time subject area. We are trying to fetch columns from the folder Function Security Policy, Da… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
REST API to get sales Order line tax amountI am looking for Sales order tax amount for each line. In front end i am able to see tax amount for each line. but when I check it through API, I am getting only total t…
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.5K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 161 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Subject area for "Total Shipping Cost Recorded" on Shipment pageSummary: Please anyone provide exact attribute and subject area for "Total Shipping Cost Recorded" on Shipment page Content (please ensure you mask any confidential info…
-
Report listing active users with current and past assigned roles (with start and end date)Summary: Report listing active users with current and past assigned roles (with start and end date). Content (please ensure you mask any confidential information): Clien…
-
Facing Error while generating Fixed Assets Data in OTBIHello, We have around 30 Asset Books, For my user all the Asset Book access given. I'm trying to do an analysis in OTBI by using the Fixed Assets Depreciation Real Time …Shagulhameed 21 views 1 comment 0 points Most recent by Lily Wang 026 Reporting and Analytics for ERP
-
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. 61 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 101 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 -
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…