Category 81
Discussion List
-
New fields not showing any data in rtf template for document of recordsHello, I have one Document of record which is working fine but requirement is to add 3 new columns in that , For example Notice period/Hours and contract so i added all … -
Which table stores the acknowledgement date of performance document and comments entered by employeeSummary: We are trying to customize one performance module seeded report. In the report, we are trying to fetch whether document is acknowledged by employee or not. If y… -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
Is there a report that lets you know when there is an empty position with direct reportsSummary: Hello - We are trying to find out if there is an alert, notification, or OTBI report that is delivered when there is an empty position with direct reports. We w…G. Class-Peters 21 views 6 comments 0 points Most recent by G. Class-Peters Reporting and Analytics for HCM -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 91 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 821 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Unable to find Title field (on Record External Learning Experience page) in OTBI ReportHi Team, We are unable to find below field in my OTBI report. Could you please help us to find the same. Field Name: "Title" (on Record External Learning Experience page…User_2025-02-12-02-03-48-970 41 views 9 comments 0 points Most recent by User_ZKDAR Reporting and Analytics for HCM -
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM -
Logic to know the Insert/Update/Delete as Audit Action in Audit Salary Report for HCMWe want to build an HCM audit report in OTBI. HRDirect needs an audit report to see when a salary change was added, updated or removed an individual. Filters: Employee I…Mukesh Bulla 34 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Any Suggestions of how to improve HCM Extract completion time!Summary: We are facing an issue with the custom HCM extract which is running and taking a long time to generate the XML output (5 employee data for 10 minutes). We have …
-
Asking for some tips for these column in OTBI to BIPSummary: Hi there!. May I ask some idea where I could find these columns in BIP - Report Content (please ensure you mask any confidential information): Version (include …
-
Can you pull columns from one OTBI analysis report to another like a Vlookup?Summary: We have created a Checklist Task which has a DFF that generates a Person Number ("Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_DESC_NOMINEENAME_") an…Stephanie McInnes 152 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI excluding the requisitions that are in any other phase other than "Open"I am creating a report using "Recruiting Real Time". The report works fine when i run with the basic attributes like Requisition number, name etc. But as soon as i inclu…Girish Bhatia 12 views 5 comments 1 point Most recent by Alice Gouzy Reporting and Analytics for HCM -
Compensation Business Process Dashboard Access ControlSummary: Business requirment is to restrict access to the seeded Compensation Business Process Dashboard for Line Managers. Identified that Workforce Transaction Analysi…SaiGayatri Chevooru 32 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Role for OTBI reportSummary: Role for OTBI report Content (please ensure you mask any confidential information): Hello experts, we have created a custom role (BI-Abstract) that allows users…Oriana L. 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Learn Report not able to access ActivitySummary: After we enabled redwood, our learning reports stopped working. upon checking, in offering hierarchy table "WLF_LI_HIERARCHIES_F" the type is coming as "ORA_CLA…
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 54 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,…Barile Alberto 262 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for HCM
-
what is the BICC VO for Position EFF?Summary: I am trying to find the PVO for extracting Position EFF data and it is not available in the datastores. I could find the Assignment and Job EFF but not Position…Veena Pindiganti 12 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Update DFF value using autocomplete rule on employment pageSummary: Hi everyone, we have a requirement to update the DFF value if any transaction happens on the assignment page. For example: Assignment DFF has dropdown values YE…Amit_Ekbote 31 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Ability to report out who joins talent community but does not apply to a job postingWe went live a few months ago with ORC, and in our setup we enabled the talent community and have it showing on the job search results page with a general application be…Rob Stahly 11 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
How to Reporting through OTBI answer to a scoring questionnaires in learningSummary: I'm not able to extract answers to a scoring questionnaires which has a subscriber "Learning assessment". The users access the questionnaires through a learning…Francesco Milazzo 34 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…
-
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
Table to get fixed accrual of an employeeSummary: We have a customer requirement to create custom report which displays the fixed accrual for a person and the accrual as of period. We are looking to get the fix…Dijo Maliakal-Oracle 84 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Absence update history not availableSummary: Currently when the employee update the existing absence record and submit it, the back end does not hold both the data on the absence entry table. Unfortunately…Sobitha Venkatraman 1 view 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Data isn't retrived due to special character in Business Unit promptSummary: Hey, We have an issue with our Performance dashboard. The dashboard is based on OTBI analysis reports and the Performance subject area. One of our BU was create…Markovich Chen 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify C-Suite leader in headcount reportI'm trying to add a column that will identify our C-Suite leaders for each employee in headcount report. C-Suite leader would be the CEO - 1 or whomever is the top-most …S. Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What is a variable formula that uses the standard working hours converting our analysis to days?Summary: What is the formula that we can use for our Absence Analysis that will use "standard hours" (which isn't always 8 for us, sometimes it's 24, sometimes 7.25 etc)…MissHeidiJ 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Report CalendarSummary: Hello Experts I have been tasked to develop a Calendar Report that looks like the attached as the screenshot system will be replaced soon. I am uncertain how at…