Category 81
Discussion List
-
Oracle Recruiting Internal and External Selected Canidates - OTBI ReportSummary: We have requirement to show selected internal and external candidates in an OTBI report. Please advise. Please provide a sample report. Content (please ensure y…MadhuLekkala 44 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
SQL Query Timeout is greyed outSummary: SQL Query Timeout is greyed out. I have logged into xmlpserver but is still unable to change the SQL Query Timeout. Is this field no longer updatable? Content (…Consultant Ian 103 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 34 views 5 comments 0 points Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM
-
Multiple assignment abseSummary: Hi, I am trying to create a report for absences that are assigned at assignment level. As you can see from the image attached the moment a column is added from …
-
Unable to view job history of custom reports in Oracle FusionSummary: I have BI Author, BI Consumber, and BI Administrator Roles assigned to my profile. I'm trying to view Report Job History for a Customized version of the Receipt… -
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
Hide Diagram tab in Data Model for the BIP report for users with particular fusion HCM roleSummary: Hide 'Diagram' tab in the Data model for users with particular fusion HCM role Content (please ensure you mask any confidential information): There is a require…Girish_Kulkarni_123 13 views 2 comments 0 points Most recent by Girish_Kulkarni_123 Reporting and Analytics for HCM
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 133 views 20 comments 1 point Most recent by Kyle Norris Reporting and Analytics for HCM
-
Milestone date showing as Hire Date in Long service Employees Report ?Summary: Hi Team We have long service employees report on who completed the 5, 10, 15 years like and we applied filter on as below. TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker".…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Agent to send to HR Business Partner via Username in the agent not sendingSummary: I am setting up a new agent to send via email to users. it is being created by conditional analysis. Get Recipients from the Analysis Used in the Agent Conditio…
-
move to HR then the candidate will automatically be a part of auto convert process of employee.Summary:Is there any option in recruting cloud that when recruiter moving a candidate to move to HR then the candidate will automatically be a part of auto convert proce…swarup ghosh 15 views 2 comments 0 points Most recent by swarup ghosh Recruiting, Opportunity Marketplace -
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,…AjayKumar Maddipati 70 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Modified payslip Data model bursting is not workingSummary: We are trying to achieve the requirement to send payslip for ex-employees over personal email address, Below is the custom bursting data model that we modified.…Rama123-Oracle 5 views 1 comment 0 points Most recent by Faithe Chu-Oracle Reporting and Analytics for HCM
-
Combing Two Rows into One Based on Person Numberhttps://us.v-cdn.net/6034893/uploads/GBYJEUBQX1Z5/us-audit-report.txt Hello everyone, We're working on the earnings report and there are some employees have two assignme…Yiming Xiong 22 views 10 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
SQL for Payroll Element Calculation FactorsSummary: Hi all, does anyone have any SQL that extracts element calculation factors? Element Name, Calculation Step, Calculation Value Definition, Range Values etc… Than…Jon Taylor 85 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
Can we delete an assignment from oracle fusion?Summary: Example : Lets assume E000001, E000001-2, E000001-3 assignments are present in the system with same legal employer. Can we delete E000001-3 completely from orac…Sanju Jana 24 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to add attachment to bursting?Summary: How to add attachment to bursting? Content (please ensure you mask any confidential information): I need to add a zip file to an email sent via bursting. Where …Stefano_Mazzocca 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 32 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Rcount sort orderSummary: I need to know what controls the sort order for the RCount function. I have a requirement to select one assignment per person from worker assignment real time S…
-
Issue while adding prompts to a pivot view of an OTBISummary: Not able to add and apply prompts to pivot view of an OTBI analysis Content (please ensure you mask any confidential information): The requirement I have is to …Vibha Pandey - Oracle 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Unable to acheive trend analysis using prompt for accounting year in OTBISummary: Unable to use Time series formulae in OTBI to fetch YTD data for past 5 years/ for 5 years based on prompt Content (please ensure you mask any confidential info…Madhuri Kovuri 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…DebayanB 53 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Job Offer Letter Template LimitSummary: Content (please ensure you mask any confidential information): Hello, My TA team was curious if there is a limit on the total number of Job Offer Letter Templat… -
How can I combine termination count and hire count in one analysisSummary: I have attached two different analysis One is showing hire count and other termination count But the requirement is that I need to have both the columns in the …Shreya Datir 32 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
We are looking for options to connect to the HCM database from external application eg. ExcelSummary: We are looking for options to connect to the HCM database to pull employee and org data to simplify some of the processes for our HR. Content (please ensure you…Vijayalakshmi_H 21 views 3 comments 0 points Most recent by Alex D-Oracle Reporting and Analytics for HCM
-
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD…Aishwarya_15 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM