Global HR
Discussion List
-
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 31 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Manager not able to see the anything in reportHi Everyone, I have created 2 reports and deployed it for the Line managers to be able to run and self serve but when they run they cant see the results. Details of the …Girish Bhatia 31 views 3 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Last Standard Process date column in payroll reportHi There, Hope you are good! I m looking for creating report with last standard process date for terminated employees in order to run HSDL for final close for these term…Priya1 11 views 2 comments 0 points Most recent by Raju Sandepogu-Oracle Payroll and Global Payroll Interface (GPI) -
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How we can pull old assignments and old payroll name?I need logic for old assignments and payroll name, it will be appreciable if you will provide me any sample query. This is the Requirement Global Transfers processed in …Narmada Yadav 31 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
i want to join (PAY_PAYMENT_TYPES) tables with person details.wanted to fetch payment type and payment source highlighted in the below snapshot.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
Report related detailsSummary: Hello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report …Namrata_20 1 view 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Inbound Integration HCM Extract - Zero RecordsSummary: Hi All, I face a unique scenario where my HCM Extract may not always generate HDL Data records to be loaded to HCM Data Loader. Due to this, a blank .zip file g…VinayDama 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 31 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
dashboard parameter resetHello, I prepared a dashboard from a web service data model and this dashboard works with certain parameters. Dashboard consists of two tabs in total. When I select the …Sinem Kara 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
BIP Report Status DashboardSummary: BIP Report Status Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple flows wh…Parag Hiremath 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Bypass self-evaluation reporting in Performance ManagementSummary: Bypass self-evaluation reporting in Performance Management Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for…Parag Hiremath 21 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Duplicate Data Rows for EFF fields in Reporting (Data Issue?)Summary: Hello, We are noticing when we are building basic reports whenever we bring in Job or Department EFF fields in the criteria, we get duplicate rows for employees…CCannadayCTR 31 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM CloudSummary: Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud Content (required): Hi All, We got the requirement to extra…Venkatesan 2.2K views 3 comments 0 points Most recent by Navya Siddaling Reporting and Analytics for HCM
-
Vaishnavi Phulsay 61 views 4 comments 4 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
Adding approval history information to the reportHi, I designed a report that works the same as the standard notification with custom parameters. I would like to add the following field to the report, which comes in th… -
Create Row Number in HCM ExtractsSummary: I am using PAY_EXT_USER_TABLE_COLS_UE to join the PAY_EXT_USER_TABLE_ROWS_UE on col.row_number = row.display_sequence Is there a way to create this function in …
-
Fetch Employees not a part of Talent Profile SectionSummary: We have created a Custom Section using the Skill Template under the Talent Profile Page. As followed fields HPI.ATTRIBUTE1 AS TRAINING_NAME, HPI.ATTRIBUTE2 AS B…YASHWANTH GOWDA H R 1 view 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need PVO for Workforce Management-Work Relationship Real Time.Work Relationship Details.Provider idNeed PVO name for the column 'Provider id' 1.Column name: Provider ID Subject Area: Workforce Management - Work Relationship Real Time Folder name-->Column: Work Relatio…Divya Penmetsa-Oracle 21 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle HCM Extract
-
Add 'Attribute1' column from the PER_PERIODS_OF_SERVICE table into the dependent PVOHi Team, Could you please help How to add the 'Attribute1' column from the PER_PERIODS_OF_SERVICE table into the dependent PVO "HcmTopModelAnalyticsGlobalAM.AssignmentAM…Divya Penmetsa-Oracle 11 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle HCM Extract
-
can we add filters for checklists tasks also in hcm extractswe wan to create DOR if the termination/resigantion checlists tasks are completed. Can we add filters for those also in HCM extracts. which bussiness object we need sele…
-
Best approach to implement security in worker hcm extractSummary: We are developing a Worker HCM extract to pull worker demographic information in changes only mode. There should be options to run this extract by client from l…
-
Created a Changes Only extract– contains historical data on Assignment detailsSummary: Hi Teams, Need to get history data from assignment using HCM extract, Root UE: GLOBAL_PAYROLL_INTERFACE_TERMS_UE Childs 1: PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE Ch…
-
Due Date dashboard prompt in OTBI gives precision_scale errorSummary: OTBI Learning Dashboard prompt for Due Date set to between gives a precision_scale error across all analytics Content (please ensure you mask any confidential i…Kevin Robertson 12 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
can we perform any arithmetic operation like sysdate - 20 in alert 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…Pooja Ghosh 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to export HCM Audit Reports in OTBI?We couldn't find where to export seeded Audit Reports. Does anyone one how can we access?Serap Aktaş 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM