Category 81
Discussion List
-
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 86 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 35 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 45 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 3 views 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 64 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 thisEm-Jay 15 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 46 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 3K 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…
-
I want to restrict the values for prompt in OTBI reports.Summary: I had applied a prompt for customer contract name in OTBI report, it is fetching all the values present in that column but I need to fetch only those values tha…Yashdeep 33 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to change columns as rows in below requireimentSummary: Hi Team, In OTBI how change annual accrual and carry over coulmn into row we need . Any one help me on ? Content (required): Version (include the version you ar…AjayKumar Maddipati 83 views 20 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to change the date format in OTBI analysisSummary: I need to change the date format of OTBI analysis into mm/dd/yyyy format. I tried to do it using the column properties following below post. But it's showing 00…Ayesha Iroshani 1.2K views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…AjayKumar Maddipati 35 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Phase Sequence Number doesn't match CSPSummary: Phase Sequence Number doesn't align with the CSP we've defined. Content (required): We have defined candidate selection phases for our job application progressi…Rob F 23 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Dashboard ErrorSummary: Error Codes: OAMP2OPY:U9KP7Q94 Path not found - Check the input path entered. Content (required): When running the dashboard, error appears. This only happens t…
-
Report template issueSummary: We have created Welcome mailer template in XSL format and when tested in TEST and DEV2 environment, it is working absolutely fine. But when deployed in PROD - t…
-
Agent not sending report to application roleSummary: We have selected Application roles as the recipients for the scheduled agent, but the emails are not sending to anyone in these roles. However, If I list an ind…THawkins_LGI 24 views 2 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
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 36 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Tax Witholding ReportSummary: I need help creating a report showing which employees are claiming exemption from the tax witholdings. More specifically, which employees are claiming exempt. I…Greg Rank 42 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to compare Salary Minimum to Grade Rate MinimumSummary: I have an Analyses that uses Compensation - Salary Details Real Time and Workforce Management - Grade Rate Real Time subject areas. The requirement is to compar…JHaden3 13 views 3 comments 0 points Most recent by Gail Langendorf-Oracle 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 53 views 5 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
OTBI folder and column name Contract InfoSummary: Content (required): Hello, do you know in which folder or the column name in OTBI for the highlighted columns (Contract Info)? Kind Regards, Valerio Version (in…Valerio Curzi 53 views 8 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
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 535 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 362 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM