Global HR
Discussion List
-
Why OTBI Analysis not giving correct manager details in output ?Summary: OTBI analysis not giving correct output in one environment but working on other environment Subject Area : Workforce Management - Worker Assignment Real Time Co… -
COUNT IF in a columnSummary: Replicate the COUNT IF condition in a column Content (required): Hi All, I need to replicate this KPI in a column of analysis: In details, I don't find the corr…Andrea Rubino 82 views 2 comments 0 points Most recent by Andrea Rubino Reporting and Analytics for HCM -
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat…Cansel Karasoy 42 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Open/filled position management reportingSummary Delivered Position Incumbents report returns terminated employeesContent Hello - There's a requirement to create a report of all current filled/open positions wi…
-
Combining fields into one field or cell in OTBIIs it possible to combine all the columns and rows (per person) under Question Text, Response Answer and Response Text in one field? From this To thisJoycieee 11 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
In BI Report we getting dupilcate records as per ui but we need only one recordSummary: HI Team, We have exist interview survey status report but we getting dupliacte reocrds nearly 700plus. due to report takes as per ui but in ui some of employees…AjayKumar Maddipati 32 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to migrate BPM workflow notification customization to another instance?Summary: How to migrate BPM workflow notification customization to another instance? Content (required): Hi All, I have customized the BPM termination approval email not…Venkatesan 51 views 5 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
How to take Department head and Business Leader information from AOR?Summary: How to take Department head and Business Leader information from AOR? Content (required): Hi All, From which tables we can get Dept head and Business leader inf…
-
How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific dateSummary: Hi Community! Hope to find you well. Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective em…Luca9797 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Leavers within last three monthsHi, Can someone help me with query to get the list of leavers within the last three months ThanksMohammed Rafi 31 views 3 comments 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
DOR approval report gives cartesian product/wrong dataSummary: I am trying to fetch approver details of pending/approved document of records entries made by employee using attached query but it is always giving me the carte…
-
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 146 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit…
-
How to Display DFF Attribute Date value to the Alert TemplateSummary: We have document of record DFF where the value is stored in table HR_DOCUMENTS_OF_RECORD column DEI_ATTRIBUTE_DATE2 , and we dont know how to display this value…
-
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 53 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Work Schedule Report - Getting Hours On DateSummary: As per the screenshot attached. We have a requirement to fetch the Hours On Date. Example. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-7 (Ne…
-
HowThere is aCansel Karasoy 41 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
Tree Name Criteria Dropping out International & Non-EmployeesSummary: Hi - I am creating a report with a number of different fields pulling from the following subject areas: When I have all of my criteria EXCEPT for the tree name,…Kyle Norris 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way in OTBI not BIP to combine a "Security" with a "Workforce Management" Subject AreaSummary: Trying to combine Security Subject Area to a WFM Subject Area so we can see role on a user and which department they are in Content (required): There is an inte… -
Termination Date for ManagersSummary: We are looking to create a report with employees with a manager who has a future termination date. How would I include the managers termination date? Content (r…Jo Black 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 431 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 375 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 52 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 91 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 201 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…