OTBI
Discussion List
-
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit… -
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 576 views 12 comments 0 points Most recent by NaveenGM_CCC Reporting and Analytics for ERP -
Guidance for copying seeded report for customizationSummary: As someone new to OTBI, I'm hoping to copy a seeded report (Payables Trials Balance Report) to run for specific vendors. I've copied the report, but don't know …JamesNau_OH 23 views 2 comments 0 points Most recent by NaveenGM_CCC Reporting and Analytics for ERP
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.Mohammad Borghol 91 views 4 comments 0 points Most recent by Kristy Fung Reporting & Analytics for Fusion Service
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 122 views 7 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM -
Query or report to print approver hierercy once the Invoice approval initiatedSummary: We need to know a report name or query so that we can run this report or build a report from the query which will provide al approvers name list which we genera…Sam Samaddar 2 views 1 comment 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
Can OBTI “Payment History Real Time” & “Disbursement Real Time” have fields like payment DFFCan below fields like Payment File Reference and Payment DFF extract into OBTI report like “Payables Payment - Payment History Real Time” & “Payables Payment - Disbursem…
-
Can OBTI “Payment History Real Time” & “Disbursement Real Time” have fields like payment DFFCan below fields like Payment File Reference and Payment DFF extract into OBTI report like “Payables Payment - Payment History Real Time” & “Payables Payment - Disbursem…
-
Cant use the Oracle Analytics Publisher error "menu2007.logon"Hi installed in my machine the Oracle Analytics Publisher for word, but after install showing in tab "Publisher" in login "Menu2007.logon". I used this link to download …Felipe S. Rocha 211 views 2 comments 0 points Most recent by Harsha_Argano Reporting & Analytics for Fusion Service
-
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 87 views 15 comments 0 points Most recent by Balwinder Singh Reporting and Analytics for HCM -
Inputs Needed for BIP Folder Setup.Summary: Inputs Needed for BIP Folder Setup. Content (please ensure you mask any confidential information): By mistake, we removed My Folders in the lower environment. W…
-
Process learning records is not fetching the OTBI analysis reportSummary: Created learning initiative with analysis report and scheduled the Process learning records. But it is not assigning the specialization to the new hires. Showin…
-
What is the required privilege to access and run an existing report?Summary: We created a role to view suppliers, but now I can't access a report I previously created. Which privilege allows me to run this report? I see the report and an…
-
Oracle table name to fetch all Supplier Profile Change Request DetailsSummary: We have requirement to build report with below columns. 1. Supplier name 2. Supplier account number. 3. Date of account update- Initiated 4. Account update- Dat…
-
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Requirement is to populate Tax Registration Number from Supplier Address level in OTBI report Content (required): I have created an OTBI report for Supplier Mas… -
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o…Volodymyr Faranosov 31 views 3 comments 0 points Most recent by Anil Sangwan Reporting and Analytics for HCM -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.5K views 31 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 141 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Use order date for order pricing not available in OTBI subject areaSummary: Looking for 'Use order date for order pricing' flag in OTBI Analysis Content (please ensure you mask any confidential information): We have recently enabled fea…
-
No analysis available while creating a visualization metricI am trying to configure a visualization in the Inventory Management Landing page using an analysis, however when trying to search for the created analysis in the Visual…Ahmed Sameh Mohamed 11 views 0 comments 0 points Started by Ahmed Sameh Mohamed Reporting and Analytics for SCM -
Position trend real time Subject Area - how to find Position Incumbent?Summary: Hello. I'm trying to build a report of open positions and their previous position incumbents. Is it possible to create this report using a new subject area 'Pos… -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 121 views 4 comments 0 points Most recent by Nicolas-Vahman Reporting and Analytics for HCM
-
Does transfer order line DFF appear on OTBI reports, BI enabled flag is not available on SegmentSummary: Does transfer order line DFF appear on OTBI reports, BI enabled flag is not available on Segment configuration Content (please ensure you mask any confidential …
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…Saher 81 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 371 views 5 comments 13 points Most recent by Sudeep Doke Reporting and Analytics for HCM