Global HR
Discussion List
-
23B - HCM Extracts - New Feature Impact Analysis - REDUCED RETENTION PERIOD FOR DATA ARCHIVESSummary: With 23B, there is a new enhancement for HCM Extracts. REDUCED RETENTION PERIOD FOR DATA ARCHIVES. The statement reads: With the retention period reduced from 9… -
OTBI Personal Payment method DetailSummary: I need Employee's Personal Payment method Details like IBAN and bank account info. My client wants to add these fields to the existing OTBI report. Currently, I…Saher 441 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How should I write multiple data returned from a column separated by commas next to each other?Hi, I actually have a pretty simple little query. More than one data is returning from this column and I want to write it on the same line separated by commas. SELECT YY…Cansel Karasoy 41 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…User_2025-01-25-04-02-13-126 389 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
BI Publisher security on expatriatesSummary: BI Publisher using secured view shows records outside scope of user's AOR who is running the report Content (required): Hello, We have a BI Publisher report on …
-
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…ShawShankk 61 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Date of Birth less than 16 yearsSummary: Employees with Date of Birth less than 16 years. Content (required): I need to create a list of employees with a Date of Birth recorded that would make their ag…
-
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl…ShawShankk 102 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull rehire date in OTBI REPORT?Hi Team, How to pull rehire date in OTBI REPORT? ThanksSM_EP 211 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to find deeplink for Allocate Checklist page?Summary: How to find deeplink for Allocate Checklist page? Content (required): Hi All, How to find deep link for Allocate Checklist Page? From Tools -> deep links , i go…
-
Logic on Audit bit map field in per_all_Assignments_m_ tableSummary: We are working on an audit requirement to track the insert, update and delete assignment records over a given period of time. We have enabled the audit for prod…User_2025-10-31-01-02-51-214 161 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How cHi, I want to write a query that reCansel Karasoy 41 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…Visu 471 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Primary or Null Address TypeSummary: Hi - I am working on creating a report of all active employees and contingent workers in our system along with information from Worker Assignment Real Time and …Kyle Norris 41 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Allowance and Deduction HCM ExtractSummary: Hi Folks, Our Client has integration between Oracle HCM and Preceda Payroll. We need to send the element entry details to Preceda if a new element is added and … -
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 51 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM
-
How do you bring back the last calendar date of the next two monthsSummary: Hi I've been asked to create a report where I list leavers in the next two months and I managed to find a report that shows leavers in the previous month to twe…
-
Alert Composer| Resource Alert| Time Stamp FormatSummary: Hi all, I have developed a resource alert where the requirement is to have only time in the format of HH:mm. By default the syntax is date along with timestamp.…
-
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
How to hide Mark as read and Mark as unread links based on condition in workflow notificationSummary: How to hide Mark as read and Mark as unread links based on condition in workflow notification(Checklist task) Content (required): Hi All, We got a requirement t…
-
Can a single field be encrypted in an HCM extract file?Summary: Recommended approach for encrypting a single field in HCM Extract Content (required): Per SR, am posting this to Customer Connect: Our client is in the middle o…
-
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my …Cansel Karasoy 51 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?Cansel Karasoy 754 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Table Details that stores all information about a Custom Quick ActionHi All, Please help know the table name that stores Quick Actions ,Eg: If there is a custom Quick Action created like "Colleague Details" under Me TAB,want to know when …C.R.Balaji 81 views 8 comments 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM -
How can I run the report when I select the required parameter field 'ALL'?Hi, I have 1 parameter that is mandatory in the report I prepared, assignment status, you can see it in the screenshot. It is true that the report should not be opened w…Cansel Karasoy 61 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins…Tammy Hemmingson 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM