Reports
Discussion List
-
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T…Abhilash K - Deloitte USI 658 views 7 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
PCMCS query generating blank fileSummary PCMCS query generating blank fileContent Hi Friends, I have created a query in PCMCS using global context to export data. However when I run the query, it shows … -
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 92 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 70 views 7 comments 0 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
Dinamically printing contents in a RTF templateSummary does not work in one caseContent Hi, I am using a RTF template for a Report that should display different contents on the basis of the field named "ANNO", whose… -
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA). Can you please advise if possible to notify t…
-
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…HarishVummidi 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Output file is not getting multiple records using EText template.Summary Output file is not getting multiple records using EText template.Content Hi Experts, Output file is not getting multiple records using EText template. I am attac…Bala Kasineedi 46 views 3 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
How to capture page overflow in rtf template - BI PublisherSummary I need to display the sum of a particular field for all the Invoices in the current page only even if the Invoices overflow to the next pageContent Hello, I have…Nalinee Uppiah 40 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
how to restrict infolet user wise?Summary how to restrict infolet user wise?Sidhartha Wadhwa 40 views 5 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM -
Replace Dynamic SQL with Explicit SQL notificationSummary Notification received from OracleContent Hi There, Since yesterday we have received many notifications stating "Replace BI Publisher Dynamic SQL with Explicit SQ…
-
Profile Option for OTBI user settingsSummary Profile Option for OTBI user settingsContent Is there a profile option to set the default locale in OTBI? Global User settings get reset each day. It would be di…User_2025-02-05-23-02-10-916 20 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Exclude a column in XML Report output formatSummary My select query has two columns. I want to have only one column in my report output which is in XML format. Is there wa we can achieve this.Content My select que…Karishma Mungara-Oracle 93 views 5 comments 0 points Most recent by Karishma Mungara-Oracle Reporting and Analytics for ERP
-
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
OTL Approved time cards details with Reported hours and Calculated Hours BI Report QuerySummary OTL Approved time cards details with Reported hours and Calculated Hours BI Report QueryContent Dear Team, We need Oracle Fusion OTL Approved time cards details …VenkatReddy Pulichintha 879 views 4 comments 0 points Most recent by VenkatReddy Pulichintha Reporting and Analytics for HCM -
Denmark country specific HR reports and analyticsSummary Denmark country specific HR reportsContent Hi, Are there any Denmark specific HR reports available? Denmark is Tier 1 localization and expecting some seeded HR r…Anuradha T 16 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM -
Absence OTBI reportSummary Absence OTBI reportContent Hi Team, Can you please share if we have any OTBI report or analysis/dash board to fetch carry over, accrual and vacation balance ? (F…
-
Rating ChangesSummary Rating ChangesContent Hi, I have created analysis, we have date parameter based on the passed date it will show the rating changes , But we need to add another c…Reddykrishna Chidella-Oracle 29 views 5 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Scheduling Report to Respective Line ManagersSummary Scheduling Report to Respective Line ManagersContent Hi Team, We have a requirement that respective line managers should receive a report on weekly basis about p… -
Is it possible to Hide columns in List of Values used in a PVO ?Summary Is it possible to Hide columns in List of Values used in a PVO ?Content We have defined a number of custom Reports and ESS Definitions. We try to use the standar…Balachander G-Oracle 27 views 0 comments 0 points Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
Probation Questionnaire ReportSummary I wanted to develop a probation questionnaire report using BIContent I couldn't find the table in which probation evaluation is found while developing a probatio…Michael Nega Gebrehawariyat 49 views 0 comments 0 points Most recent by Michael Nega Gebrehawariyat Reporting and Analytics for ERP -
Get the list of persons included in an Access for a Learning OfferingSummary Access Group Details For each Offering name and EmployeeContent Hi Every One, for an Offering in the Learning Catalog I have created an Access Group. I would lik…Ashok Naramsetty 21 views 2 comments 0 points Most recent by Ashok Naramsetty Reporting and Analytics for HCM
-
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
LSQL Newbie questionSummary Trying to learn to write LSQL. Need assistance with the errorContent Hello all, I just started learning to write LSQLs. After going thro the training materials, …User_2025-02-04-15-06-22-759 41 views 2 comments 1 point Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Pre-built standard reports in TRCSSummary Pre-built standard reports in TRCSContent Hi, I would like to know if there are any pre-built standard reports available in TRCS? Thanks, PradeepPradeep Kumar-230381 36 views 4 comments 1 point Most recent by Pradeep Kumar-230381 Tax Reporting (Direct Tax)
-
Extract Content Id for the attachment from Document of RecordsSummary Extract Content Id for the attachment from Document of RecordsContent As per the Oracle document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=…Sowdha Murugan 52 views 3 comments 0 points Most recent by AvishekNandi Reporting and Analytics for HCM -
Prior manager issue in OTBISummary Prior manager issue in OTBIContent I have created analysis with Assignment Event Real Time subject area and manager name' in assignment event details folder i ha…Reddykrishna Chidella-Oracle 35 views 2 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM
-
How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DaSummary How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DashboardContent Hi Team, I want to move OTBI Report options (Ex…Mahendra 58 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Batch Scheduler IssueContent Hi all, We encounter some issues with the FR Batch Scheduler when we execute (scheduled) multiple batches at the same time. In short what we are doing: - Start 8…