Sample Reports
Discussion List
-
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 281 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 212 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 62 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 135 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…
-
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 63 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…Hitha Harikumar 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
when the employee has signed the contractSummary: Hi experts, we have the following requirements: for all the employees it is necessary to retrieve info such as their person number and when they've signed the e…Oriana L. 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Does oracle provided any learners reporting dashboardSummary:Does oracle provided any learners reporting dashboard ? Do we have any standard dashboard on oracle learners reporting? Content (please ensure you mask any confi…
-
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 114 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
Dhajani Perera 1 view 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Report to fetch the user logs in the system.Summary: Hello We have come across a requirement where we need to understand if there are any standard pages/reports through which, we can fetch: The logs of all the use…Osama Qamar 1 view 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 2.3K views 14 comments 15 points Most recent by User_2025-10-31-00-30-05-350 Reporting and Analytics for ERP -
Can Learning module integrated with third party Mobile APPWe have a requirement to integrate Oracle fusion learning module with third party mobile app with all the progress detail(360 View). IF Yes then what all API's are avail…