OTBI
Discussion List
-
How do you compare columns in a formula when the columns are in two different subject areas?Summary: Specifically, we are trying to compare the resident state (from Person Real Time) to the Worked State (from Calculation Cards Real Time - Location). I'm able to… -
SQL Report Filter for Previous_MonthSummary: I am trying to create a filter in my OTBI report that will return Pay Date results from the Previous month. Any suggestions? Content (please ensure you mask any…
-
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 241 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Error: EL expression isn't correctCreated one custom role for the purpose of quote creation. Need to change Create Order to Create Quote in sales Order, but EL Expression is Not working. -
Learning Evaluations CommentsSummary: We have an OTBI Report developed using Learning Records Real Time subject area to show questions and employee responses. We are unable to show the comments ente…
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o… -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 333 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
ORC:Date of Probity, Date of Interview, Date of review fields in Subject AreaSummary: Currently there is no any subject area available in ORC to get details directly against Date of Probity, Date of Review, Date of Interview and other phases. can…Siddhesh Nisal 21 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
Extract completion percentage of a video/scormContent Hello, We want to extract the completion percentage of a video or a scorm. In particular, we want to extract the number of minutes for which a video/scorm is see… -
table to get self service links for LMS courses in oracle hcmHi Team, We need a table name to get the LMS course and offering links in BI reports Thank you
-
We are facing issue on Manager Hierarchy. In the system it's fine but in outlook and teams wrongSummary: We are facing issue on Manager Hierarchy. In the system it's fine but in outlook and teams wrong manager showing Content (required): Wrong manager showing in ou…
-
Reporting feasibility in Learn for skill gap and user activityHi all, Client has a requirement where they would want to have a report in Learn module on- Skill gap report - This report should have skill assessment scores and identi…
-
R23 ERP OTBI subject areas to database tables mapping spreadsheetsSummary: I am looking for the R23 ERP OTBI subject areas to database tables mapping spreadsheets, R23 SCM OTBI subject areas to database tables mapping spreadsheets and …Mike.Myers.CDIPRODUCTS.COM 382 views 1 comment 0 points Most recent by Mike.Myers.CDIPRODUCTS.COM Reporting and Analytics for ERP
-
Effects of having high character length value set associated to an EFF attributeSummary: The value set of maximum character length needs to be associated to an EFF attribute. Would like to understand if this can have any negative impacts on the repo…
-
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 23 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL Query Tax Rate of purchase Order At line levelDear All, I'm currently encountering an issue while attempting to query the tax of a purchase order at the line level. Upon inspection, I've noticed that the fields "tax…
-
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Automatically exclude absent employees from auto OTBI enrollmentsSummary: Content (please ensure you mask any confidential information): We are getting a lot of heat to find a solution for removal/suspension of enrollments of people w… -
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion …
-
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…Stefaan Onderbeke 181 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…Ajeez K-Oracle 23 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
OTBI Dashboard-when i click the apply button it not changing the dashbord dataSummary: HI All, I have edtionally added completion date but when i click the apply button it not changing the dashbord data but when i apply the hire date of dates its …AjayKumar Maddipati 31 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report not showing item with Zero On-HandSummary: OTBI Report not showing item with Zero On-Hand Content (please ensure you mask any confidential information): Team, We have developed OTBI report using subject …Akancha Sinha 26 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management -
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
OTBI data quality dashboardCan I please ask if users have sample xml for data quality dashboard on key HR metrics? TIA. -
Current User/Logged in User Absence Details in OTBISummary Not able to fetch absence details of current user from otbiContent Hello Experts! I'm trying to build a report to get the logged in user/current user absence det…
-
OTBI Subject Area Security IssueSummary: For the subject area Workforce Management - Person Real Time, we have a user "Mark Eliot" who can view employee's personal information (eg: address) even though…suamanch-Oracle 1 view 1 comment 0 points Most recent by suamanch-Oracle Reporting & Analytics for Fusion Service