OTBI
Discussion List
-
Learning Records Real Time - Reporting on RecommendationsSummary: Trying to report on recommendations using the Learning Records Real Time subject area. It appears that a recommendation is an event which doesn't appear in the …Rob F 2 views 3 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
Can we create a custom dashboard for Managers to check all subordinates RFQ /Order detailsSummary: Can we create a custom dashboard for Managers to check all subordinates RFQ /Order details Content (please ensure you mask any confidential information): Need t… -
PPM - REST API to Extract Fusion Project data for EPBCS Integration?Summary: Dear Community, We are currently working on integrating Fusion Project Portfolio Management (PPM) data with EPM Cloud Planning (EPBCS). Please note that due to … -
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…User_2025-02-04-05-26-22-197 124 views 8 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
Maintenance Work Order Cost OTBI Subject AreaWhere can i find Subject Area for Maintenance Work Order Cost, I am using Costing Subject area but it only shows Manufacturing Work orders. Please help
-
Is it possible to report on default validity rules of courses?Summary: Is it possible, using BI Publisher or OTBI, to report on courses Default Assignment Rules (specifically the fields: Validity Period Starts/Validity Period Optio…
-
System AlertContent Hi i need system send alert to user when order line status change from waiting shipping to waiting billing Thanks -
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme…User_2025-01-28-20-11-21-100 923 views 3 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP
-
Ability to Report on Person Profile Competency Rating vs. Model ProfileSummary: Hello, I need guidance on whether it's possible to generate a single analysis that compares an employee's rated competency with the competency level associated …Emily Cox 121 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Do we have any standard report in Oracle Accounts Payable for Payment exception and EncumbrancesSummary: Business want to find the report for the below need. It looks we have no report, please advice Content (please ensure you mask any confidential information): Li…Kish_Hariharan 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI dashboards using 2 fields prompts based on oneSummary: Dashboard with two prompts fields based on one field, and currency prompt Content (please ensure you mask any confidential information): I'm creating a dashboar…MYassikaya 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits…
-
Position Hierarchy queryHi, I need a small query that returns parent position name and code of positions. Is it possible for you to share the query about it? Regards -
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 22 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management
-
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 -
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…