Category 81
Discussion List
-
OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitleSummary: HcmTopModelAnalyticsGlobalAM.OrganizationAM.OrganizationUnitPVO field OrganizationUnitTranslationPEOTitle showing NULL VALUES Content (please ensure you mask an… -
View Formatted HTML Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …Tanu Shri Patel 81 views 3 comments 1 point Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to get active user report based on employee idSummary: Is there a scheduled process or BI report which gives a list of all active employees in Oracle based on employee ID? Content (please ensure you mask any confide… -
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 11 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 673 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 1 view 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 11 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 1 view 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,…