BI Publisher
Discussion List
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 15 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM -
How to identify who removed a role for a specific userSummary: How to identify who removed a role for a specific user Content (required): Which table holds the details of who and when a specific user role is revoked for a p…Vinothkumar Somasundaram 218 views 2 comments 0 points Most recent by User_FPR9R Reporting and Analytics for HCM
-
Cannot get specific element entry values from XML data cache column for pending transactionSummary: We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entrie…Kaustubh Deshmukh 3 views 0 comments 0 points Started by Kaustubh Deshmukh Reporting and Analytics for HCM
-
Tracking Timely TerminationsHi Does anyone have or is aware of a report or dashboard that tracks the termination submitted for processing? We are having issues with overpayments to employees have s…Jose Guerra 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM BI Table to retrieve employees Eligible for a compensation planSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom BI reporting collecting compensation plan columns at the em…Valerio Curzi 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 52 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher ReportContent Hi Gurus, Can we Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher Report? I Created BI Analysis report and then Agent to call Analysis …Sunnyrajarora-Oracle 81 views 4 comments 0 points Most recent by PranayBhargava13 Reporting and Analytics for HCM
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Long running BI report send notification message to userSummary: Hi Team, we have couple of reports are running in production environment are very long running its not throwing an error can you please suggest how to set the l…
-
employee tax declaration table name in fusionSummary: Content (please ensure you mask any confidential information): Hi team , need help on table name . where we will get all employee chooses which tax regime data … -
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 11 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
In which case primary flag condition is null in WLF_AR_RELATIONS_F table?I'm trying to fetch course assignment details along with corresponding offering assignment details, in some cases the primary flag is null and for some cases it is 'Y' o…
-
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat…Stefano_Mazzocca 25 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
MilanMohanty 34 views 2 comments 0 points Most recent by Ankit Chauhan Reporting and Analytics for HCM -
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…Shikha Singh 21 views 2 comments 0 points Most recent by Shikha Singh Reporting and Analytics for HCM
-
User who executed or modified a report in Publisher ?Summary: Is it possible to know which user executed and/or modified a report in Oracle Analytics (Publisher) ? Content (please ensure you mask any confidential informati… -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 219 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…
-
Help in Query to get Variable Rate for a Benefit of an EmployeeSummary: Hello, Customer Connect! I am in need of developing to get these scenario: If the employee John is enrolled in the Benefit A with the option B, it have a rate v… -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…Maria Cristina L. San Jose 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…
-
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
HRT_PERSON_PERF_RATINGS_V shows all performance ratings not just talent ratingsSummary: When querying the HRT_PERSON_PERF_RATINGS_V table, values from incomplete performance documents will show. How do we otherwise restrict this table to show only … -
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 11 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report on Extract Definitions / Object Name / AttributesHello, I would like to create a report (Bi Publisher or OTBI). About Extract Definitions. I need following information Extract Definition Name Object Name Attributes Exc…Michael Schweizer 11 views 1 comment 0 points Most recent by Stephane Cote-Oracle Reporting and Analytics for HCM