Reports
Discussion List
-
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 32 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 54 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 -
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…Scott_Turner_ 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Oracle Compatible Tamil FontSummary: I have a Letter development which need to compile with Tamil Font. For that I have using Using NirmalUI font and it works fine with word format and rtf format. …Dhajani Perera 12 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Increase the session timeout for Narrative ReportingSummary: Excel Reference Doclet gets all the row heights perfectly set, all the shading the same percentage of grey, borders applied consistently across all the tables, …Himani Jain-Oracle 41 views 4 comments 1 point Most recent by Gebril Abdellatif -Oracle Narrative Reporting -
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_… -
unpivot dataSummary: Move rows to columns Content (please ensure you mask any confidential information): I am looking to unpivot the data and move Input Value Name and Displayed Inp…Julia Kiszelewska1234 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM