Category 81
Discussion List
-
Need formula for anniversary date on 1st of month instead of day of hireSummary: I need to calculate anniversary dates so that they are the first day of the month they fall in instead of the annual hire date. I have got it partway there but … -
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run …MandeepGupta 51 views 6 comments 1 point Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM -
Parent manager 2 job tileFrom the Worker Assignment Real Time Subject Area I could get the Parent Manager 2 Name. How do I get the Parent Manager 2 Job Title ?Trupti Khodke 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
DOJ from date and to date , DOE from date and to date parameter not working in BIP reportHello , I have create Date of Joining date parameter and Date of Exit parameter, however when user try to select dates and filter records , records are not getting filte…
-
How to build a repot to get all action changes on the EMP recordI am using Worker Assignment Event real time subject area, to pull all the actions that happened on the employee record. When I add action and action reason I noticed th…Trupti Khodke 73 views 14 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
How do I add the last absence end date from the last 5 occurrences?Summary: I need to report on the last absence end date on the attached report. It is currently filtered by rolling last 52 weeks and number of absences measure of 5. Is …Mark Stoker 31 views 1 comment 0 points Most recent by Fechete Iustin - Support -Oracle Reporting and Analytics for HCM -
Report detailsHi, There are lot of reports we are using and we want to know security of each report. Is there any way to find out below details from system 1)List of reports 2)Roles/p…Namrata_20 21 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 21 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
In OTBI - the Position Name by Position Code is not historical - is this correct behaviour?Summary: The Position Name Field in the Position Folder in both the Compensation - Salary History Details Real Time and Workforce Management - Worker Assignment Event Re…Robert Craske 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to get when candidate moved to next step or status - BI TaleoSummary: I have a report request to show list of submissions indicating submission date and date moved to next step or status. This data extract shall show the submissio…SAMSONODU 21 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Promotion and Demotions Report not pulling the intended dataSummary: Promotion filter pulls in Job change code change data as well which creates duplicates when actually there was only one promotion. Content (please ensure you ma…Usif Ahmed 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM -
Certain Term'd EEs not displaying in Transaction Accuracy Audit ReportSummary: Using the Transaction Accuracy Audit Report from the Powered Reports and Analytics/Human Capital Management/Workforce Administration folder in the Reporting Cat…CGardner01 1 view 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to use an SQL query to select records of elements whose value was changed by CORRECT?Hello everyone, How to retrieve with an SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS ta…Alex_Balanovsky 72 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Get Roles and Data Access assigned to employees for BIP report in Oracle HCMWhere do I find these fields - Data Access Permissions, Data Access Permissions Start date, Data Access Permission End date, System information in HCM Cloud tables? Can …
-
How to Disable/Remove/Hide Inline Attachments in Attachments Category in HR Help DeskSummary: Hello All, We are trying to Disable/Remove/Hide the Inline Attachments in Attachments Category in HR Help Desk SR Request Page. We have checked below Profile Op…
-
How to get Collective Agreement detail from Workforce Management - Worker Assignment Event Real TimeSummary: Before 24A we were able to get the Union member and bargaining unit on our analysis from collective agreements folder of Workforce Management - Worker Assignmen…
-
debugging an errorSummary: debugging an error Content (please ensure you mask any confidential information): Hello everyone, I am getting this error when running a report in PROD but not …
-
Absence Calendar page to add Absence BalancesSummary: Hello, Please assist on the following… I am using the Line Manager dashboard → Absence Calendar page → Workforce Management - Absence Calendar Details Real Time…
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…Seema Kalantri 21 views 3 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM
-
OTBI Report: Worker Number nullSummary: In a custom OTBI report, starting from this month, suddenly the Worker Number, from "Workforce Management - Work Relationship Real Time"."Work Relationship Deta…Gian Luca Triglia 14 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sample query required to get all the benefit certificates in pending actionSummary: Looking for the sample query to get the pending action certificates in HCM benefits . Content (please ensure you mask any confidential information): Version (in…
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h… -
Worker Termination Alert fetching all termination dates (Older ones also)Summary: Hello Everyone, We have developed an alert using alert composer for triggering notifications when termination transaction occurs. But the issue is, we are getti…Dinesh Bodagala 111 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Person Identifiers for External ApplicationsSummary: For some employees we have updated payroll id under Person Identifiers for External Applications in person management. Content (required): If I need to take tha…Ayesha Iroshani 544 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to distinguish the output file basing on the scheduling dateSummary: How to distinguish the output file basing on the scheduling date Content (please ensure you mask any confidential information): Hi, we created a BI report; the …
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…Charan Kollipara 670 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Is it possible to present the data from first table as shown in second table using BI Report?Summary: This is the sample data we have and need to present as shown n Table 2 ****_ID ACTION_CODE REASON_CODE PERSON_ID EMP_TYPE ****_SEQ EFF_DATE PRIMARY_FLAG STATUS …Amit Mundlye-27103 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM