Sample Reports
Discussion List
-
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 265 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…joelroshan92 2 views 2 comments 0 points Most recent by joelroshan92 Reporting and Analytics for ERP -
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 41 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. -
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 279 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM -
Report on who edited an assignment and the commentsSummary: I need to have a report that shows who modified/edited an assignment and the Notes, Comments, Justifications (anywhere, that someone need to put in the reason w… -
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
is there any way to hide the rows in excel using bi publisherSummary: Hi, I am new to bi publisher and wanted to have this in my report template using excel. is there any way to hide the rows in excel using bi publisher that is be… -
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…Abdur Rehman 21 views 2 comments 0 points Most recent by Abdur Rehman Reporting and Analytics for SCM -
does Minimum Price in course creation is available in OTBI ReportSummary: Does Minimum Price in course creation is available in OTBI Report Content (please ensure you mask any confidential information): Version (include the version yo… -
Getting XMLPGEN - 03111 : User requested cancel operation ERROR in BIP ReportI have built a Order Management Pricing Report (BIP Report) Getting "User requested cancel operation" Error in the Report. Attached the screenshot for the reference, if …John Peter Noble-Oracle 193 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…Madushan Fernando 43 views 1 comment 0 points Most recent by Madushan Fernando Reporting & Analytics for Fusion Service -
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run …MandeepGupta 54 views 6 comments 2 points Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM -
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…Colin M 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t… -
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 61 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 21 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP -
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 132 views 3 comments 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM -
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to get Collective Agreement detail from Workforce Management - Worker Assignment Event Real TimeThere was an error rendering this rich post. -
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash JayavelPrakash Jayavel 41 views 1 comment 1 point Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include …MilanMohanty 21 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…