Reports
Discussion List
-
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report … -
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 11 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 22 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can I remove the blank row from the NR reportHey All, I am working on formatting a report and it seems that there is a blank row appearing always when I export to report to excel file. Is there a way I can remove t… -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.4K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Missing transactions and Balances from Lease balance tablewhat are staging tables and what are the transactional tables in leases. Because when using FLA_LEASE_BALANCE_ALL, it seems the data doesn't get populated until there is…
-
Talent Profile report not printing few valuesHi, I am looking to extract license and certifications, career preferences values in print profile Navigation: My career->My profile->skills and qualifications -> action…
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 465 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 31 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 14 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 52 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…