Sample Reports
Discussion List
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 788 views 13 comments 11 points Most recent by UchihaItachi Reporting and Analytics for ERP -
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont… -
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
FDI - Custom Security Context LOV returns row-level values instead of value-based valuesHi, We are currently implementing the security configuration in Oracle Fusion Data Intelligence (FDI). In addition to the 5 standard Security Contexts available, we need… -
How to add an image in customize on email custom with datamodelSummary: Content (required): Hello, We are creating custom notifications for the learning module for a client. In particular, we have created both reports, bursting and … -
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …Mohak Kirtane 143 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
Historical Training Reports Missing Former Employees and Showing Incorrect “Withdrawn” StatusSummary: Hi everyone, I’m encountering an issue in Oracle Fusion Cloud while trying to retrack historical training records, and I’m hoping someone here might have come a… -
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not… -
Customize / add new options to Selection Process Diversity delivered reportSummary: I'm hoping someone can help me understand how to modify delivered Selection Process Diversity analysis (I know I have to make my own copy to edit) that is part … -
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera… -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.1K views 19 comments 22 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.4K views 30 comments 31 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF Reporting and Analytics for ERP -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 251 views 16 comments 0 points Most recent by Archana Prasad Reporting and Analytics for HCM -
Built a report for learning communitySummary: Content (required): Hi All, I got a requirement to built a learning community report based on name, person number, Email Id, Status, Role, Added By, Creation Da… -
Is it possible to fetch details of community in Learning?Summary: OTBI report to fetch community details. Checking on the below subject areas for Learning, there is no related to Community. Workforce Learning - Learning Conten… -
How can we change the default template for the ESS Job Print Receivable TransactionSummary: I want to use another RTF for the standard ESS Job Print Receivable Transaction job Content (please ensure you mask any confidential information): Version (incl…Burcu Terzi 12 views 3 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.5K views 21 comments 1 point Most recent by SangeethaSekar-Oracle Reporting and Analytics for HCM -
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 3.5K views 13 comments 0 points Most recent by JimCC Reporting and Analytics for ERP -
BIP Report to Track “Synchronize from Position” UpdatesSummary: Hello, Is there a BI Publisher (BIP) query or report that captures all attributes updated by the “Synchronize from Position” action on a daily basis? Any pointe…Explorer 21 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Need report that shows all approval assignees who have NOT approved invoiceSummary We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)Content We a…User_2025-01-28-19-14-07-225 587 views 19 comments 2 points Most recent by cylim Reporting and Analytics for ERP -
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …Chandramouli Yangareddy 61 views 7 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
GL Analytics dashboard in OTBIHas anyone created a GL analytics dashboard that they are wanting to share? I am trying to create a dashboard that gives our finance department/CFO all the information w… -
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 91 views 3 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the …MDge 31 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end … -
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name … -
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 211 views 6 comments 0 points Most recent by lbodeddula Reporting and Analytics for HCM -
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…kalyan gade 611 views 6 comments 0 points Most recent by User_GMBW9 Reporting & Analytics for Fusion Service