OTBI
Discussion List
-
OTBI help with a Performance ReportSummary OTBI help with a Performance ReportContent Hello, I have built a custom OTBI report with Performance Task Status and Performance Task. For the Final Feedback, si…Tony Puentes 68 views 3 comments 0 points Most recent by Tony Puentes Reporting and Analytics for HCM -
Which subject area has the SUI Employee Rate in Oracle HCM?Summary Please see the navigation for getting this rate in UI.Others > Setup and Maintenance -> Tasks Icon on righthand side > Search -> Define Legal Entities for Human …pratyushak 45 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
ORC analysis - Time to Approve?Summary I am looking for a way to report on the time to approve a job requisition in ORC using OTBIContent Hello, I have a need to report on the Time to Approve an ORC j…User_2025-02-04-23-22-13-274 85 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Worker Age in Workforce TrendsSummary What to use to calculate age in Workforce TrendsContent Hello! I've been calculating the Age Bands by using a formula to gather the difference between the date o… -
Version Control for Cloud Technical ObjectsSummary Hello, can someone suggest best tool for code repository, version control, with Check in/Check out features for BIP code, Fast Formula, Valuesets HCM Extract, RT…
-
Receiving an Error when applying filters to a report, however, report will run if no filters are appSummary Receiving an Error when applying filters to a report, however, report will run if no filters are appliedContent When running a report for Goal Plan assignments u… -
"User is not selected" Error in Expense Auditor request approval page.Summary "User is not selected" Error in Expense Auditor request approval page.Content Hi all, "User is not selected" Error in Expense Auditor request approval page. Navi…
-
Apply translation to the Expense Report template in Fusion ExpenseSummary Any attempt to translate the Expense Report template failsContent We've tried to use both possibilities offered in OTBI to translate an existing template from th…
-
How to get Manager and it's repotee details using OTBI AnalysisSummary How to get Manager and it's repotee details using OTBI AnalysisContent Hi Experts, I have a requirement in OTBI, I want to build a Manager report. It has to fetc…User_2025-02-05-04-17-04-394 65 views 8 comments 0 points Most recent by Mahendra Reporting and Analytics for HCM
-
How to get number of employees reporting to each manager in OTBI?Content Hi, How to get number of employees reporting to each manager in OTBI? We have an employee details report in OTBI which is using Assignment real time subject area…Nivya Mathire 208 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Is it possible to delete Unassigned Corporate Cards in Bulk?Summary We have a requirement to delete assigned Corporate Cards in bulk, is this possible?Content Hi, We have a requirement to delete unassigned Corporate Cards in bulk…
-
Combining columns from different work area/Competency ReportSummary how can i develop a report with columns from two different work areas.Content Competency Assessment Report Sr.No Person Number Person Name Parent Department Depa…Michael Nega Gebrehawariyat 31 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Income Statement and Balance SheetSummary Is there an OTBI or FR studio template to produce these two reports? Thanks for sharingBrian Hadizadeh-243825 68 views 5 comments 1 point Most recent by Baskar.Chakravarthi General Ledger & Intercompany
-
how to take custom dff of (IRC_OFFERS_DFF) in analyticsSummary how to take custom dff of (IRC_OFFERS_DFF) in analyticsContent how to take custom dff of (IRC_OFFERS_DFF) in analytics need subject criteriaSidhartha Wadhwa 22 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Unable to provide a dynamic image in the background of a Custom AlertContent While developing a custom mail alert, there is a requirement to provide the Covert Art of the course as a background image with text on it. Is there any advice o…
-
How to get last Audit by expense reportContent Hi How to get last Audit by expense report . Is there any query to find out last audit by in expense. The field is available in OTBI and i want it BI publisher.Kammarapalli Venkatesh-Oracle 38 views 3 comments 1 point Most recent by Baskar.Chakravarthi Expenses
-
D&I reporting - what works for your organisation?Summary D&I reporting - what works for your organisation?Content Hello all - over the years I've helped lots of customers with many diversity reports, but the world is m…Caroline Gladwin-Oracle 81 views 2 comments 1 point Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
Need to limit values in reportSummary Some employees have 2 types of IDContent Hi, I have a attached a basic report that shows the type of External Identifier an employee has namely: * Integration ID…User_2025-02-05-22-44-35-842 28 views 13 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP
-
SQL Needed for DatesSummary Calculating the later of two dates using SQLContent We are creating an OTBI report to figure out when to discard of hard copies of paperwork. To calculate the sh…Rebekah Gilday 51 views 1 comment 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Table for Attachment of Job RequisitionSummary Table for Attachment of Job RequisitionContent Hi Experts, We have a requirement to fetch the attachment uploaded during Job Requisition. is this possible to ext…Rajeev Nayan 32 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
HCM Last date a vacant post was filledSummary is there a way to report out when a position was last filled which is currently vacantuser1028626 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.Summary An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Exp…User_2025-02-08-08-08-53-292 93 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
We are working on OM to GTM integration, in the process when response is sent from GTM, there is anSummary We are working on OM to GTM integration, in the process when response is sent from GTM, there is an exception error at OM as "User not authorized for DOO_TradeCo…
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…User_2025-02-10-05-51-05-868 78 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
User Roles and UsageContent Hi, I need to develop BI report to understand User System Usage with username and roles attached Please let me know the tables involved ThanksMohammed Rafi 77 views 8 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reporting on HCM/EPM using OTBI/BIPSummary Reporting on HCM/EPM using OTBI/BIPContent Hi Team, Our customer is using Cloud HCM and EPM Cloud. Is there a possibility of creating a report by combining the d…MandeepKGupta 54 views 2 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM