Reports
Discussion List
-
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 1 view 2 comments 1 point Most recent by Venkat Vatikuti Reporting and Analytics for HCM -
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…
-
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…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.3K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c… -
How can I retrieve the full details of each exception?Hi everyone, I’m working on a report that returns schedule exceptions using the following query: SELECT 1 KEY, pse.SCHEDULE_EXCEPTION_ID, pse.SCHEDULE_ID, pse.SCHEDULE_A…Andriampeno Odilon 31 views 4 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 56 views 3 comments 1 point Most recent by R Ravichandran Reporting and Analytics for HCM
-
Headerless csv output in oracle fusion BI reportingSummary: Hi Team, We have a requirement to get the extract in CSV format without header fields in the Oracle BI report. Content (please ensure you mask any confidential …
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" SA - unexpected behaviour on filtersSummary: Hello, I have following OTBI analysis : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Performance - Performance Check-In …
-
Required table to get Ad Hoc resource name in activities under OfferingsSummary: Hi All, We need a table to get Adhoc Resource name, quantity and description in activities under Offerings in fusion HCM Content (please ensure you mask any con…
-
Insufficient Privileges FA_FUSION_SOAINFRA.WFUserVacationSummary: Getting Insufficient Privileges Error when running below query SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation SELECT * FROM FA_FUSION_SOAINFRA.WFUserVacation I…Fazil_Shahid_Khan 51 views 6 comments 0 points Most recent by Fazil_Shahid_Khan Reporting and Analytics for HCM
-
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…
-
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo…
-
Manage Geography Hierarchies REST API throwing 401 errorSummary: Hi I am getting an 401Unauthorized error while testing the Manage Geography Hierarchies REST API in postman with valid credentials. API : /hcmRestApi/resources/…
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance. -
How to fetch data from transaction console table for ICP entry which is not approved ?We are trying to fetch details of ICPs which are in submitted status(not yet approved).The details which we are trying fetch is person details, ICP type, option , date w…
-
Reporting Field for Acknowledgement Comments on Performance ReviewSummary We would like to know the field name (if reportable) for the comments entered by an employee when acknowledging their performance review.Content We have a busine…User_2025-01-30-23-46-38-098 76 views 6 comments 1 point Most recent by Aprajita Gokhale Reporting and Analytics for HCM -
Is it possible to download personal surveys created in Oracle HCM?Summary: After creating surveys using the Create-Survey quick action in Oracle HCM, I need to download them, displaying the following data:1) Assignee Name2) Survey Name…LorellaUccello 31 views 0 comments 0 points Started by LorellaUccello Reporting and Analytics for HCM
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
Can we use invalid custom 'From email address' for BI Report Notification?Hi Everyone, We are trying to personalize 'Email From Address' for BI Reporting Delivery. We have changed 'Email From Address' by navigating to /xmlpserver → Administrat…
-
I am trying to get te work schedules of the inactive employees via analysis reportSummary: Work Schedules - if employees are inactive, their work schedules are missing from the analysis Content (please ensure you mask any confidential information): We…Claudia Linares L 41 views 4 comments 0 points Most recent by David Vaughan-Watkins Reporting and Analytics for HCM -
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu… -
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO…Dhilip Kumar P. 33 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM