OTBI
Discussion List
-
How to use TOPN in a filter in a column in OTBISummary: I would like to use a TOPN filter in a column formula in OTBI to provide the latest date. There are multiple lines per employee and just want the latest seniori… -
Just went live and delivered reports don't return data. Need help troubleshooting Absence Calendar.Summary: I am brand new to Oracle and trying to figure out why we're not seeing data in the delivered reports. The one I'm working on now is the Absence Calendar. I've r…Dana Lockwood 53 views 8 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM
-
CX - Is venn diagram possible in OTBI?Total value of opportunities and Total number of opportunities should be displayed in the diagram along with the status. Is following design possible in OTBI?Nalsoft Pvt Ltd 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Reporting on Leave Duration Without Absence ModuleSummary: Need to report on how long employees have been on a continuous leave using assignment real time subject area. This is for an existing report and my preference i…Matthew Phillips 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 21 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Can we customize HR Helpdesk DashboardSummary: We have a requirement to customize the HR Helpdesk Dashboard which is available in the Helpdesk requests landing page. The requirement are categorized into 2 pa…
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Unable to find subject area to fetch FAI Required field for OTBI reportSummary: Hi, we have a requirement to fetch FAI Required field but unable to find the subject area for OTBI report. Content (please ensure you mask any confidential info…Prathyusha pari 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI report for Subject Area Procurement - Purchasing real time giving no dataSummary: We have a custom Buyer role with BI Author and Purchase Order Transaction Analysis Duty role and the required grants on Purchase document header tables. The rol…Asutosh Mishra 383 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Bi Publisher. How do you show parameter values used for the reportSummary: We would like to show on the BI Publisher report output the parameter values used to create the report. Can anyone help with this please. Thank you. Content (pl…Kevin Robertson 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 31 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…Nishu_Kumari 42 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Manager not able to see the anything in reportHi Everyone, I have created 2 reports and deployed it for the Line managers to be able to run and self serve but when they run they cant see the results. Details of the …Girish Bhatia 31 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
how to link one Maintenance work order to another work orderSummary: Requirement is to link work order to another work order if that is offshoot of other. Any option other than DFF? Content (please ensure you mask any confidentia…
-
How to find the BIP report name which is using a specific SFTP connectionI know the SFTP name that is being used to transfer a file to vendor. But I do not know which BIP report is using that SFTP connection. I have looked at the report jobs …
-
Length of Service calculation OTBISummary Calculation of LOS based on either Current Date or Termination Date for former employees.Content I am looking to calculate an individual's length of service base…Stephen Prentice 626 views 8 comments 0 points Most recent by Rahul K-Oracle Reporting and Analytics for HCM
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
How to query the results of all generated cycle countsSummary: Our Client requires to consult through UI or some type of report the results of the all cycle counts that it has generated in order to obtain inventory reliabil…Adriana Rivera 51 views 1 comment 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management -
How to calculate number of continuous weeks of Submitted TimecardsSummary: For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks. Content (please ensure you mask any confidential …Richard Kemp-Eyre 21 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
How do I report on all the phases and states a job requisition progresses through?Summary: I am currently trying to report on all the phases and states a job requisition progresses through, including effective dates. using subject area 'Recruiting - R…Paul Morrissey 322 views 2 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…Oriana L. 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 84 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versaSummary: Deploy Reporting components from Bitbucket/Git to Oracle HCM and vice versa Content (please ensure you mask any confidential information): Currently the reporti…Akhil M 61 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
OTBI - Reverse geocode time events via sqlSummary: Hello, Is there an sql package available for cloud customer regarding reverse geocoding?. Content (please ensure you mask any confidential information): We are …Paul Buna 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
dashboard parameter resetHello, I prepared a dashboard from a web service data model and this dashboard works with certain parameters. Dashboard consists of two tabs in total. When I select the …Sinem Kara 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Reporting on paper payslip flag from People GroupSummary: We require a report that gives me people who have a paper payslip flag ticket in People Group segments. This is to ensure employees out of business get their pa…MKuch 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 41 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM