OTBI
Discussion List
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 31 views 8 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP -
Missing time cardWe would like to see missing time cards. We have specified Compliance also and existing report related to compliance OTBI gives time entry is missing if anyone creates a…Priti Davda 12 views 2 comments 0 points Most recent by NaveenGM_CCC Reporting and Analytics for ERP
-
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 578 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 26 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 215 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…
-
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 84 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM