OTBI
Discussion List
-
Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderSummary Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderContent We have been trying to create few KPI's for Purchase Requisition work area and …User_2025-02-10-05-51-05-868 55 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement -
Need Logic to create below KPI's for Purchase RequisitionsSummary Need Logic to create below KPI's for Purchase RequisitionsContent We have been trying to create few KPI's for Purchase Requisition work area and got struck on ho…User_2025-02-10-05-51-05-868 34 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Payroll Overpayment ReportContent Good Day, Has anyone actually built a Payroll Overpayment Report? i have spoken to internal developers and they haven't and searching on the internet has resulte…Clifford Trett 51 views 1 comment 1 point Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Reporting on Approval TransactionsSummary Trying to report on pending transactions to pull the data from the notifications onto one report. Struggling to find tables to show Current and Proposed Values a…User_2025-01-23-20-43-34-115 179 views 11 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Position Change Action ReasonSummary Position Change Action ReasonContent What is the record.field that holds the action reason on the position? (See screen shot.) I cannot find it in any of the pos…User_2025-02-04-16-58-40-850 54 views 8 comments 0 points Most recent by User_2025-02-04-16-58-40-850 Reporting and Analytics for HCM
-
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 193 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 57 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 80 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 149 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 53 views 1 comment 1 point Most recent by Soumya Prakash Parhi Expenses