OTBI
Discussion List
-
What role grants me access to view data for real-time analysis of Quality Inspection ResultsSummary: We created a custom infolet for users to view failed Preventive Maintenance work orders. However, only the admin can currently access and read this data, while … -
No results for some Facts-Candidate Tracking Activity such as number of applies, number of submits.Summary: Running a basic query against Recruiting - Candidate Tracking Real Time subject area. Number of successful submits does display, however Number of Applies, Numb…Melody Herbert 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Where are the setup information of Installed Base Asset additional fields stored ?Summary: Via Application Composer, we have defined a number of additional fields for Installed Base Asset object. We need to know via OTBI query wich attribute maps to w… -
Need help finding field in OTBI reportSummary: I have everything done on a custom OTBI report out of Performance Task Status Real Time except I need to pull the "Step" as shown in my image below. I cannot fi…Aaron Reynolds 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Data Not fetching when joining cross subject areas with a DFF attributeSummary: We have encountered an issue while join two cross subject areas. Workforce Management - Worker Assignment Real Time and Workforce Performance - Performance Rati…Atul#620 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Employee hierarchy under a manager - need help passing manager person number as a promptSummary: I am writing a report to show all reports (direct or indirect) under a manager. I am getting the list by hard coding the manager ee# in my OTBI report. Since it…Anita Modi 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to update expired courses ??Summary: update expired courses thru HDL or supress them from employee dashboard Content (please ensure you mask any confidential information): We have many employees wi… -
Hierarchy Report - Top to bottomHi, Is there any way of reporting on the hierarchy from the top to the bottom? In OTBI there is this 'Parent Manager' field that is ordered bottom up. Is there any way o… -
How to deliver the OTBI report content to a destination server ex - A FTP serverSummary: Hi, Pl let me know how to deliver the OTBI report content (anlaysis) to a destination server ex - an on-premise FTP server. Where can we setup this in agent con… -
Why does the Compensation - Salary History Details Real Time not show the correct adjustment?Summary: In the subject area Compensation - Salary History Details Real Time it is showing a value which is not in the front end for adjustment. Content (please ensure y… -
Enable Drill down from OTBI Report crated from Budgetary Control - Balances Real TimeSummary: Hi, I've Created an OTBI report through "Budgetary Control - Balances Real Time". to retrieve the total budget, expenditure balances and so on. How to make dril… -
Costing - Item Cost Real Time" subject area replaced with "Costing -Standard Cost Real TimeSummary: Subject Area name and function appears to have slightly changed. We can no longer find the SA called "Costing - Item Cost Real Time", but instead it appears to … -
PPM Selected Bank AccountSummary How to Find selected bank account under personal payment methodContent Hello All, When employee update their bank details by clicking into their existing payment… -
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 33 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Fiscal YTD not working correctly in HCMSummary: Need to get Fiscal YTD terminations but I cannot get it to result in Sep 1, in instead get 09/22/23 if run today. Content (please ensure you mask any confidenti…Sherie Ross 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…AjayKumar Maddipati 441 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Schedule Report to FTP including data timestampSummary Schedule Report to FTP including data timestampContent Hello, I want to daily schedule in OTBI report and BI publisher report and in the file name I want to incl…Giuseppe 1234 114 views 7 comments 0 points Most recent by NikhilSamudrala-Oracle Reporting and Analytics for HCM -
IN below OTBI Manager DR report but country name not showing it showing DRS country nameSummary: Hi Team, we have list of people with direct reporties but when we add the country name in the it showing reporties country but we need manager country . Any one…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks…Andrew_Schmitz 142 views 6 comments 2 points Most recent by __KumR__ Reporting and Analytics for ERP -
candidate email address in OTBISummary: How do we fetch the candidate email ID in OTBI from recruitment real time subject area as per the email ID present in the candidate personal information page. I…Debkanya 53 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
time to fill OTBI report in ORCSummary: Does anybody have time to fill OTBI report or dashboard build in ORC? Content (please ensure you mask any confidential information): Version (include the versio…Avinash.Potti 21 views 2 comments 0 points Most recent by Avinash.Potti Reporting and Analytics for HCM -
OTBI Report for Associated Collaboration Documents under Supplier Site-General TabSummary: Hi, May i know whether we have any subject area for Associated Collaboration Documents under Supplier Site-General Tab. Content (please ensure you mask any conf… -
Fetching the answer from multiple choice questions in OTBISummary: Hi, I have an OTBI report for Learning Assessments, the field "Answer Text" only appears in the report if the question is an open-ended question. Is it possible…Vasco 91 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Oracle BIP Report -> RTF Template page bordersSummary page bordersContent Hello, I am having an issue with achieving page borders in RTF templates. Attached a word document explaining my problem. Can anyone please a…SantoshKumarBhairi 281 views 4 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for HCM
-
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 61 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Activity Attempt Note ReportingHello, We have been using the ActivityAttemptNote as part of the HCM Data Loader on the LearningRecordActivityAttempt Business Object. Does anyone know if this field is … -
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…Ramy Atia 31 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
getting duplicate seniority dates in OTBI report FusionSummary: Oracle Fusion OTBI report is there giving duplicate records for one of the employee. It showing two seniority date records out of it we need earliest seniority …SauluriR 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…MadhuLekkala 65 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM