Sample Reports
Discussion List
-
Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…Gerardo Peluso 33 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM -
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated…
-
OTBI - Count FunctionSummary: Content (required): I have the below requirement, A report to capture all transaction details and the entry users has already been created. (The format is attac…Sheneli98 1.6K views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
A report for print options for AR customers - Missing FieldSummary: A report is required to detail the print options for AR customers The issue I am having is location the tables that hold Statement Preferred Delivery Methods fr…User_2025-02-11-10-53-01-866 51 views 2 comments 0 points Most recent by User_2025-02-11-10-53-01-866 Reporting and Analytics for ERP -
Payroll Element QuestionnaireSummary: Looking for a query to Fetch the Payroll Element Questionnaire Details Can any body Please share a query to Fetch the Payroll Element Questionnaire details Cont…MilanMohanty 380 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Remove White Spaces from RTF TemplateSummary: Hello All, Can any body please suggest on removing white spaces from RTF Template. In the the RTF template ->Right Click Paragraph ,We have tried to set the Par…MilanMohanty 1.7K views 1 comment 0 points Most recent by Natalia Rappleye-Support-Oracle Reporting and Analytics for HCM
-
How to use drilled down in BI Report when I use normal layoutSummary: How to use drilled down in BI Report when I use normal layout Content (required): I have graph in my BI report and what I want is - when we click on graph it sh…
-
Transfer Dashboard's gear icon to the HCM UIHello, Our client has a requirement, in which he wants the user to have access to the page options (gear icon) of the dashboard in the HCM UI, in the exact same manner i…Ioannis Adamou 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed …Sushan Peiris 41 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 51 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 711 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 21 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
OTBI report that show multiple course completion status with each course as a separate column?Summary: I am hoping someone can help. I would like to create an OTBI report that shows the course completion status of multiple courses where each course is a separate …
-
how to create extract such that it should only give the record for which department has changed.Summary: how to create extract such that it should only give the record for which department has changed. Content (required): This is change only extract. I have created…
-
Seeded pick slip report submitted from inventory UI in wrong languageSummary: Content (required): 1- Log in to Oracle in French (All the settings in French in manage user preferences) 2- Go to manage pick slip screen in the inventory modu…
-
Not able to add filter to question text in OTBI reportSummary Not able to add filter to question text in OTBI report Content (required): I am using "Workforce Management - Checklist Real Time " subject area and when i tried…
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh Kumarasamy-Oracle 85 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP -
Supplier Audit ReportSummary Supplier Audit ReportContent Good People, Anyone create supplier Audit Report as a custom one apart from the one available ? Thanks, SoumyaSoumya Prakash Parhi 204 views 18 comments 1 point Most recent by Gaurav Jain _Infosys Reporting and Analytics for ERP -
How to display old and new cost center in HCM extractSummary: How to display old and new cost center in HCM extract Content (required): We are creating one HCM extract report to display old and new cost center. We are able…
-
we need subject area for career and peoformance in performance Connect ConversationsSummary: Hi Team, we need to track the career and peoformance>peoformance>connect conservation >Performance Document Name related columns in OTBI any one have any idea h…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Are Quick Actions ReportableSummary: Is there a way to report on Quick Action data via OTBI? If not, how can you pull data related to Quick Actions? Content (required): Version (include the version…
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…User_2025-02-05-12-20-44-163 36 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
New Bite-Size Learning Videos Published for HCM AnalyticsSummary: Need to learn how to modify OTBI analytics? Please check out the new Bite Size Learning videos just published to the Oracle Help Center Bite-Size Library page: …Cindy Klymov-Oracle 221 views 0 comments 8 points Started by Cindy Klymov-Oracle Reporting and Analytics for HCM -
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 541 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM