Category 81
Discussion List
-
OTBI report Fetching both Active and Inactive Records when select only Assignment status as ActiveOTBI report Fetching both Active and Inactive Records when select only Assignment status type as Active from Subject Areas : "Workforce Management - Worker Assignment Re…ROHIT NAYAK_120 3 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the report history in the front en, but I'm unable to find related rec…
-
Need a sample query of Team Time Card page, to fetch Reported hours of Calculation Time.Summary: Query to fetch Reported Hours in Calculated time section of Approved Time cards for an individual. Content (please ensure you mask any confidential information)…Sujeeth Chinta 440 views 2 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
What is the best way to stop Retro processing on an elementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ted Wayne County Consultant 65 views 1 comment 0 points Most recent by Kaustav_Ray-Oracle Payroll and Global Payroll Interface (GPI)
-
How to use nvl function in excel templateSummary: Using NVL function in excel template for Extracts Content (please ensure you mask any confidential information): Hi All - We have a requirement to fetch the req…
-
Table which stores the goal commentHi Team, I am working on BIP report to get the Goal details, I am using below tables for the report. HRG_GOALS HG HRG_GOAL_PLAN_GOALS HGPG HRG_GOAL_PLANS_VL HGPL HRT_REV…Saurabh_Mharolkar 16 views 2 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
Report on SkillsSummary: Report on Skills Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard or shared reports about Dy…Oriana L. 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to update Candidate Name and address using HDL?Hi Team, I am trying to update Candidate Name and Address using HDL, but getting below error. Please let me know which date we need to pass while updating Candidate Name…Saurabh_Mharolkar 93 views 2 comments 0 points Most recent by Juan Carlo Culibra-Oracle HCM Data Loader (HDL)
-
Each sheet of a BIP report extraction is extracted to a different Excel fileSummary: Each sheet of a BIP report extraction is extracted to a different Excel file Content (please ensure you mask any confidential information): Hi Each sheet in the…
-
How to maintain the number format when a BIP report is exported to ExcelSummary: Maintain the number format when a BIP report is exported to Excel Content (please ensure you mask any confidential information): Hi When a BIP report is extract…
-
Can customers report on Signer's IP Address for electronically signed documents within Oracle HCM?Summary: We have a need to report on all of the various components of electronically signed documents/forms within Oracle HCM Onboarding Journeys. These data items shoul…Marnetta Griffin 13 views 1 comment 1 point Most recent by Claudiu Postolache-Support-Oracle Journeys
-
Can I make an Academic Year 'Time' dimension in OTBI?Asking for a colleague Hi all, I need to show workforce trends over time by Academic Year e.g. 2023/24 = 1 September 2023-31 August 2024. I have successfully made time s…Mark Stoker 12 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
Person Legislative Information Field Teacher Reference Number no longer showing dataSummary: After 24c was implemented on our Production environment we noticed that one of the fields in the subject area was no longer producing any data. The field in que…Mark Stoker 74 views 18 comments 0 points Most recent by Rebecca Hawker Reporting and Analytics for HCM
-
Areas of Responsibility - No Results when including Worker DataSummary: No Results is being returned when including any Worker data into an analysis for Areas of Responsibiltiy Content (required): We are creating an analysis using t…David Bean-259734 437 views 14 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Performance Manager Not Appearing in AnalysisSummary: We are trying to create a report for our Performance Reviews that is able to show us an individuals Performance Review Status, Score, and other details. As part…Brent_Beardsley 11 views 2 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM -
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
Download PDF DashboardsSummary: Download PDF Dashboards Content (please ensure you mask any confidential information): Hello experts, we would like to download a dashboard as pdf but it seems …
-
Show Only Maximum Current Year Enrollment Coverage Start DateSummary: I have an OTBI Benefits report that should show only current year max enrollment coverage start date . The Enrollment Coverage Start Date field has the below co…JHaden3 32 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Date Format not convertedSummary: I am trying to get date in the format of 'Monday, 1st of January, 2020' using the query below in data model: select TO_CHAR(SYSDATE, 'Day, DDth "of" Month, YYYY…
-
Where can I update the below highlighted text under Navigator --> Me --> Benefits?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Shilpa Varghese 11 views 2 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
Create an Effective Date Parameter for OTBI ReportSummary: Hi. I am sorry if this question has been asked before. I am looking to add a Effective Date Parameter to an OTBI report so when the user goes to run the report,…Jose Guerra 2K views 20 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get Payroll costing details to match with EFT paymentsSummary: Need query to fetch the Costing of payments - Accounts, Account Type, Cost amount (Debit & Credit), Accounting date and prepayment details. It needs to be match…Priyabrata Prusty 624 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
I Combined two subject areas but two records coming with active status but only one activeSummary: Hi Team, We have Combined two Subject Areas but assignemnt status showing as active with two records both are active but diffrence is one is with termination da…AjayKumar Maddipati 41 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display the output of a BIP Report in multiple excel sheetsSummary: How to display the output of a BIP Report in multiple excel sheets Content (please ensure you mask any confidential information): Hi, we created a BIP Report, w…Barile Alberto 305 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Do we have feasibility to get the employees without performance document attached in OTBI report?Summary: Do we have feasibility to get the employees without performance document attached in OTBI report? This should be work based on Prompt basis like review period, …
-
Oracle cloud HCM sql queries to fetch details of employees who left the organization(ex-employee)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Srujana Reddy 47 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BU prompt in OTBI report isn't working. Whatever BU is selected, data is being returned for all BUsSummary: I have created a report with both a graph and a pivot table designed to return a count of faculty members with different attributes. I need these counts to be b…David Pearson 11 views 2 comments 0 points Most recent by David Pearson Reporting and Analytics for HCM
-
Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWVSummary: Exceeded Configured Maximum Number Of Allowed Output Prompts- error code WVIMVZWV Content (required): Exceeded Configured Maximum Number Of Allowed Output Promp…Swati U 478 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM