OTBI
Discussion List
-
OTBI - Field to show max effective_start_date by action_codeSummary In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_codeContent Hi all, While working on "Workforce Managem…Pavel Kartuz 117 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM -
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …User_MC37Q 75 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Summary Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Content Hello All Is there any Task to search (or) Report in oracle fusion …User_2025-02-03-21-33-20-159 55 views 2 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP -
How-To Create Distribution Analysis in OTBI?Summary How-To Create Distribution Analysis in OTBI?Content Hi Experts, Do anyone of you have some documents illustrating how to create distribution analysis using OTBI …AshishERPCloud 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to build a report that show the results of the Payroll Calculation CardsSummary Need help in building a report that show the results of the Payroll Calculation CardsContent Does anyone have an example of a report that shows Payroll Time Entr…Stephen Robinson 144 views 1 comment 0 points Most recent by User_2025-02-04-07-01-46-164 Reporting and Analytics for HCM
-
"Workforce Goals - Goal Status Overview Real Time" issue:-Like and Contains Works , but not Equal toSummary "Workforce Goals - Goal Status Overview Real Time" issue:-Like and Contains Works , but not Equal to/InContent Hi, We are having a dashboard analysis where Goals…
-
Need database table name that stores the Performance Goals that are present in subject area ""WorkfoSummary Need database table name that stores the Performance Goals that are present in subject area ""Workforce Goals - Goal Status Overview Real Time" "Content Hi. Need…
-
Tables or views to pick values from manage data access for users functionContent Hello, Is there anyone know any table or view to get values from manage data access for users function? Purpose is to create a custom report and we need to find …User_2025-01-28-21-18-43-496 94 views 8 comments 1 point Most recent by Bala Ch Reporting and Analytics for ERP
-
DFF columns in OTBISummary How do we pull DFF (attribute) fields when creating report using OTBIUser_2025-01-30-23-57-59-639 234 views 4 comments 1 point Most recent by UjasB Reporting and Analytics for ERP
-
ORA-01427; single-row subquery returns more than one row error on data modelSummary Receiving oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.Content…User_2025-01-31-02-45-52-854 217 views 3 comments 0 points Most recent by User_2025-01-31-02-45-52-854 Reporting and Analytics for HCM
-
Goals not connecting to worker from Goal Status OverviewSummary Some goals disappear when adding the worker dimension in reportingContent We have a case where some workers have created 5 goals in a specific goal plan but when… -
R13 Financials OTBI subject area description documentationSummary R13 Financials OTBI subject area description documentationContent This documentation is published by Oracle OTBI development. This document provides users a func…User720640-Oracle 513 views 4 comments 8 points Most recent by User_2025-01-30-04-35-21-746 Reporting and Analytics for ERP -
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 336 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Job Requisition Current Status FieldSummary Trying to locate this fieldContent Anyone know what subject area and folder the current job req status is stored? I'm having trouble locating it.User_2025-01-28-08-47-04-905 28 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Need Outstanding Purchase Order Details Report in oracle fusion R13Summary Need Outstanding Purchase Order Details Report in oracle fusion R13Content Hello All Is there any report in oracle fusion r13 to display outstanding purchase ord…User_2025-02-03-21-33-20-159 718 views 2 comments 1 point Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
PO Encumbrance Journal DetailsSummary PO Encumbrance Journal DetailsContent Hello All I need script to extract PO encumbrance and related journal line details in oracle fusion. Required Columns in qu…User_2025-02-03-21-33-20-159 53 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
Latest Person Profile ContentSummary Max(Date From) not working with mutiple subject areasContent We need data from the subject area "Workforce Profiles - Person Profile Real Time" including Person …User_2025-01-30-04-37-05-780 67 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Group AssetSummary Report Is nullSummary Group Assets Summary Report is not workContent Dear's i run Group Assets Summary Reports ,no result and i check data model i found attached error messageMahgoub S.Mohamed 10 views 1 comment 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP -
Seeking Assistance Querying for Basic Transactional MetricsSummary How to get counts of journal lines, invoices, and payments per month?Content I'm hoping someone can give me a head start on how to query for the following transa… -
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…User_2025-01-31-00-25-12-234 184 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Security for Project Manager job roleSummary OTBI Security for Project Manager job roleContent Hi, When a person is declared Project Manager on a project, the job Role Project Manager is assigned to him/her…Xavier Cuinier 49 views 1 comment 0 points Most recent by Xavier Cuinier Reporting and Analytics for ERP -
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…Mak-Moose 198 views 4 comments 0 points Most recent by User_2025-01-29-21-12-23-173 Reporting and Analytics for HCM
-
Learning Completion - TimeSummary Is there a way to report on completion time?Content When a learner completes a learning item, it marks the completion date. However, is there a way to capture th…User_2025-01-30-23-13-54-867 137 views 6 comments 0 points Most recent by User_2025-01-30-23-13-54-867 Learning
-
Filter on "Primary Assignment Flag" is dropping few recordsSummary Weird issue specific to few recordsContent Hi, We are facing a weird issue and hoping to get expert guidance. We have an employee as of date report using 2 subje…Suresh Pallapothu 35 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM