Reports
Discussion List
-
Cost centres report in OTBISummary: Hi, I am wondering if anyone has a way of reporting on cost centres along with HR employee data in the same report. So far i have seen that Payroll costing setu…BillM 456 views 7 comments 0 points Most recent by Ignacio Velando-Oracle Reporting and Analytics for HCM -
Auditing of Users Running Financial Reports/Management Reports in Oracle EPM Cloud PlanningOur institution is seeking a way to retrieve how often our users run Financial Reports and/or (Management) Reports and the names. We understand that there is an Activity…
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
How can i integrate the p_start_date and p_end _date parameters into this query in BI Publisher?Summary: I need to integrate the p_start_date and p_end _date parameters into this query in BI Publisher Content (please ensure you mask any confidential information): V…
-
how to restrict person details post Global transfer in extractWe have an HCM extract with PER_EXT_PAY_EMPLOYEE_UE. After a global transfer of any record, there may be changes in person address, SSN of a person. for example, US to C…
-
Push Sparse Dynamic Calc BSO data to store member in ASOSummary: I have a member formula in Plan Element to calculate for % Sales. This member in Plan Element is a Dynamic Calc. I want to push the data to a store member in AS…
-
Bullet points formatting getting changed during output of bursting BIP reportSummary: We have bursting report which sends email notifications. We have designed the RTF template and providing some instructions like below format. But while sending … -
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 1 view 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Issue in EPM PLANNING/FCCS reports when downloading to excelSummary: Hi, customer is annoyed when downloading EPM Planning/FCCS reports to excel since they must always do some cell type editing to show whole values. 0.X% Values a…JuliusHannuksela 41 views 4 comments 1 point Most recent by CBalaKrishna Financial Consolidation and Close
-
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H…User_6U8NQ 405 views 7 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for HCM
-
Embedded Report in Doclet Not Displaying All Rows and ColumnsBackground: We have developed several reports in Narrative Reporting (NR) using an A4 layout. These reports render correctly when viewed directly via the Report Viewer. …
-
../ directory path reference tag in RTF is not working properly in BI Analytics.Summary: ../ directory path reference tag in RTF is not working properly in BI Analytics. Content (please ensure you mask any confidential information): We are using the…Lokesh Ramesh 1 view 0 comments 0 points Most recent by Lokesh Ramesh Reporting and Analytics for HCM
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 12 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can I report on a specific pay element in OTBI?Summary: I need to be able to include a specific pay element but OTBI excludes anyone who doesn't have this Content (please ensure you mask any confidential information)… -
We have Job Application - Progression"."Current Phase" but it showing only phase like New onlySummary: Hi Team, Below subject area we rae using to know the Job Application - Progression"."Current Phase it showing of New or another phase but we need days in Phase …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Filter null values on a DashboardSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use…Guido Masciello 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Can you please provide the SQL query for fetching the source ids for calculation cardsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
rows not suppressing in Reports when column formulas are presentSummary: I have a simple example where I have formula column in a report (Column D) with a simple formula [B]-[C] to calculate a variance. I have row suppression = True …
-
How to display Prior Day date using DateTime (short, none) function in the Narrative ReportingSummary: Using the DateTime (short, none) function to display the current date but we would like to display the PRIOR DAY date on another column. what are the options to…
-
NULL values in OTBISummary: I think it is generally best practice to suppress NULL values in OTBI, but client wants to keep them in report. But in their case, it's selective. Can we enable…
-
Need a table or query to get Latest open period column in Manage Intercompany Period StatusSummary: Hi Support, We need a table for the column's "Latest open period" and "Open Transactions" under the setup Manage Intercompany Period Status. We have the table F…
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, …AjayKumar Maddipati 12 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Add a hyperlink to an image in a BI Publisher Interactive reportSummary: In an interactive report, it is possible to add a link to text using the appropriate icon, but how do you do it on an image? Thank you Content (please ensure yo…Guido Masciello 31 views 6 comments 0 points Most recent by Guido Masciello Reporting and Analytics for HCM
-
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…Vasco 483 views 10 comments 1 point Most recent by Prasanth Subbaiahh-Oracle Reporting and Analytics for HCM
-
How to remove extra rows in report?Summary: Hello, I need help on removing these extra rows. These are my filters. Can you help to check what's wrong? Content (please ensure you mask any confidential info…
-
Element Entries Reports No Results on OTBISummary The specified criteria didn't result in any data ErrorContent Hello. I'm trying to report element entries on OTBI using the "payroll - element enteries history r…BenZionP 322 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaSummary Not able get information in "Workforce Succession Management - Talent Pools Real Time" subject areaContent Hi Expert, Not able get information in "Workforce Succ…User_2025-02-05-01-04-36-989 37 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM -
how to see when a role was deleted from a user?Summary: how to see when a role was deleted from a user? Content (please ensure you mask any confidential information): how to see when a role was deleted from a user? a… -
Sequence of Prompts has been changed after migration from FR report to MR reporthttps://us.v-cdn.net/6034893/uploads/KYTQ9EHIOTDG/sequence-of-prompts.docx Summary: Observed the sequence of prompts in FR report and MR report after the migration. In F…