Sample Reports
Discussion List
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 24 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
Is it possible to change the date to be used in aging transactions in the seeded AR Aging report?Summary: Is it possible to change the date to be used in aging transactions in the seeded AR Aging report? Content (please ensure you mask any confidential information):…Francine Gemora 103 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Need to pull working days from Published SchedulesSummary: Hi.. we have a report were we need to pull the working days of an employee from published schedules. We need to know which days are working days and which ones …Alejandrina Vidal 43 views 0 comments 0 points Most recent by Alejandrina Vidal Reporting and Analytics for HCM -
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 122 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …AjayKumar Maddipati 153 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 12 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a… -
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external… -
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report…Koteswararao Yenikepalli 94 views 3 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Embedded content for dashboardSummary: Embedded content for dashboard Content (please ensure you mask any confidential information): Hello experts, we would like to have a page in oracle that allows …Oriana L. 21 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Approach to retrieve the value "5000009" from the string 01-4211002-00000000-0000-CH10-0000-5001044-Summary: I used the below, but it is giving syntax error. Can some one please assist and provide me corrected query SUBSTRING( "GL Account"."Concatenated Segments", LOCA… -
Which table stores bip reports scheduled history data.Summary: Which table stores bip reports scheduled history data. Content (please ensure you mask any confidential information): Hi Team, Can some one will help me to find… -
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive…Oriana L. 251 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can I create a dashboard using multiple Oracle BI Publisher reports ?Can I create a dashboard in Oracle BI Publisher that combines data and visualizations from multiple BI Publisher reports? Specifically, I'd like to include graphs and ba… -
Can we use case when condition in Parameter 1(To email address) while using burstingSummary: Can we use case when condition in Parameter 1 (To -email address) while bursting. Content (required): I need to deliver report to different email address as per… -
Sample OTBI report to track compensation plan approvalSummary: Content (please ensure you mask any confidential information): Hello experts, is there a sample OTBI report to track compensation plan approval status? I notice…Valerio Curzi 11 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM -
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?Summary: OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? …Harish Malik 41 views 3 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 21 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf… -
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 264 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP -
How to get size of file running in ESS jobSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Where is the Overdue Status in OBTI Analysis?Summary: Making my own version of a Compliance Report that was in a webinar teaching and I cannot find the Overdue Status Content (required): Best criteria for showing a… -
Seeded reports not returning any dataSummary: I am trying to run the seeded reports in the below location but none of them are returning any data. I am running this report with the seeded Employee and Line …Consultant Ian 43 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.