Category 81
Discussion List
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi… -
Line Manager Dashboard Reports for PerformanceSummary: The Delivered Line Manager Dashboard Report has lot of Tabs and For few tabs i am able to find the Analysis Report. For Performance I am able to see the Below D…kanchana venkatasubramanian 33 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
Cumulative Salary ReportSummary: Financial report of cumulative salaries per reporting period Content (please ensure you mask any confidential information): Hi experts I have a request to provi… -
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…Herman Fersendy 22 views 0 comments 0 points Started by Herman Fersendy Reporting and Analytics for HCM
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 11 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report on Extract Definitions / Object Name / AttributesHello, I would like to create a report (Bi Publisher or OTBI). About Extract Definitions. I need following information Extract Definition Name Object Name Attributes Exc…Michael Schweizer 11 views 1 comment 0 points Most recent by Stephane Cote-Oracle Reporting and Analytics for HCM -
Run bip reports via payroll flow or ess jobsSummary: We are planning to create BIP reports, which will run in changes only mode. As a best practise should we be running the report leveraging the last run ESS job o…
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 421 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI report available for employeesSummary: OTBI report available for employees Content (please ensure you mask any confidential information): Hello, we have configured a guided journey which is visible i… -
What is the column for enrollment date in the WLF_LEARNING_ITEMS_F table?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…ClaudiaManea 11 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Multiple legal employers records showing in each employeeSummary: Hi Team, we have BI query but it Multiple legal employers records showing in each employee. example one employee have x legal employer but it also showing secon…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 92 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
PER-1530729 POSITION UPDATESummary: ERROR (PER-1530729) POSITION UPDATE The next error that generates the position 203542 when trying to update any of the fields. Also, please indicate that the Pr…rrojasf 11 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to restrict to get one level of indirect employee data of manager?We want to get the data only for Indirect employee of the Senior Manager? but we are getting Indirect employees reportees data also. In query we have used PER_ASSIGNMENT…YAMINI DANTOORI 11 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Can we track Candidates who agree to Terms and Conditions on the Career site?We are trying to find out if it's possible to track candidates who agree to the terms and conditions when applying through our career site. Candidates are given the opti…Niveditha 21 views 1 comment 0 points Most recent by Ramya Pabba-Oracle Reporting and Analytics for HCM
-
OTBI bursting via agent for high volume email notifications inconsistent / sporadicSummary: Classic use case: Managers are receiving emails regarding outstanding actions. Of the 1132 expected emails, 1014 succeed. 118 emails still successfully send, bu…
-
List of all Custom ReportsSummary: Can we get a list of all reports (Custom + Standard) using a query? Also, users who are all having access to these reports? Content (required): Version (include…
-
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …Anup Karmankar 265 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Data Security Policy is not working for the custom role which has Purchase Analysis role addedSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 41 views 5 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for HCM -
Common Question: I didn't get any rows in the subject area, what's wrong?Typical Symptoms: you selected columns and didn't see any results, or once you added certain column/s, then you didn't see any results. Content: Q: "I didn't get any row…Gail Langendorf-Oracle 396 views 6 comments 4 points Most recent by Saina Reporting and Analytics for HCM -
How to get legal employer legislation code with SQLSummary: How to get the legal employer legislation code with SQL Content (please ensure you mask any confidential information): Hi experts, I need to get the legal emplo…Volodymyr Faranosov 65 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to identify the employees who didn't receive Outlook invites after a course is assigned?Summary: Hi, Is there a query to identify the recipients of Outlook invites after a course is assigned? we have a situation where some individuals received the invites w…
-
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi @everyone We need your help to get below requirement: in case we do personalization through transaction design studio, we can unhide a section in the page wh…
-
Can we change the View Profile link to navigate to Skills Center in the ProfileChangeNotification?Hi All, We have a requirement to open the link of the 'View Profile' option button from Connections to the Employee Skills Center page in the ProfileChangeNotification W…
-
Finding Business Owner of Dynamic GroupsI am reaching out to inquire whether anyone has knowledge on how to find the report owners for Dynamic Groups within oracle system. Specifically, I am interested in unde…Demetrius Davis Jr 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can I report on whether learners have uploaded a file into their learning assignment?Summary: I'm trying to create a report that shows me which learners have uploaded a file into their learning assignment for a particular course. In their enrolment the l…Kathy F. 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
User Role Membership Report SQL Query / TablesSummary: Hi Team, for audit purposes customer is requesting to know which tables/views at db level are being used to extract the seeded report "User Role Membership Repo…dgodard22 1.8K views 16 comments 1 point Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…Anup Karmankar 13 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM