Reports
Discussion List
-
Identify or link to affected embedded Grids/Charts in PPT docletSummary: Multiple embedded grids and charts in one single slide are broken and unidentifiable. Grids/charts come from multiple reference doclets. Content (please ensure … -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 5.9K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM -
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Using new Reports, how can you create with a prompt and also POV?In the old Financial Reporting, you could create a way to select a member via a Prompt and have it show up in the POV returning the selected dimension member, and then c… -
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 21 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 …
-
Project Costing - Actual Costs Real Time: want to summarize totals by GL expense accountSummary: Project Costing - Actual Costs Real Time: want to summarize totals by GL expense account. The subject area itself includes fields like Natural Account, Concaten… -
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 451 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 43 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 392 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…
-
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 11 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 12 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…