OTBI
Discussion List
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
Cost centres report in OTBISummary: Hi, I am wondering if anyone has a way of reporting on cost centres along with HR employee data in the same report. So far i have seen that Payroll costing setu…BillM 443 views 7 comments 0 points Most recent by Ignacio Velando-Oracle Reporting and Analytics for HCM -
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet…Matheus Roberto 241 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Asset Capitalization Date in OTBISummary: We have created an analysis on Depreciation Real time subject area. There is an asset which is capitalized in Mar-25 period with date placed in service as 15-Fe…
-
Notes Attribute in Assignment Action Occurrence Subject AreaHello , We are interested in leveraging Notes attribute in Assignment Action Occurrence Subject Area from 25A , however I am having trouble locating where this attribute…
-
Table/query to get Corporate Card Transactions payment and expense report detailsSummary: I am looking for a query/table details where I can get to know whether the corporate card transactions are in expense report or not and the transactions are pai…
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
Performance Issues for specific usersSummary: Some users receive the same error message of timing out while trying to pull a report. However, I can pull the same report without any issues. I am trying to de…MMS 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Recruitment - Candidates How to get a SMS/Email Communication Message History OTBI AnalysisSummary: Hi, On a Requisition via the Messages Tab a Recruiter sends out messages to candidates via Email or SMS using templates or custom messages. We need to have the …
-
Which Subject Area holds Management Level, Retention Risk, Vacancy Risk and MobilitySummary: I'm trying to create a Talent report, but unable to find few attributes in any Subject Area, and those attributes are Management Level, Retention Risk, Vacancy …KamalTeja 1 view 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to add all purchasing menu in procurement applicationSummary: How add all purchasing menu (Requisition, Purchase agreement , PUrchase Orde neg, supl. etc as per bwlow screenshot marked Yellow ) in procurement application C… -
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H…User_6U8NQ 390 views 7 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for HCM
-
How can I report on a specific pay element in OTBI?Summary: I need to be able to include a specific pay element but OTBI excludes anyone who doesn't have this Content (please ensure you mask any confidential information)… -
We have Job Application - Progression"."Current Phase" but it showing only phase like New onlySummary: Hi Team, Below subject area we rae using to know the Job Application - Progression"."Current Phase it showing of New or another phase but we need days in Phase …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Newly created prompt by one user not seen for other userWe wanted all BUs to be by default selected when LM Dashboard is opened up. So we modified the existing prompt by removing the filter of selecting the topmost BU. When c…
-
Unable to get the Enterprise Seniority Date Person level in OTBISummary: Hi all, I am not able to find the field related to Enterprise Seniority Date Person Level in OTBI using the subject area Workforce Management – Worker Assignmen…Deepak Bhatt 988 views 38 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Filter null values on a DashboardSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use…Guido Masciello 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Scheduled absences not showing in Absence OTBI ReportSummary: Hi All, Scheduled absences ("Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Scheduled Absences") not pulling any data in my OTBI report. Could a…Sai Krishna Chelikani 31 views 2 comments 0 points Most recent by Sailajad Reporting and Analytics for HCM
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, …AjayKumar Maddipati 11 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI | source agreement line agreed quantity & released quantity vs PO schedule received quantitySummary: I'm struggling in these subject areas: Procurement - Purchasing Agreements Real Time, Procurement - Procure to Pay Real Time, Procurement - Purchase Orders Real…
-
Element Entries Reports No Results on OTBISummary The specified criteria didn't result in any data ErrorContent Hello. I'm trying to report element entries on OTBI using the "payroll - element enteries history r…BenZionP 324 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaSummary Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaContent Hi Expert, Not able get information in "Workforce Succ…User_2025-02-05-01-04-36-989 37 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
Subject Area to Database Lineage MappingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sheela Pai-Oracle 11 views 0 comments 0 points Started by Sheela Pai-Oracle Reporting & Analytics for Sales
-
How to report postprocessing lead time at the item/org levelSummary: Trying to report the postprocessing lead time at the item/org level in OTBI Content (please ensure you mask any confidential information): Trying to report the …