OTBI
Discussion List
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…Dejan Begovic 1 view 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP -
How to find indexes really used in OTBI - Subject Areas ?Summary: How to find indexes really used in OTBI - Subject Areas ? The document R13_23D_FIN_OTBI_database_mapping_with ViewObjects.xlsx doesn't give really indexes used …LaurentDup 31 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Worker Assignment Event history - job title / position title as of assignment effective dateSummary: When we are running OTBI analyses with the Worker Assignment Event subject area, we need to be able to see what the associated position name/ job code names are…Hunter Kennedy 73 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to use AOR subject area to show active AOR's for inactive assignments?Summary: Trying to get a list of inactive assignments with active AOR Content (please ensure you mask any confidential information): I'm trying to use the subject area "… -
Identify Headcount and FTE by Dept and Job AND Display Number of Open Requisitions by Dept and JobSummary: Requirement is a report showing active headcount and FTE by Dept by Job AND # of open job requisitions (Filled Date is null) AND # open FTE. Is this possible? Y…JHaden3 52 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…Sushmitha G 278 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Extracting Requisitions from Career SitesSummary: Hello Guys, We would like to create an analysis or a data model that allows us to extract all requisitions posted on various career sites. Currently, we are enc…Giuseppe Iacono 1 view 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
Report/Dashboard about Performance ModuleContent Hi Guys, Does someone know where could we find Performance Reports or Dashboards standard? I hope in your answer, Best Regards, GiuseppeGiuseppe Iacono 67 views 5 comments 0 points Most recent by Dileep Reddy Vattimi Reporting and Analytics for HCM
-
Hire Report - Two subject area report erroring with two measuresSummary: Hello, we are building a hire report using the Workforce Management - Worker Assignment Event subject area and we only need one field from the Workforce Managem…CCannadayCTR 11 views 2 comments 0 points Most recent by CCannadayCTR Reporting and Analytics for HCM -
OTM Report extract as multiple tabs of a single Excel WorkbookWe have a requirement to generate an automated In-Transit Report using OTM for supplier ASNs. Since different suppliers have different in-transit mapping, we have create… -
Count Distinct by Two AttributesSummary I am not able to get distinct count by management level and genderContent Hello - I'm creating a simple analysis to count the number of employees by a grouped ma…User_2025-02-11-03-07-51-707 36 views 3 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to get serial number by sales order line in SQLSummary: I need to get the serial result by order line, Does anyone know how to do it? All I can do is the result below. there are 2 lines with 2 different ship-out date…
-
how to extract all work confirmation data in the UISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 22 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
How to report on OLC External Providers?Hi, How can we report on the External Provider related information? Is there any OTBI way to pull that data? (Learning Content Item Real Time doesn't work for us unfortu… -
Unable to map missing columnSummary: Our team is redesigning an OTBI report and is facing an issue with mapping the column from the old subject area "Workforce Learning - Learning Management Real T…Suda.V.Ra 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
MATERIALS REQUIREMENTHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI for materials requirement below, would anyone know how to create the formula for tota… -
Lineage document comparing PeopleSoft tables with Oracle Fusion tablesSummary: We need to migrate PeopleSoft Finance and HCM tables/fields to Oracle Fusion Financials and HCM. Could you please provide the lineage document comparing PeopleS…
-
Additional levels listed in OTBI for GL segments in GL Subject AreasSummary: We have levels listed for all of our GL segments in OTBI. We would like to know where these come from and if there is a way to remove them from OTBI if possible…Kristina P - National Heritage Academies 33 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Combining multiple max formula criteria in OTBI resulting in no values returningSummary: I'm having trouble pulling in someone's latest record or assignment in a report without it creating multiple line items for their various Job Names. When using …
-
24B Feature Talent Management REPORTING ON PROFILE ATTACHMENTSSummary: When perform the Analysis, report unable to show the link on Profile Attachment attached. Are we supposed to have link to view it? What is the different between…Eyan Shahrin 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …Dhanusia 1 view 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting and Analytics for ERP
-
24A ERP OTBI subject areas to database tables mapping spreadsheetsSummary: 24A ERP OTBI subject areas to database tables mapping spreadsheets Content (please ensure you mask any confidential information): Where can I find 24A SCM and P…User_2025-10-31-00-30-05-350 125 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP