Reports
Discussion List
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.7K views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing)Summary: Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing) Content (required): How are oracle customers that use EPM/EPBCS for project planning, appr…Andrew_Schmitz 21 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for ERP -
Books Updates - Just in Reports or also in FR Reports?Summary: Wanting to confirm if some of the new functionality released for reporting books over the last quarter are also available if a client is still using FR reports?… -
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 131 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Project Report focused on people project historySummary: Content (required): Hi team, I'm an HCM consultant so I have no experience about ERP - Project, sorry in advantage if I will say something not correct. A client…Gabriele Falso-Oracle 31 views 5 comments 0 points Most recent by Andy May-Coates-Oracle Project Management -
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 41 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
What’s New in EPM Cloud Narrative Reporting and Reports Release 21.11Summary: Learn about what’s new in the EPM Cloud Narrative Reporting and Reports 21.11 release. Content: Please refer to the November 2021 What’s New guide to understand… -
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
Report to Audit object migrationsSummary: A report that shows who created/updated application objects (i.e. Fast Formulas). Content (required): Version (include the version you are using, if applicable)…Wayne Smith 31 views 2 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click …
-
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 211 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c…Dhruvjoshi23 11 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
PBCS Invoke Fusion Financials BI Publisher report from Financial ReportSummary: As an alternative to drilling to Fusion Financials is there any way to invoke a BI Publisher report in Fusion Financials passing appropriate parameters? Content…User_2025-02-10-15-12-48-631 21 views 7 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Planning
-
PBCS - Comments - alternativesSummary: Alternatives to attachment notes and comment period for PBCS. Content (required): In PBCS, the client used to use the attachment functionality for appending not…User_2025-02-10-15-12-48-631 31 views 6 comments 0 points Most recent by User_2025-02-10-15-12-48-631 Planning
-
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us… -
Update UDA using API/GroovySummary Updating member UDA upon runnen calc ruleContent Hi all, For one of our customers we want to update (assign/remove) a UDA for the entity dimension, triggerd by a…
-
Report on 'Ad Hoc' feedbackContent The business has decided they want the option to give feedback without the one receiving the feedback being able to see it (don't ask me why). We've advised the … -
Termination Report Unable to Pull In SalariesSummary Trying to pull a historical report of terminations in a certain location with salary amount at time of termContent Hi - I have looked into a number of posts rega…Kyle Norris 72 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 21 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 511 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 31 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Schedule BIP in fusion in 1st 10 days of EVERY monthSummary: Content (required): Is there a way we can schedule a custom bi publisher report in fusion for the first 10 days of every month? Version (include the version you…Vinay Gharge 12 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
Year to Date Turnover FilterSummary How to return Year to Date (YTD) this year vs. YTD previous years for turnover metrics.Content I'm trying to return year to date turnover and compare it against …Ryan_Sullivan 35 views 3 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
GridNotes function - Extremely Slow!We are using the new GridNotes function on a report sourced from FCCS. We have 170 accounts on the rows (Hybrid Cube - DSO). The report runs without an issue without the…