Sample Reports
Discussion List
-
Table name to join course with competency/skill/certification details direclySummary: Hi Team, I have one requirement where we need to fetch course wise skill/competency/certification details. Please help to apply direct join to the skill/compete… -
Export is incomplete due to error JBO-25060: How can it be generated completely?Summary: Content (please ensure you mask any confidential information): The business area generated a export on the portal of employees who completed the offers. However… -
Exclude course completions from AnalysisContent Anyone have an example of an Analysis filter that excludes associates who have completed a specific course? If so, can you share? Thanks, Lena Version 20D -
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 1.1K views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…Sushan Peiris 1.2K views 2 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 1.1K views 12 comments 13 points Most recent by Samuel Bassey Reporting and Analytics for ERP -
Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWVSummary: Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWV Content (required): Exceeded Configured Maximum Number Of Allowed Output Promp…Swati U 516 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
oracle learning cloud requirement gathering templateHi Team, I would like to get OLC (Oracle Learning Cloud) requirement gathering template Thanks in advance
-
we joined two subject areas but when we apply single country it is woking fine but multiple not workThere was an error rendering this rich post.AjayKumar Maddipati 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 42 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC.Gowri Perumal 102 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Issue with Dependent Filters and Multiple Selections in BIP Report for CoursesSummary: Hi Team & @AshishERPCloud, I have created the BIP report for the Courses. Where I have given the filters of Course, Offering, Business Unit, Start and End Dates…Dasari Dileep 68 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM
-
Where to find/add Brazil Job Details attribute values ?Summary: I am not able to find this Brazil Job Details values in Job Details/Jobs page. I believe its an attribute under a delivered DFF attribute (as shown in the Desig…Anshuman Chatterjee 51 views 5 comments 0 points Most recent by Anshuman Chatterjee Reporting and Analytics for HCM
-
Where can we find a common calendar area to see all learning sessions scheduledSummary: Hi, we have a requirement where customer wants to have a broader look at the entire calendar area to see when are all learning sessions scheduled by different I… -
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'…Karen Florig 611 views 4 comments 0 points Most recent by Durga Prasad Tavva Reporting and Analytics for HCM -
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 171 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
Seeded Head Count Reports Not WorkingSummary: We have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. Content (please ensure you mask any confident…Vibha Pandey - Oracle 46 views 3 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 161 views 3 comments 0 points Most recent by Madhavi.Modala Reporting and Analytics for HCM
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 203 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
How to create a dashboard for a cash control budgetSummary: This document provides an overview of how to install and use the Cash Control Dashboard Content (please ensure you mask any confidential information): The Cash …Teresa McGoldrick-Oracle 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
OTBI Performance Management Summary dashboardSummary: Need path for this seeded report dashboard Content (please ensure you mask any confidential information): Our customer has this screenshot showed and mentioned …Rajkumar Subbareddi 71 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
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 785 views 12 comments 11 points Most recent by Melissa Goodrich Reporting and Analytics for ERP -
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure …MilanMohanty 1.3K views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 234 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 962 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Link between Cost Management, XLA and GL_Code_Combinations tables in FuisonSummary: Link between Cost Management, XLA and GL_Code_Combinations tables in Fuison Content (please ensure you mask any confidential information): We need to build the …
-
Export To Excel Downloads Output Files As .xls Instead of .xlsxSummary: Customer wants to download all the exported files in .xlsx format but oracle is defaulted to .xls format. Is there any way to change it across all the modules. …