Category 81
Discussion List
-
Annual Leave Buy / Sell - ReportSummary: A Report to identify those Employees who Bought / Sold Annual Leaves Content (required): Hi, Can you please help me to develop a report which will give details … -
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to …Maria Xydopoulou 61 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mass closure of pending HCM workflow transactions (approval transactions)Summary: Mass closure of pending HCM workflow transactions (approval transactions) Content (required): Hi Team, Greetings! Is there a way to perform Mass closure of pend…Parag Hiremath 52 views 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Backend Table which stores Application Task name from Checklist TasksSummary: Need the Backend Table which stores the Name of Application Task from Checklist Tasks Page. Content (required): The Application Task code is present in the Tabl… -
Properties Attribute "Read Only" - what does it do?Summary: Properties dialog box -> Attributes section -> Read Only Content (required): Hi All, If I adjust the attributes section to "read only" in the properties dialog …William_Johnson 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there a way to join these 2 subject areas?Summary: Is there a way to join these 2 subject areas: Human Capital Management – Approval Notification and Archive Real Time & Workforce Management – Person Real Time. …
-
Is there a standard report for Balance Adjustments?Summary: Specifically, we are looking for a way to report on failed Balance Adjustments. At year end, we frequently mass load Balance Adjustments. And always a few fail …
-
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc…MilanMohanty 81 views 9 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…Ketan Prajapati 381 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…Jezreel Furagganan 61 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM
-
1How to upload BICC extract files to UCM custom foldersSummary: We have a requirement to upload BICC extracts to UCM custom folder. By default, the files are getting uploaded to OBIAImport security group. Please help us in s…Deekshit Yerra 71 views 1 comment 1 point Most recent by Alok K Gupta Reporting and Analytics for HCM
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y…Valerio Curzi 122 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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… -
Unable to create a new Application Page Entry for a BI ReportSummary: Unable to create a new Application Page Entry for a BI Report Content (required): We are trying to create a page entry to open a BI Report. Used the Application…Bhargava Varma G 51 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Table name which stores start date and end date in individual compensation planSummary: Hi Everyone! I am looking for the table name which stores start date and end date in the individual compensation plan. I tried - cmp_plans_vl, cmp_components_vl…
-
Seeing Data Across Different EnvironmentsSummary: Viewing data across different environments inconsistent. Content (required): When I run a report, we created in Dev11, there some data that I don't see in our U… -
How to get Home email and business email addresses in OTBI reportingSummary: How to get Home email and business email addresses in OTBI reporting? Content (required): We are trying to get employees home email and business email addresses…Abhishek Jois 518 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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
-
Transaction Detail - TerminationSummary: Terminations used to pick up in our transaction detail report but it seem to had stopped working from 22D. Content (required): Is there another way to create a …Ratha Sun 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle 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 -
How to sort by timestamp in BIP TemplateSummary: Is it possible to sort all the four tiles (Initiated By, Assigned To, Approved By and FYI) by timestamp? Attached is the screenshot (Workflow transaction detail…Angelica Tayactac 1 view 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ…
-
Any Suggestions of how to improve Web Clock Custom Dashboard data reflection earlier.Summary: We are facing a time-lapse on Custom Dashboard which has reflected the data in delay some time especially in web clock in and out table records. we need a worka…
-
Show timestamp in human readable format while respecting time zoneSummary: Display the date and time from the last_connect column in the fnd_sessions table in a human readable format. The time should also respect British Summer Time / …
-
OTBI:Market Data: No data in report when columns from Global HR dimensions are usedSummary: Guidance to ensure that Market Data reports return data when Global HR dimensions are used. Content (required): 1- Subject Area: "Compensation - Market Data Rea…Abhishek Dixit-Oracle 61 views 3 comments 1 point Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
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 to know Progress Summary Reason Table/Subject area nameSummary: Need to know Progress Summary Reason Table/Subject area name Content (required): We are unable to find Progress Summary Reason field either in the Recruiting - …Visu 41 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… -
SQL query to see the dependents for an employee who have pending action items in benefitsHi Experts, Can anyone please share an SQL that can show me the list of all dependents for an employee who have a pending action in the benefit plans? Say for a dependen…Aloka Bhattacharya 2.8K views 3 comments 1 point Most recent by SachinP21 Reporting and Analytics for HCM -
Infolet Report Failing / Erroring with Direct and Indirect Reporting LineHi all, I'm hoping someone can tell me if what I'm trying to achieve here is possible. The report itself should look at anyone who has learning that's due and then apply…