OTBI
Discussion List
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 11 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
How to resolve time out error in running a Fusion BI report specific to an user account?Summary: A specific user is getting time out error after running a report with specific parameter. But the same report with same parameter is working for another user. P… -
Learning self-servcie setting reportingSummary: Would like to do a OTBI analysis on the Self-service setting and see in which training is seating with which "self-service view" details view // summary view //… -
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 481 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI report available for employeesSummary: OTBI report available for employees Content (please ensure you mask any confidential information): Hello, we have configured a guided journey which is visible i… -
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…Alexinmn 371 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service -
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Is it possible to download a BI report PDF through API from a CRM Groovy script?Hello, We have a requirement to download a PDF from a CRM Service Request screen, when a button is clicked, so we'd like to know if it's possible to run and download a B…Eduardo Ortiz 21 views 2 comments 0 points Most recent by Eduardo Ortiz Reporting & Analytics for Fusion Service -
How to pass multiple values in one parameter in OIC mapper?Summary: Pass multiple values into a parameter with delimiter in OIC mapper to invoke OTBI Content (please ensure you mask any confidential information): Hi All, I have …VasanthaFusion90 229 views 9 comments 1 point Most recent by VasanthaFusion90 Reporting and Analytics for ERP -
Payroll Element Entries History excluding terminated employeesSummary Payroll - Element Entries History Real Time subject area is excluding terminated employeesContent I have created a report to pull Annual Salary and Annual Bonus … -
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 91 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can I query the values of a fixed list field created in OTM?Hello, We have a user-generated fixed list field in OTM's Order Releases, and I'd like to know if it's possible to query the values in that fixed list field, be it throu… -
Is it possible to get metadata of OTBI reportsSummary I am looking for any workaround to get the report/analysis names with subject areas used in a folder.Tried to find any xdo tables but no luck. TIAContent Assume …User_2025-02-05-19-28-09-134 56 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to set BIP report to auto download CSV export instead of displaying online?Hi, I have a requirement to create a CSV unload BIP report but if I choose CSV template, when the report is ran, the data is displayed in browser comma separated and the… -
OTBI bursting via agent for high volume email notifications inconsistent / sporadicSummary: Classic use case: Managers are receiving emails regarding outstanding actions. Of the 1132 expected emails, 1014 succeed. 118 emails still successfully send, bu… -
OTBI Report filter for first and last date of current monthSummary: Hi Team, I am scheduling an OTBI report. We have accounting date between parameter in report. I am adding filter to OTBI report and want system to take first an…Nidhi Chhajed 1.5K views 6 comments 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP -
Create Advanced Financial Controls Report with Deep Link to AP InvoiceSummary This video shows how to create an AFC report in OTBI with a deep link to drill to an AP Invoice. The documents referenced describe the various deep links that ca…Stephanie Golly-Oracle 555 views 4 comments 4 points Most recent by M.Stafford Reporting and Analytics for ERP
-
Unable to get the data of glcoding for unapplied prepayments in otbi reportwe have created prepayment application register OTBI report, and we are getting the glcoding for applied prepayments but requirement to all data for unapplied and applie…Vikas V. Kamat 21 views 2 comments 1 point Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …Anup Karmankar 356 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 1.1K views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
The specified criteria didn't result in any data - For Purchase Requisitions and PO Details ReportsSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 103 views 3 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for SCM -
Data Security Policy is not working for the custom role which has Purchase Analysis role addedSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 74 views 5 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for HCM