Reports
Discussion List
-
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
How to call HCM extract parameter in BIP report.Summary: Hi all, I am working on a loopback integration where I have built a BI report which fetches the data according to the parameter which will come from HCM Extract… -
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…Vishnupriya 16 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 1.2K views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Counting duplicate in ETEXTSummary I have two record coming from XML , I want to restrict it in ETEXTContent Example - In XML - Employee - 1 has record A1 and Record B1 Employee - 2 has record A2 …
-
Address Change Notification Not Reflecting the Changes in the NotificationSummary: New fields have been added to the Address Change Report (Report Name: PersonalInformation_AddressReport). While the changes are being pulled into the report cor…Balavignesh A 62 views 14 comments 0 points Most recent by Balavignesh A Reporting and Analytics for HCM
-
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 139 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
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.5K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM
-
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 14 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 (…
-
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 409 views 7 comments 0 points Most recent by Ignacio Velando-Oracle Reporting and Analytics for HCM
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha… -
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… -
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
-
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 360 views 7 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for HCM
-
../ 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 2 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 33 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 -
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…
-
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 32 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 411 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 301 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 Access Oracle HCM Cloud User Activity Audit data via API or any method ?Summary: Customer has a requirement to track the activities logs data performed by HCM Cloud User via API or any other method. They are interested to fetch the user even…RBM 321 views 8 comments 1 point Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Smartview Error - "Unable to get property 'open' of undefined or null reference'Summary: I get the following error when running a macro to generate a report in smartview: "Unable to get property 'open' of undefined or null reference. Any assistance …