Sample Reports
Discussion List
-
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… -
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.4K 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 22 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 588 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 92 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 216 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 605 views 6 comments 0 points Most recent by User_GMBW9 Reporting & Analytics for Fusion Service -
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 … -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 1.2K views 17 comments 5 points Most recent by G.Bhanu Prasad Reporting and Analytics for ERP -
Requirement to Add Print / Approval Printout Action in BPM Worklist Approval PageSummary: Hello Oracle Team, We have a business requirement to provide a Print / Approval Printout functionality directly from the BPM Worklist approval page in Oracle Fu…Thirumalai Kannan K 2 views 0 comments 0 points Most recent by Thirumalai Kannan K Reporting and Analytics for HCM -
Anytime Feedback Report template - need helpSummary: Need help on this: When I use the Subject Are: Work Profiles - Feedback Notes by Recipient Real Time, the report is fetching all data from feedback and meeting … -
enrollment number should not be nullSummary: Description:I have loaded learning record for one learner by using hdl. For learning Record Number column i had given value as null[system is not allowing to lo… -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 91 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM -
LMS Utilization ReportSummary: I need to build a report in OBTI that shows our LMS Utilization Rates for our Executive Team. Does anyone have any examples or files that they would be willing … -
Report descriptionSummary: I would need a complete list of Out Of the Box Reports for Oracle ERP and SCM. Content (please ensure you mask any confidential information): I would need a com…DamianLopez7 11 views 4 comments 0 points Most recent by DamianLopez7 Reporting and Analytics for SCM -
HCM Alerts Composer: Not able to loop the comma-separated data to one below the other inside a TableSummary: We are looking for a way to get the comma-separated values one below the other. Content (please ensure you mask any confidential information): Version (include … -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
FRS report is going into error after migrating to UAT instanceFRS report is going into error after migrating to UAT instance. The migration was done by two different methods. 1. Archiving from SIT and unarchiving to UAT. 2. Exporti… -
Is there a way to identfy open subledger transactions in the general ledger?Summary: We have a custom report requirement to extract account balances for specific accounts for open transactions only. These are either receivables or payables that …len.baetiong-Oracle 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 646 views 5 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Catalog object privilege validation failed for userSummary: Catalog object privilege validation failed for user Content (please ensure you mask any confidential information): Have downloaded a seeded report for HCM. When…Junade_Shujaat 79 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM