Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting and Analytics for HCM
Discussion List
-
Navigate to a Web Page (from OTBI) - dynamically changing POD reference in URL?Summary Navigate to a Web Page (from OTBI) - dynamically changing POD reference in URL link to HCM Fusion application page?Content We are using the "Action Links" -> "Na… -
HCM Auditing/ Audit reportSummary: Hi ALL, We'd like to understand what auditing is available and how detailed auditing would be enabled. It may just be an OTBI report, it may require some settin… -
SSN not removed from headingContent I want to modify alert notification template, where when employee update their contact relation, their SSN number should not be visible to approver. However when… -
Rest API to create individual compensation planSummary: Hi All, Is there any REST/SOAP API available to create individual compensation plan? Thanks, Venkatesan R Content (please ensure you mask any confidential infor…
-
If a EFF is does not have a value is there a way to pull it into reporting?We have some positions that have Extensible Flex Fileds Values for Backgrounds and Certifications - there are some positions where this information is not entered yet (s… -
User Role Audit ReportSummary: User Role Audit Report - We want to see when changes were made, who made the changes, what change was made, what role to user is added or removed Content (requi…
-
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…
-
HR Audit reportSummary: Hi All, I have a question regarding the HR Audit report feasibility. If HR were to identify sensitive data, is it possible to enable auditing on a handful of sp…
-
Last Date WorkedHow to pull "Last Date Worked" from Termination Info? Is there a table in BIP where we can pull this column?
-
Troubleshoot Incorrect Work Pattern SQL QuerySummary: Hello, I am a beginner with SQL and am trying to resolve an issue with an incorrect Work Pattern Report built for us by an Oracle Consultant. I am trying to get… -
Best Approach to Restrict Seeded Folders AccessSummary: We have users from 3 areas such as HCM, Finance and SCM. We have dedicated Custom reports folders for each set of users such as HRs can access 'Custom HCM Repor… -
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…
-
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…
-
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident… -
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can … -
Need query to get the list of all roles for a given roleSummary: Navigation: Tools > SecurityConsole > Roles If I query a role name, I want display all the roles associated with it. I want to build a query for the same. Pleas… -
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: … -
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…
-
table name for 'Performance Goals and Documents' section in Quick action - Local and Global TransferSummary: Please help me in finding the table name for 'Performance Goals and Documents' section in Quick action - Local and Global Transfer page. Content (please ensure …
-
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…
-
OTBI Report not match count - Absence ModuleSummary: I built a OTBI report using Workforce Management - Absence Real Time Subject Area, but I noticed in front-end there are 3 Absence Plans for my sample employee b…
-
Connection time out while scheduling BIP reports post 24C upgradeHi All, We are getting Connection timeout issue while scheduling BIP reports. This is something we are experiencing post 24C upgrade. Does this has anything to do with N… -
Which view/tables to access to create a report to capture User Login IP Address?Summary Which view/tables to access to create a report to capture User Login IP Address?Content IP Address of Application user in Fusion HCM is to be captured in a repor…
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th… -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…
-
Can we add a textbox (Number) as runtime parameter in OTBISummary: Hi team, Can anyone please confirm if, we can create a text box as run time parameter and we need to use that runtime parameter in one of the Column formula. Pl…
-
Can we change the row sequence in OTBI reportSummary: I have created an OTBI report, but one of the columns is not displaying in the same sequence as it does on the UI screen. On the UI screen, the column is showin…