Reports
Discussion List
-
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a formula to create a cumulative sum column in a management report?example: the grid would consist of row intersection containing multiple segments, so it could not be a manual effort. There are thousands of segments. Thanks for the sup…
-
Report to show Deleted Payroll ElementsSummary I need to generate an Audit report showing when an element was deleted and by whoContent I tried running the Deleted Data Report but I didn't get any information…User_2025-02-04-08-51-08-912 44 views 9 comments 0 points Most recent by Julie Searles Reporting and Analytics for HCM -
When adding field to my report, the Matrix Manager values are being eliminatedSummary: I have a report that includes both Worker Assignment Real time and Compensation Salary Detail subject areas. I have been able to add all desired fields successf…Darrin N 32 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Creating a rolling quarter report in application with 13 periodsSummary: We have 13 periods in applications, and we are trying to create a report for rolling quarters, for all the period's "parent of periodoffset of currentperiod-3)"…AnkitGupta07 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Navigation Flow - New Card in a Custom Cluster Not visible for all usersSummary: We have created a new card under a custom navigation flow cluster to include a new area for our users to easily access reports. We have had this Tax Provision c… -
Narrative Reporting- How to override a row dimension based on a selectable pov dimension?Summary: I have a custom dimension in the rows of a report. I need to set the row custom dimension based on the year in the pov. For example, If the year selected in the…643dp 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
User is not able to delete a folder in new Reports card in EPBCSSummary: A user who is a power user is able to delete the report in a folder but not able to delete the folder in new Reports card(MR) in EPBCS. User is having write acc…
-
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In…Naveen Jayaraman-48236 80 views 5 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Sickness - Avg day lost and % time lostContent Hi I have created a report to work out average days lost and % time lost , but in order to do this I need the total number of working hours available (which I al…User_2025-02-06-11-18-47-896 49 views 4 comments 0 points Most recent by BillM Reporting and Analytics for HCM
-
Create Batch with new "Reports" card?Summary: Hi, Is it possible to create batch with new Reports card which is possible with Financial Reports in Explore Repository? Thanks, Srujan. Content (please ensure …
-
Quick question: Is there a way to confirm when a report was last opened ?Summary: Hi friends. I am doing a reports and analytics audit, of sorts, and am looking to delete reports that are no longer utilized. How can I confirm when a report/an…Erin Hamrick 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Problem with the sender for a bursting reportHi folks! I'm developing a simple notification with BI Publisher report using the bursting, but if I use for sender any address with domain @customer.com the system indi…Gian Luca Triglia 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there a way to extract filter criteria for multiple extracts in one goSummary: Is there a way to extract filter criteria for multiple extracts in one go Content (required): Hi Team, Greetings! We are checking for the HCM extracts which use… -
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 51 views 10 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to show parent currency in report header based on currency selection dynamically?Summary: Now when I select parent currency, it should pick parent's currency let's say "USD". Content (please ensure you mask any confidential information): Version (inc…AlokPriyadarshi-Oracle 51 views 7 comments 0 points Most recent by AlokPriyadarshi-Oracle Financial Consolidation and Close
-
Is there a way to create the function to show the Quarter and Total Year as function from ADB cubeSummary: We want to create the report retrieved the data from ADB Cube in ERP. The thing is in the Accounting Period Dimension, it consists of Years, Quarters, Months an…Sukittima Siwapetcharakorn 31 views 2 comments 0 points Most recent by Sukittima Siwapetcharakorn Narrative Reporting
-
Summary page in Management Reports in EPM Planning when selected multiple entitiesThere is a need to display the summary of the entities selected based on the prompt. Example: Let's say there are 5 entities: 01, 02, 03, 04, and 05, and the P&L account… -
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …Santo Campione 21 views 2 comments 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
Experiencing blank fields in extract output.Hello Team, I have created an extract with Future UE and I'm experiencing blank lines in complete rows count in number six in output file. Do you have any idea regarding…
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Performance issues after 23.12.51 has been applied on TestSummary: Anyone else seeing peformance issues after the latest release has been applied on Test? Smart View drill takes 10-15 seconds to complete. Large FR Report does n…Greg Hull 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 51 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
CBCR XML in TRCSSummary: Hi Team, we have recently enabled the CBCR in TRCS, we enable this after an year of TRCS implementation. Business is looking for the XML report generation. we d…Sai Ganesula 31 views 2 comments 0 points Most recent by Al Marciante-Oracle Tax Reporting (Direct Tax)
-
Is there a SQL query to get employees processed in extract run?Summary: Is there a SQL query to get employees processed in extract run? Content (please ensure you mask any confidential information): there a SQL query to get employee…
-
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo…
-
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM -
Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc formatSummary: Can anyone suggest an alternative to PCM Queries in EPCM to extract data in a specific Adhoc format. We have a requirement to extract nearly 40,000 lines of dat…Vikasitha 21 views 3 comments 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management