Category 81
Discussion List
-
Fast Formula for getting balance avail date in Oracle Absence Management?Summary: fast formula for getting balance avail date in Oracle Absence Management Content (please ensure you mask any confidential information): I need a fast formula fo…Ruvina Khan 19 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 98 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo… -
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 19 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 23 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
Custom Criteria Person Security ProfileSummary: Hi all I've created a custom role and created a Person Security Profile which is secured by Area Of Responsibility, and the scope of responsibility is Organizat…Nicolas-Vahman 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to Retrieve Qualified Entitlements Plan Details Using OTBISummary: Unable to Retrieve Qualified Entitlements Plan Details Using OTBI Content (please ensure you mask any confidential information): Hi Experts, We have a requireme…Vasanthakumar Ravi 18 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to perform conditional formatting on Excel template when old value is not equal to newSummary: I have built a Changes only extract to get the employee Demographic information and getting data in Excel format in separate sheets. First sheet contains new hi…Sreenivasulu Kaveti 17 views 0 comments 0 points Started by Sreenivasulu Kaveti Reporting and Analytics for HCM -
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom… -
SQL to fetch the Target Proficiency field in the Performance DocumentHello Experts, I am currently creating a report for Core Competencies, and I am having a hard time searching for this specific field in the performance document page Doe…Joliver Caangay 16 views 0 comments 0 points Started by Joliver Caangay Reporting and Analytics for HCM -
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…Rohit Kumar Singh 460 views 7 comments 1 point Most recent by SirilG Reporting and Analytics for HCM -
Is anyone else getting a geospatially error in their Payroll Validation Report?Summary: In the Payroll Validation report, we are getting this error for all employees in the first pay cycle since going live on 25C: "The address couldn't be validated… -
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 6 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_… -
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to… -
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain… -
Required table for Quick move action for Candidate Selection Process Configuration in ORCSummary: Required a table or SQL query where the information of Quick move action stored for the HCM-ORC setup Candidate Selection Process Configuration. Attached screen… -
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Not able to retrieve data from Security - Roles and Privileges Real Time subject area.We are not able to retrieve data from Security - Roles and Privileges Real Time subject area. We are trying to fetch columns from the folder Function Security Policy, Da… -
How to get users logged on info in HCMSummary: User session info required Content (required): Need to get logon info for users. Seems to be a few posts but not a concrete answer. FND_SESSIONS seems to hold t… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Benefits Enrollment Window - reporting on window start and end dateI would like to be able to report on the start and end dates of a benefits enrollment window. What table or what OTBI subject area would have these dates?Stephen Jones 22 views 5 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM -
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 153 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM -
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…Khel 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Values not populating in 'Recruiting - Recruiting real time' subject areaHi Oracle community, When we create an analysis using the 'Recruiting - Recruiting Real Time' subject area, filter the results to show only the Recruiting Type 'Offshore…Alyssa T. 18 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 83 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every… -
How do we pass multiple input values for a parameter from Payroll flow to a Bi report.Summary: We have a requirement where in we want to pass multiple input values for a parameter from payroll flow to a bi report. How do we achieve it. We have created a B…User_ANH3E 97 views 9 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM -
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 45 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM