OTBI
Discussion List
-
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries?Ulitka 53 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Access to Supplier Report without Supplier Admin/Manager role?Summary: We created a simple supplier report for users so they can see the active suppliers (+ address, basic details). The users are not able to run/view the report as …
-
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje… -
Looking for a query for Oracle Fusion HCM Templates on Disciplinary ActionSummary: Templates on Disciplinary Action Content (please ensure you mask any confidential information): I am looking for a query for Oracle Fusion HCM Templates on Disc… -
Access BIP Report from Oracle AI Agent Studio using Rest APISummary: Hi I want to get requisition approval history of pending requisition in Oracle AI Agent Studio. and for that i created BIP report from workflow tables and tryin…Mayank Agrawal 608 228 views 5 comments 0 points Most recent by Amandeep Malik Self Service Procurement -
OTBI - Return transaction directly before current transactionGood afternon. I searched the Customer Connect portal for an answer to this, but couldn't find one. Seems like it should be easy, but I'm stumped. Can anyone advise on h… -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 383 views 12 comments 0 points Most recent by ParthivAVT Reporting and Analytics for HCM -
Not able to join 3 subject areasSummary: We would like to build OTBI report but will require to use 3 Subject Areas: Workforce Management- Person Real Time Workforce Learning -Learning Records Real Tim…RodrigoRamirez 13 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to set static/Dynamic password generation for PO-PDF in Oracle FusionHow to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO PDF. The …PASALA SATEESH REDDY 14 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Can we develop the report in EDI format using the Standard edition of Oracle IntegrationSummary: Can we develop the report in EDI format using the Standard edition of Oracle Integration Content (please ensure you mask any confidential information): Can we d…Sravan Prasad B V 15 views 4 comments 3 points Most recent by MarcD-Oracle Transportation Management -
Balance Value for Balance Dimension visible in Fusion UI but not in OTBISummary: We are trying to lookup Payroll Balance Results based on a specific Dimension Name and Balance Name, and the output retrieved from OTBI is not matching to that … -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 95 views 18 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
INVALID_VENDORSummary Expense report invoices rejected due to reason INVALID_VENDORContent Hi Team, I am unable to create invoices for expense report which are Approved and Audited, s… -
What subject areafolder can I find details to report on Self Paced Learning-Event details?Summary: What subject area and folder can I find details to pull into an OTBI report on Self Paced Learning - Event details? We have our Events tied to a Course but when… -
How/where to track PO's Communicated via Email to supplier in outlook sent item?Summary: Hi All, We are using the Oracle Supplier Communication functionality to send Purchase Orders to suppliers via email. Is there a way to track whether a Purchase … -
Why Does Transaction Cost Details Show Blank Costs for Cost Version Date 1/1/1900?Hi everyone, We're encountering an issue with the standard Transaction Cost Details report. For some transactions, the Cost Element, Unit Cost, and Currency columns are … -
Is an Organization DFF visible in OTBISummary: I'm trying to build an OTBI Report that will show our Organizations and a DFF that is tied to Organizations. This DFF shows under the Department folder in the W… -
Is there OTBI report for available credit balanceSummary: How to calculate Customer Available Credit Balance — is there an OOTB OTBI report, or is a custom report required? Content (please ensure you mask any confident… -
How to set static/Dynamic password generation for PO-PDF in Oracle FusionSummary: How to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO …Shweta Prakash Veer 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Unable to produce an OTBI report that include Cost Centre DescriptionSummary: Unable to include CostCentre Description in a report in OTBI. I am using Workforce Management - Worker Assignment Real Time subject area as we don't use the fin…Julia Kiszelewska1234 5 views 0 comments 0 points Started by Julia Kiszelewska1234 Reporting and Analytics for ERP -
Is there any Fusion standard report which gives Onhand & its valuation (in PO Cost) for any INV Org?Summary: Is there any Fusion standard report which gives Onhand and its valuation (in PO Cost) for any INV Org. Please note that the Costing method defined for the Cost … -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & … -
Compliance at scale solution peer-review on gapIs “latest certification” logic fundamentally broken in OLC compliance? Using exclusion model instead. Context: Large NHS implementation (~30k workers) using: Learning O… -
OTBI Learning Records Real Time Subject Area: Example reportsSummary: Workforce Learning - Learning Records Real Time Subject Area Provides real-time reporting capability on learning records. It supports reporting of learning reco… -
is there a way to download the each OTBI report output from Dashboard in different formats?unable to find the option to download the report output from DashboardKiran Kumar Alle 11 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
OTM Transportation Operational Intelligence – No Subject Areas Available in Data VisualizationSummary: OTM Transportation Operational Intelligence – No Subject Areas Available in Data Visualization Content (please ensure you mask any confidential information): We… -
OTBI Report on Performance Goal Tasks within a Goal PlanWe need an OTBI report for Employee Performance Goals and Goal Tasks. It must include the Goal Plan Name so we can tell which Goal Plan the goal was created in (we assig…KBetts 11 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
OTBI Context Sensitive DFFSummary: How to avoid context sensitive DFF show multiple times Content (please ensure you mask any confidential information): We have setup several context sensitive DF… -
French Social Report - Required Parameters and Payroll Action IDHello, I am working with the French Social Report BI Publisher report. To run the report, several parameters need to be provided, such as: ArchiveActionId DeliveryOption…Imene_Zaouzaou 32 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM