Reports
Discussion List
-
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 33 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Payroll DD/Taxes Report SQL HelpWe have a New Hire Direct Deposit/Tax report that captures employees who have not completed DD and/or Taxes. How would I update the query to pull all new hires/rehires (… -
How to bring history data using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE in HCM ExtractWe are using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UE in our HCM Extract to fetch "Full Time or Part Time" field along with other fields. The requirement is to fetch for fut…
-
Which table contains the cross charge business unit exceptions?When creating a project there is a section on Cross-charge options that lets you specify "Allow Charges from All Provider Business Unit". There is then an area to add a …
-
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 479 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. 2 views 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 407 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 2 views 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 14 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 13 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 491 views 10 comments 1 point Most recent by Prasanth Subbaiahh-Oracle Reporting and Analytics for HCM