OTBI
Discussion List
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo… -
Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per…
-
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content…Maxime Pignot-Oracle 1.6K views 14 comments 15 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Birthday In Next 7 Days (Birthday THIS WEEK)Summary: Could someone please share an OTBI Birthday report that can be scheduled to run every Monday, showing Birthdays that week (Monday thru Sunday). For example, whe…
-
Extract System vs Counted Quantity for Physical Inventory (Before/After Approval - not yet posted)Hi, Is there a way to generate or extract a report in Oracle Fusion Cloud that shows both the system on-hand quantity and the counted quantity for a physical inventory b…
-
Enabling SMS alert and mobile push notification is LearnSummary: Customer has requested to enable SMS alerts and push notifications for various conditions such as course expiry, reminder to take action and enroll, learner ass…
-
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 131 views 1 comment 1 point Most recent by Rakesh_Kumar_Sahu Reporting & Analytics for Fusion Service
-
Unable to Embed a Parameterized Report via Guided Journey - RSSPThe business would like to retain the embedded report from RSSP classic page to redwood. This is possible though the use of Guided Journey. Report is only displaying 'No…
-
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?LeonardoNogueira 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
LACLS NFSESummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Camila Lima-Oracle 1 view 0 comments 0 points Started by Camila Lima-Oracle Receivables & Collections
-
BICC PVO for FND_FLEX_VALUES_VLSummary: Need PVO for FND_FLEX_VALUES_VL table Can someone please share the BICC PVO for table FND_FLEX_VALUES_VL. Content (please ensure you mask any confidential infor…Sateesh Lakkireddy 31 views 1 comment 0 points Most recent by Harsha Sannappanavar-Oracle General Ledger & Intercompany
-
Absences created in Advanced modeSummary: It appears that the OTBI report splits out absences created in Advanced Mode onto separate lines by work week but gives the total absence duration for the leave…Stephen Jones 82 views 3 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM
-
Absence Detail AnalysisSummary: I'm looking to create an analysis which will show a detailed list of all absence entries in our system. I've created the following using Workforce Management - … -
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…
-
asset category column for OTBI reportSummary: I am trying to create an OTBI report with Asset Category as one of the columns. I am facing issues with assets that have been transferred multiple times from on…
-
Pending Action Items ReportSummary: I am attempting to create a report of all current pending action items in our system in OTBI. However, I seem to only be receiving completed action items and no…User_2025-02-11-20-55-10-551 461 views 8 comments 1 point Most recent by Sanskriti Gupta Reporting and Analytics for HCM -
How to hide parameters in scheduled process ?Hi, we want to hide some parameters that we don't populate in a scheduled process. For example, we want to hide source locator and destination locator from "Print moveme…Daniele Landinetti 1 view 0 comments 1 point Started by Daniele Landinetti Reporting and Analytics for ERP
-
Customer wants to have email and in-app notifications for Sales reports to be sent to team membersCustomer wants to have email and in-app notifications for Sales reports to be sent to team members. How can this be achieved?
-
Send a Document of record as attachment through OTBI analysis output via emailDear All, We want to send by mail the output of an OTBI Analysis we have, but we need to send with it an attached file. The file that we need will be the CV of an employ… -
when I scheduled OTBI report through agent it's failingSummary: Hi Team, when I scheduled OTBI report through agent it's failing. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 101 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…User_2025-01-28-17-34-41-546 571 views 2 comments 1 point Most recent by Shyam Patel Reporting and Analytics for ERP
-
Rate in OTBI Report displays as double the amountSummary: Rate in OTBI Report displays as double the amount Content (required): I created an OTBI analysis report to display information related to the salary history qui…Nick Henderson 141 views 8 comments 0 points Most recent by Gail Langendorf-Oracle 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…
-
¿How to identify the origin of the fields in the RTF template of the “Purchase Request PDF Report"?Summary: Difficulty identifying the source of fields in the RTF template of the standard report “Purchase Request PDF” Content (please ensure you mask any confidential i…Lynda Ramos 112 views 9 comments 0 points Most recent by Alex Tuteur-Oracle Self Service Procurement
-
OTBI Report: Accrual Balance Based on Effective DateHello Experts, We have a requirement to extract accrual balance details using an OTBI report based on an effective date parameter. This effective date should be compared…Vasanthakumar Ravi 91 views 4 comments 1 point Most recent by Swapna Govind Reporting and Analytics for HCM -
AP Invoice Validation Status DescriptionSummary: we have developed a OTBI report for Invoice details. While reviewing the report we noticed that there are a variety of validation status for Invoices. In order …Sathish Ravi 1.2K views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Payables, Payments & Cash Management
-
OTBI - can we apply case condition on columns from different subject areas ?Summary: CASE WHEN SA1.COl1 = 'Y' THEN SA1.COL2. ELSE SA2.COL1 END ; The above is not working as expected. Does OTBI supports CASE condition on multiple subject areas or…Sridhar Gupta Yerram-Oracle 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Summary: How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Sridhar Gupta Yerram-Oracle 1 view 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
How to remove the privileges that are caught up in the ERP license count from the job roleHello, We tested and found the follows when trying to assign roles for OTBI report access. For the OTBI reports that spans business areas, there are some that cannot be …