OTBI
Discussion List
-
Fixed Asset Register report is not working when you select a date in the past like OCT 2023.Summary: Fixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation.… -
How to fetch the Covered Levels of a Subscription using querySummary: How to fetch the Covered Levels of a Subscription using query Content (please ensure you mask any confidential information): How to fetch the Covered Levels of …Neelesh Varma 21 views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales
-
Links to how to videos for OBTI builds for Learning ONLYSummary: Does anyone have any links to videos showing how to build OBTI analysis for reporting out different topics for Learning (Training and Development). Content (req…
-
https://community.oracle.com/customerconnectHow can I get employee's dependent detail and emergency contact number in OTBI reportAnup Karmankar 11 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Ethnicity Formula broken in report after 24A updateSummary: We have a report that has been in use without issue for a few years. In this report, we are getting a general active headcount of employees and contractors with…Rob Stahly 52 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Level 02 Organization Name are not generating in the HR Help Desk ReportsThere is a requirement to include the Level 02 Organization Name in the Help Desk Report. However, after adding the columns 'Level 02 Organization Name' and the suitable…Anu shree 29 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - what is Worker Creation DateIn OTBI, when looking at the subject areas in the analysis reports, what does the following mean: Subject area: Workforce Management - Worker Assignment Real Time Folder…
-
OTBI agents and P2THello! We are setting up our first OTBI agent to send out daily notifications and wondering what will happen to the agent in test environments. Will it be automatically … -
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 2 views 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 32 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 72 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 271 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 Started 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 21 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 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany