OTBI
Discussion List
-
OTBI project costing assets subject area filtering on in-service date results in no recordsI created an OTBI analysis using the project costing assets subject area. See fields in the screenshot below. The analysis returns correct results. However, when I filte… -
Subject Area Related to CE_BANK_ACCOUNTS to get bank account Num & Asset Code Combination IDI am using "General Ledger - Journals Real Time" Subject Analysis & need to Join using Code Combination ID to get above bank account numSagarChadha 21 views 2 comments 1 point Most recent by SagarChadha Reporting & Analytics for Fusion Service -
What is the Subject area for Career Statement?Summary I want to know which subject area give "Career Statement" in OTBIUser_2025-01-27-23-54-00-342 114 views 23 comments 1 point Most recent by Sumit Halder Reporting and Analytics for HCM -
How to price Sales Order Lines in different UOMSummary: How to price Sales Order Lines in a UOM other than the Primary UOM (Each) Content (please ensure you mask any confidential information): We have a requirement t…
-
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the …
-
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma… -
How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report"How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report" in "Manage Workflow Rules in Spreadsheet". Please help to find standa…Thanigainathan R 1 view 0 comments 0 points Started by Thanigainathan R Reporting and Analytics for ERP
-
Create access group using analysis report criteriaSummary Unable to create access group of an analysis report criteriaContent I'm trying to create an access group using based on an analysis report, but when i select the…User_2025-01-25-04-20-15-792 57 views 16 comments 0 points Most recent by Bharadwaj Pisipati Learning
-
can we get the amount/numaric value in words in Polish language for OTBI ReportsGenerally we uses the function iby_amount_in_words.get_amount_in_words to display the amount/numaric value in words in English language for OTBI Reports. I would like to…Yugandhar2249 11 views 3 comments 1 point Most recent by Yugandhar2249 Reporting and Analytics for ERP
-
Connect Oracle Database Actions to Oracle Fusion ERPSummary: Connect Oracle Database Actions (SQL Developer Web) to Oracle Fusion ERP Content (please ensure you mask any confidential information): Are we able to connect t…
-
HCM Quick Link Usage StatisticsSummary: Looking for statistics for individual pages access by role, user, etc… for a specific timeframe Content (please ensure you mask any confidential information): A…
-
Custom Payslip Prints Wrong AmountsHello experts! We use a custom format for our payslips. When the payslips are generated, if an employee has money going to different banks, and one prenotes and the othe…Henry Imgrund 31 views 2 comments 0 points Most recent by Henry Imgrund Reporting and Analytics for HCM
-
Filter Talent Review 9-Box to Most Recent RatingSummary: Measures calculating percentage of employees by 9-box rating are including old ratings that have been filtered out of the analysis. Content (required): We have …
-
Is there any way to calculate day difference excluding weekends for Term date - Action date?Hi, We have a requirement to pull late/retro termination counts. The logic is if Action date - Actual Term date > 1 then it is marked as Late term. Is there any way to e…
-
How to add a Dashboard in the Learning Administrator HomeSummary How to add a Dashboard in the Learning Administrator HomeContent Hi, I need to add a dashboard in the Learning Administrator Home Page (My Client Groups > Learni…
-
Ability to pull criteria used in OTBI reports using Bi Data ModelHi, Do we have possibility to pull the Criteria used in OTBI reports using bi data model? Example: We have 100+ OTBI reports created for Module Enrolment under Learn Fol…Boopathy Laxmipathi 21 views 2 comments 1 point Most recent by Konda Reddy A Reporting and Analytics for HCM
-
Unable to Find "Placement Match Date" Field in OTBI - Workforce Management: Absence Real TimeWe're encountering an issue in Oracle Fusion HCM when reporting on Adoption Leave (Event Type: Placement) using the Workforce Management - Absence Real Time subject area…Minal Deshmukh-Oracle 1 view 0 comments 0 points Started by Minal Deshmukh-Oracle Reporting and Analytics for HCM
-
Perform Lot Split, Merge, and Translate transactionsSummary: Perform Lot Split, Merge, and Translate transactions Content (required): Would like to understand how to perform Lot Merge / Split transaction through front end…Jayaharan Krishnamurthy 1K views 15 comments 0 points Most recent by Mangesh Shastri Inventory Management
-
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 121 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
Could you recommend vulnerability scanning tools for BIP, OTBI, and OIC (To Integrate with CI/CD)?Summary: Could you recommend vulnerability scanning tools for BIP, OTBI, and OIC that can be integrated with CI/CD pipelines? Content (please ensure you mask any confide…Kalyan_Duggineni 11 views 1 comment 0 points Most recent by Kumar -Oracle Product Master Data Management
-
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co…LynneLBL 21 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is possible Learner User can view the approval stage in learning applicationSummary: When User requested for External or Internal or Catalog Learnings. Learners currently cannot see the approval chain and where a requested learning is waiting (i…
-
CC wise expense report in OTBISummary: we have tried to create an OTBI report for the expense total with break down by Cost Center with GL but it not showing any break down sum we can get only total …
-
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…User_2025-07-18-13-29-11-469 51 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Analysis report not fetching value type as 'Text'Summary: How to fetch text based value in OTBI Analysis report. Content (please ensure you mask any confidential information): Developed an OTBI report to display suppli… -
Project Financial Analytics ReportsSummary: I'm able to navigate to this URL to look at the seeded Project Financial Analytics Reports. However, I'm not able to see the all column details to understand if…Raj Mohanraju FRNT 11 views 2 comments 0 points Most recent by Raj Mohanraju FRNT Project Management
-
Supplier User Account last login historySummary: As part of monitoring and controls in our organization, we would like to have an audit of the last login date for the supplier user accounts registered in our s…
-
Onboarding/Recruiting Employee Name fieldSummary: What is an alternative for updating the "Employee Name" in OTBI, where it displays First Name Last Name for Onboarding/Recruiting, and not change any of the exi…
-
Scheduling analysis for last day of monthSummary: Analysis schedules for end of month Content (please ensure you mask any confidential information): Hi everyone, Is there a way to schedule reports (analysis) in…