Reports
Discussion List
-
Best method for reports to maintain a user's last entered POVSummary: Our users would like the last POV entered when running a report to come up every time. We're looking at user variables but this seems like it may take some work… -
Possibility to load in Reporting Cube in PCMSummary: We use PCM for allocating Cost. From a Reporting perspective, we have few details that are not involved in allocation, its mutually exclusive accounts, which we…Mary John-Oracle 41 views 4 comments 0 points Most recent by Mary John-Oracle Profitability and Cost Management -
Lease Liability report output blankSummary: Hello Team, When we are creating lease from User id, the output is blank, while if we run the same from Implementation user, it is providing output. any specifi…Nidhi Choudhary-69413 52 views 3 comments 0 points Most recent by Nidhi Choudhary-69413 Lease Accounting
-
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 213 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
FRS report duplicating parent when opening in BI catalog, but does not when opening in WebStudioSummary: Content (required): Hello: Does anyone have an idea why a row would duplicate for a parent when opening the report from the Catalog, but not when opening viewin…55Chevy 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Excel Preview in HFRSummary: Hi Everyone, Can we get an excel preview of the reports in Web Reporting Studio (HFR) - PCMCS alongside PDF and Web preview ? Content (required): Version (inclu… -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…Dona Das-Oracle 1 view 0 comments 1 point Started by Dona Das-Oracle Reporting and Analytics for HCM
-
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi…Shanna Oppenheim 1K views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…Danny Emmerton 203 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…Rebekah Gilday 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Errors found FBDI - Import Project Resource AssignmentsSummary: I am receiving these errors while performing the imports by project. Some of these I believe are caused by bad configuration data but not all. I am new to HCM a…Jon Calhoun 21 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Help! Formula column behavior in column groupingSummary: We have some reports where the design is best met via using Grouped columns and rows. Some grouped rows have their own formula row. When returning data, for for…James Holland II 71 views 11 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 312 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
How to Trim Aliases of Different Lengths?Summary: Is it possible to trim Aliases of different lengths in Reporting? We have to add member names to our Aliases to make them unique across all dimensions. Unfortun…
-
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 291 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 152 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
how to set Advanced Option on suppression rows in a specific member selectionSummary: Content (required): I have a BS reports with Accounts and Movements in rows. The select members for movement is: "Descendants of [FCCS_Movements].[FCCS_ClosingB…Gianluca Natili 11 views 2 comments 0 points Most recent by Gianluca Natili Financial Consolidation and Close -
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Development Goals view of Top 5 for different categories - not overallSummary: HI there, I am reporting on our Development Goals using "Workforce Goals - Goal Status Overview Real Time" As there are so many goals in our system, I want to g…Stephanie McInnes 41 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…SAKTHI SUNDAR 41 views 1 comment 0 points Most recent by Ankur Miglani Reporting and Analytics for HCM
-
Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S…Bobby Jourdan 61 views 9 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Enable "save as smart form" button in SVSummary: Hi All, I'm doing some testing on the subject of smart forms as I believe this form type might be of relevance for a customer. Then again, Smart View does not s…
-
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 31 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep T U 81 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM