Sample Reports
Discussion List
-
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …HCM_Dot 132 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Looking for a couple sample reports using the Subject - Learning Records Real TimeSummary: Hi there! All of our Learning Reports have been created using the Subject Learning Management Real Time. I understand this Subject will be going away at some po…NCourt 42 views 2 comments 3 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Learning -
Are there any sample obti analysis reports for assigning learning?Summary: I'm on the Reports and Analytics>HCM> I have looked at the HCM Reports sharing center and the Fusion OBTI HCM Analysis with no success cause filter doesn't work…Audra Edwards 75 views 5 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Learning -
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires…
-
Did oracle will allow to trigger bursting email to 60K candidates at once?Hi Team, We have requirement to trigger bursting email notifications to 60K candidates. Did our fusion application will allow to send notification to the 60K employees a…MaheshRayudu7 1 view 1 comment 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM
-
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…Anup Karmankar 41 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
when I scheduled OTBI report through agent it's failingSummary: Hi Team, when I scheduled OTBI report through agent it's failing. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 102 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to migrate the custom defined ess job reports to the another instanceSummary How to migrate the custom defined ess job reports to the another instanceContent we have created the custom bip reports and those reports we registered as a ess …Koteswararao Yenikepalli 148 views 6 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 42 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Report on Benefits Self-Service Enrollment actionsSummary: Looking for a way to report whether employees went through the Benefits Self-Service enrollment process thoroughly. For example, did an employee click on Enroll…
-
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 12 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…Opkey PA 103 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service
-
BIP Report Query to Fetch Participant (Matrix Manager ) as Reviewer in Perfofmance DocumentSummary: Can anybody Please share the query to Fetch details of Participant Name as Matrix Manager as Reviewer along with Review Period and Performance Documents in Perf…MilanMohanty 123 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 197 views 3 comments 1 point Most recent by Erick.B Reporting & Analytics for Fusion Service
-
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…User_2025-02-04-05-26-22-197 124 views 8 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
In My report have two views is Pivot table view and Table view how can we schedule both to emailSummary: Hi Team, In My report have two views that is Pivot table view and Table view how can we schedule both to email. when i tried it goes to only table view report. …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Customization Request for Standard Learning Report in OracleSummary: In the Learning module, managers can access a standard report through My Team > Learning > My Team > Actions button > Download for My Direct Reports . We would …
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …Abhishek Dixit-Oracle 273 views 7 comments 5 points Most recent by MMS Reporting and Analytics for HCM -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
Sample Report: Project Financial Management Cloud: Project Budget vs. ActualSummary This dashboard displays Budget details for a specific project.Content The attached sample dashboard displays budget vs. actual cost and commitment details for a …Dustin Grabowski-Oracle 1.2K views 23 comments 11 points Most recent by HarshitBa Project Management -
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…Alan-Oracle 1K views 14 comments 16 points Most recent by Mohamed Attia-Allah Reporting and Analytics for ERP -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 220 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 401 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP
-
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any …
-
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 484 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Which table stores the details of benefit dependents and their ages in the Benefit tables or OTBI?Summary: I need to fetch the designated dependent name, relationship to the employee, gender, date of birth, and age for each benefit plan. Please help me understand how…Ketha Paramesh 518 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.3K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM