Sample Reports
Discussion List
-
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 41 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 103 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 62 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 601 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 151 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 41 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 194 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 33 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 782 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 232 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 957 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. …
-
Resource that is set in RBS is not able to appear in Smart View.Resource that is set in RBS is not able to appear in Smart View. I set new resource for Expenditure Category, Organization and Expenditure Type in order to varify if it …
-
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…
-
Absence Report CalendarSummary: Hello Experts I have been tasked to develop a Calendar Report that looks like the attached as the screenshot system will be replaced soon. I am uncertain how at… -
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Is there any seeded report that employees can use to list personal data stored on them?Summary: We have a request to make available in ESS a report to list all personal data stored by the company on the employee. Is there any GDPR seeded report for this? T…Lluis 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
we wants to fetch changed attribute detail in OTBI as per below screenSummary: Hi Team, we wants to fetch changed attribute detail in OTBI as per below screen so which subject area need to use ?. Thanks, Ajay Content (please ensure you mas…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Customize AP Check Print in FinancialsContent Hello all, I customised the template of the default AP Check Print and also attached my data model to it, yet it stills shows the seeded template when I print th… -
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 72 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Getting error -ORA-01840: input value not long enough for date formatSummary: I am getting error in BI report due to below line of code. Error - ORA-01840: input value not long enough for date format to_date(:sdt,'yyyy-MM-dd')Swati U 322 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 16 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM