Category 81
Discussion List
-
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
Redwood Performance 'Action' Warning Message, why does it appear and how do we edit these?Summary: Within Redwood Performance Documents there are a variety of different 'warning messages' that appear in relation to the document task, is it documented why each… -
Person Security Profile not Working in OTBISummary: We have created a Employee custom role and attached a person security profile to employee. Employee can only view his own record in UI. We have created an OTBI …Hassan M. RG 15 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Add Date and Timestamp in OTBI Analysis NarrativeSummary: I did not see this anywhere on the forum, in case anyone else is interested, we preferred to add a timestamp here versus the Title "Started Time" option as this… -
How to duplicate a page in the dashboard?Summary: Hello, how to duplicate a page in the dashboard? I want to copy a page in existing dashboard so I could have the same layout. Thanks! Content (please ensure you…
-
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
Goals Subject Areas returning no resultswe have created a simple OTBI report using SA like "Goals Review" or "Development Goal Real Time" with only two columns 1. Person Number, 2. Development Goal Name. It is…RahulMore 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 603 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
can we have different Font style for e-sign on offer letter templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…YOGESH SAMPANGI 3 views 0 comments 0 points Started by YOGESH SAMPANGI Reporting and Analytics for HCM
-
BIP or OBTI Auditing Users making changes to their own HCM/Payroll DataSummary: Does anyone have or know of any current reports that will give details on Oracle HCM users who have made data changes to their own Global HR/Global payroll info…
-
How to fetch Resignation details, which include Resignation reason,,Summary: This is the resignation page in Me tab. How to fetch all These details using SQL?Aryan Yadav 13 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur…
-
Additional Person Info - Historical Reporting in OTBISummary: I'm trying to write an analysis in OTBI that includes historical Additional Person Info Content (please ensure you mask any confidential information): The analy… -
Report on User Name Last Updated DateSummary: I'm looking for a report to tell me the last updated date / last updated by for the User Name, please Content (please ensure you mask any confidential informati…
-
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
Ability for employee to self report a conflict of interest.Summary: I have a requirement for an employee to be able to self report conflict of interests, including employment of relatives, material interest and outside interest.…
-
The manager and assignment details are not displaying on the Security Console page for the employee.Summary: The manager and assignment details are not displaying on the Security Console page for the employee. Content (please ensure you mask any confidential informatio…
-
AI Agent - Journeys icon not foundSummary: HI, I have created Tool, Agent and Guided Journey. But I can't find 'Journey' . Please advise how to get this. Thank you! Content (please ensure you mask any co…Babu Chalamalasetti 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI filter - Two columns don't matchSummary: Is it possible to create a filter (maybe a new column to calculate?) to only provide results if two columns don't match? I can't imagine it's a common thing, bu…
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Duplicate a page in Dashboard - OTBISummary: Content (required): Hi there How can I duplicate a page in an OTBI Dashboard? Thanks Bobby Version (include the version you are using, if applicable): 21C Code … -
WorkRelationshipPVO missing DFFsSummary: WorkRelationshipPVO is missing DFF's such as PDS_INFORMATION% and PDS_INFORMATION_DATE% columns from PER_PERIODS_OF_SERVICE. We are using DFF's to populate cust…
-
Benefit Enrollment Report which has all Life events and the Enrollments in an excel format?Summary: Content (please ensure you mask any confidential information): Can someone share the report format where we have the following format Effective date Life event …Hariharan_Sivan 3 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Need Oracle SQL query to get the Office number for Location details from Assignment pageSummary: Need Oracle SQL query to get the Office number for Location details from Assignment page Content (required): Need SQL Version (include the version you are using… -
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…
-
LOOKING FOR OTBI REPORT FOR EMPLOYEE AND CONTACT DETAILSI am looking for a report that shows the details of Employee and the Contact details. Columns such as Employee Number, Employee name, Contact Name, Contact Phone number,…
-
Performance Managment Document ReportingSummary: I need to know how to pull Section Comments made on Performance Goals, in the Performance Document. These are the Goals that are pulled into the the Performance…
-
OTBI Report data issueSummary: OTBI Report data issue Content (please ensure you mask any confidential information): Hi All, We developed OTBI report with Workforce Management - Worker Assign…
-
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h…Valerio Curzi 112 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM