OTBI
Discussion List
-
Report on Remuneration Managers of Employees using matrix manager from Workforce Management - WorkerContent Hi Experts, I am trying to create an OTBI report listing all employees and their Remuneration Managers using matrix manager from Workforce Management - Worker as… -
Determine Time in Current and Previous positionsSummary Progression report that shows how long an employee has been in the current position and how long in the previousContent Hi All, I am hoping someone has a solutio…User_2025-02-04-08-51-08-912 195 views 3 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Issue adding OTBI Report to a dashboard through "Link & Image" ObjectContent Hi all, I am adding all of our reports (OTBI & BIP) to a dashboard as links to be easy to find. However, for one OTBI report, I am getting an error: "Selected it…User_2025-02-05-05-51-12-049 58 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Absence based on rolling 12 months from start of monthSummary How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent Hi I would like to report absence on a rolli… -
Budget data is not coming in queryContent Hello i upload budget in general ledger but is not coming in gl_balance table and i select atual_type is Budget "B" please advise Thanks MahgoubMahgoub S.Mohamed 40 views 1 comment 2 points Most recent by Anant Iyer-3611 General Ledger & Intercompany -
OTBI date check End-of-timeSummary OTBI date check End-of-timeContent Hi, I am wondering if anyone has tried to check for end of time on a date column in OTBI. I wrote this. But it doesn't work. A…User_2025-02-05-23-02-10-916 35 views 3 comments 0 points Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM
-
Supporting References with balancesSummary Calculate YTD balances for Supporting References with balances fieldsContent Hi all, Can YTD balances be derived or calculated for Supporting References with bal…Pavan SK 82 views 2 comments 1 point Most recent by Miranda Ho-Oracle Subledger Accounting & Accounting Hub -
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO …Manish Kumar Sinha 39 views 7 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
ITEM ISSUANCE WITH COST REPORTSummary This report including Item issance with cost details and accounts.Content Please find the attached Catalog file. unarchive the catalog in your OTBI reports. -
Table name for 'Manage Upstream and Fulfillment Source Systems'Summary Table name for 'Manage Upstream and Fulfillment Source Systems'Content What is the table for 'Manage Upstream and Fulfillment Source Systems'.
-
How to get count of child nodes in ETEXT templateSummary How to get count of child nodes in ETEXT templateContent Hi experts, how can i get the count of child nodes in etext template, ex : in attached xml i want to dis…Pradvin Prabhakar 148 views 6 comments 1 point Most recent by Pradvin Prabhakar Reporting and Analytics for HCM
-
Subject area analysis results are showing differently for different segment combinationsSummary we have an analysis created, with 3 subject areas, which is behaving differently for these GL account combinations. 1. Totals and columns are correct for the com…
-
FTP OTBI report outputSummary Option to FTP OTBI report outputContent Is there option available to FTP OTBI report output? Pease let us know steps/process to FTP report output. Version 20C
-
OTBI Learning Offering Deep Link ReportSummary This report lists all Learning Offerings and respective Deep LinksContent This is an alternative solution for MOS Doc ID 2535239.1 The Oracle Learning Cloud Offe… -
Seeded Lookups with their values in HCMSummary Need a list of lookups with their valuesContent Hello, I need a seeded list of lookups types with their values, I was not able to find it in any subject area so …Akanksha Jain 71 views 3 comments 2 points Most recent by Akanksha Jain Reporting and Analytics for HCM
-
Query to identify the UCM document ID for an Expense Report attachment in BI PublisherContent Hi experts, Based on the document: How to identify UCM Document ID for an attachment from the Expense Report? (Doc ID 2520471.1) I have built a query to obtain … -
How to get last Audit Date by expense reportContent Hi Is there any table capture Audit date. Thanks VenkateshKammarapalli Venkatesh-Oracle 52 views 1 comment 1 point Most recent by Soumya Prakash Parhi Expenses
-
Amendment need to an existing reportSummary Multiple NationalitiesContent Hi, How can I modify the attached report so that only the primary nationality is displayed? For context, there are many employees t…User_2025-02-05-22-44-35-842 31 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Benefits report - Users accessing UI vs submitted electionsSummary Users accessed vs submitted electionsContent Would it be possible to build a report that gives number of users that access UI vs submitted elections? Attached sc…User_2025-02-10-08-27-16-805 24 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Prior Salary not showing in reportSummary Prior salary not showingContent Hi, The report attached should show all prior salaries and current salaries - one of our users has said that the Prior salary is …User_2025-02-05-22-44-35-842 38 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…gabriel kinovisques-163562 49 views 2 comments 1 point Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 45 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for ERP