Category 81
Discussion List
-
Query to extract the last effective start date record for payroll elementSummary: Content (required): Hello experts, Please, could you share the SQL query to extract the effective start date loaded for a specific element in the employee compe…Valerio Curzi 485 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Interview Feedback OTBI report - questions not associated to questionnaire nameSummary: I am creating a simple OTBI report where I need to collect interview feedback responses for 1 type of interview feedback questionnaire. Content (required): I ha… -
Joining the Time Card Entry view hwm_tm_rpt_entry_v to wftask & wftaskhistory tablesSummary: I have a requirement to display the Rejected by,Rejected Comment & rejected date columns in my Time Card Status report. It is a BIP report. I am trying to join …Dharmendra Jha 329 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
How can we track the changes made in Performance Goals using OTBI?Summary: Hello, Does anyone know how to fetch all changes made in Performance Goals using OTBI? Your help is highly appreciated! Regards, Hazel Content (required): Versi…Hazel De Castro 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Setting Access Role to DashboardSummary: I am needing to add access to a Dashboard to a certain role, but the role I want isn't an option in the dropdown. Content (required): I have created a dashboard…Aaron Reynolds 64 views 2 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
OTBI Report to fetch all changes done for goalsSummary: Hello, Does anyone know how to fetch all changes done for goals? ex: change of description/goal name Regards, Hazel Content (required): Version (include the ver…Hazel De Castro 24 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
OTBI Report: Interaction note - Start Date ChangeSummary: We tried to create a report which includes the field Interaction note = Start Date Change, has anyone created one that works? Content (required): We tried to cr…Jessie Gee 53 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to show and hide BIP parameters dynamically based on the login UserSummary: How to show and hide BIP parameters dynamically based on the login User Content (required): We have different parameters and few parameters need to display base…Visu 547 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
OTBI Report - Width column for development goalsSummary: Hello, Does anyone know how to fetch width column for development goals? Content (required): Version (include the version you are using, if applicable): Code Sn…Hazel De Castro 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-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…
-
Oracle FAW usage tracking not showing custom dashboard under custom folderSummary: Oracle FAW usage tracking not showing custom dashboard under custom folder Content (required): Hi All, Oracle FAW usage tracking not showing custom dashboard da…RDWIV3 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI:I need to pull the carryover limit of persons enrolled in an absence planSummary: I need to pull the carryover limit of persons enrolled in an absence plan Content (required): I need to create a BI Publisher report that pulls the carryover li…Jose Lorenzo Amarado 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Best subject area for pulling "Worker"."Work Email" into OTBI?Summary: Current Subject Area Used: Workforce Management - Worker Assignment Real Time Columns: "Worker"."Work Email" OR "Worker"."Employee Email Address" Content (requi…William_Johnson 45 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Getting an error while running OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sidhartha Wadhwa 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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
-
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 293 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we restrict the creation of OTBI Report only the BI AdministratorSummary: Can we restrict the creation of OTBI Report only the BI Administrator Content (required): Currently any user with BI Author role can able to create the OTBI Rep…Harish Vummidi 82 views 5 comments 1 point Most recent by Harish Vummidi Reporting and Analytics for HCM -
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 44 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to create a single report for the following fields in OTBI Or OBIEE.Summary: can we able to create a single report with this fields in OTBI Or OBIEE. Education details ( highest one ), Previous Experience ( last worked ), probation statu…Jebarsan Thangam John Durai Raj 22 views 4 comments 0 points Most recent by Jebarsan Thangam John Durai Raj 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 33 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 145 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…
-
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Updating RTF for Element Register ReportSummary: There is an error on the Element Result Report that produces split lines for Person Number. I need to update the rtf to correct this. Content (required): When s… -
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 55 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…
-
Is there any way to fetch real updated absence records via BIP Report?Summary: - Content (required): Background: Absence Management Module We currently need to capture the real updated absence records, distinguish which records are newly c…
-
HowThere is aCansel Karasoy 42 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM