OTBI
Discussion List
-
Is it possible to have a WITH clause in OBIEE Logical SQL?Summary Is it possible to have a WITH clause in OBIEE Logical SQL?Content Hi all! Is it possible to have a WITH (subquery) clause in OBIEE Logical SQL? I have to exclude… -
When applying case statement with group by and aggregate function it is showing error.Summary When applying case statement with group by and aggregate function it is showing error(No fact table exists).I am using 2 subject areas and included fact columns …
-
Getting Error "the User request exceeded the maximum query governing Execution time" while running tSummary Getting Error "the User request exceeded the maximum query governing Execution time" while running the OTBI reportContent Hi All, I have created one OTBI analysi…User_2025-02-06-15-04-02-124 94 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 40 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
OTBI report to fetch all details of Direct and Indirect reports details based on Line Manager sessioSummary OTBI report to fetch all details of Direct and Indirect reports based on Line Manager session userContent Hi All, I am trying to fetch all the (direct+indirect) …User_2025-02-06-15-04-02-124 64 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to pull earnings balance for each assignmentContent Need help on pulling earnings balance for each assignment or identifying which assignment has earnings.Renzel Keith Coquia-204674 55 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Listing historical Grade Step via Workforce Management - Worker Assignment Event Real TimeContent I'm using Workforce Management - Worker Assignment Event Real Time subject area to review an employee's historical assignment changes. Within the Assignment Even…Robert Craske 39 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting on "In Progress" Talent Review MeetingsSummary Talent Review ReportingContent Is it possible to pull talent review meeting data on meetings that are still "In Progress"? Right now all of our meeting notes and…User_2025-01-28-08-47-04-905 112 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Date & time of SubmissionSummary Date & time neededContent Hi, Is there a way to know the exact time and date the 360 review and performance review was submitted?Thanks AndrewVersion 20BUser_2025-02-05-22-44-35-842 20 views 4 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Is it possible to create a BI report to search for a string in all the log files for the parent scheContent We submitted a Synchronize Person Assignments from Position and it internally spawned 25 processes. Instead of looking into the individual log files, we wanted t…User_2025-01-22-19-57-39-723 29 views 2 comments 0 points Most recent by User_2025-01-22-19-57-39-723 Reporting and Analytics for HCM
-
OTBI agents - update mass recipients list?Summary OTBI agents - update mass recipients list?Content Hello , In OTBI agents is it possible to update by an upload the recipients list of a mass of agents ? (Since w… -
Neel help schedule a BI reportContent How Can I schedule a BI report on daily basis and deliever it to an email address provided? Any help/Guidance will be much appreciated. Version 20BMegha Patel 26 views 12 comments 0 points Most recent by Megha Patel Reporting and Analytics for HCM
-
Need to know KFF Deployed person nameContent Hi All, We have "Deploy Flexfield" option in cost Allocation Key Flexfiled. We need to know the person name who deployed the flex field. In "FND_KF_FLEXFIELDS_VL…
-
How to ensure consistent output of default Date format in OTBISummary Default Date format is different for 2 different users who have same Regional PreferencesVersion Oracle Cloud Application 21B (11.13.21.04.0)User_UM4C6 26 views 1 comment 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
Resignation Rejected ReportContent Hi Team, We are looking for some report by which we can fetch the data for all the Resignation status was Rejected. In our current environment, when the employee…Kiran Kancherla 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Checklist item and report on there StatusSummary Need a report for onboarding checklist (DoR) which the acknowledgementContent Team, We have onboarding checklist items and using BI publisher for some of them to…Santosh Mudide 54 views 4 comments 0 points Most recent by Santosh Mudide Reporting and Analytics for HCM -
Generate Workpattern code like NYYYYYNSummary Generate Workpattern code like NYYYYYNContent Hello I am trying to generate an understandable work pattern code like NYYYYYN for reporting. Any quick pointers ho…Murthy Kodavati 23 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
How to create a Custom Job Role (Read Only) for using "PAYROLL - ELEMENT ENTRIES REAL TIME" subjectSummary Need to create a Custom Role which gives read only access to UI and allow access to "PAYROLL - ELEMENT ENTRIES REAL TIME" subject areaContent Hello Experts I hav…Dharmendra Shukla 22 views 2 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
How to convert Bonus percent into amountSummary Need to convert Bonus Target Percent (field) into Bonus Amount using Annualized Salary (Local) fieldContent I need to convert the percent numbers into % numbers …Abhishek Bagh 36 views 2 comments 0 points Most recent by Senthamizh Arasu Govindan Reporting and Analytics for HCM
-
Positions Report With Active Employees and Blank PositionsSummary The report i created does not show open positions when i apply filter on Assignment status Not Equal To InactiveContent Hi, I created a position report using "Po…User_2025-02-11-02-55-52-410 53 views 3 comments 0 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for HCM
-
Report on Attached Documents to HelpDesk Service RequestsContent Hi all, I was just wondering if anyone knew if it was possible to report on the files attached to Service Requests on HelpDesk. I've had a look at the Subject Ar…
-
Need help on Logical SQLSummary Need help on Logical SQLContent Hi , I have added three columns to existing logical sql OTBI, After adding the three new fields report format has changed, Can an…Reddykrishna 51 views 4 comments 1 point Most recent by Reddykrishna Reporting and Analytics for HCM -
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require…
-
Customize OTBI Analysis Header FieldsSummary Need Help with customizing the OTBI analysis header field to a custom nameContent Hello Everyone, I am new to OTBI analysis and I need help with some customizati…GauravGupta39 49 views 2 comments 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Subject Area which includes Maternity Weekly Average EarningsContent Can any one help me to identify subject area which contains below highlighted field in the attachment? Absence Administration (Maternity Leave) -> Override Avera…ViswanathaReddyKetireddy 31 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
No access to create BI Publisher reportSummary No access to create BI Publisher reportContent Hi all, is it possible to give users access to create/Modify only OTBI reports but only read-only access to BIP re…Prashant Kumar - 2103 43 views 4 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 43 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Export my Favourites analysesContent Hi there, is there an easy way to export the favourite analyses. I do not mean the actual analyses but rather the structure that one has under Favourites. Thank …Bobby Jourdan 10 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Override Average weekly earning field in OTBIContent Does anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI?Tasha 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Pivot Table - Value FilterContent Hi, I am looking at how many assignment actions have been processed on the same effective start date per employee. In OTBI I have an assignment history report lo…