Category 81
Discussion List
-
Regarding W2 Allocated TipsSummary: Hi Team, We have configured Allocated Imputed earnings element and mapped allocated tips results element at balance feeds and created balance group required rel…User_HN2QF 6 views 0 comments 0 points Started by User_HN2QF Payroll and Global Payroll Interface (GPI) -
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 731 views 8 comments 0 points Most recent by Hemanth Kumar Reddy Reporting and Analytics for HCM -
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…Rohit Kumar Singh 468 views 9 comments 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
Job Change Report - Assistance Adding Two new AttributesSummary: I have a Job Change Report but I am having trouble adding columns to looking for changes in The Full-Time/Part-Time Status and the Salaried/Hourly status. Any i…Darrin N 14 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch average cycle time for each compensation planSummary: write a sql query to fetch average cycle time for each compensation plan Content (please ensure you mask any confidential information): write a sql query to fet…Pritha 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch average percentage of budget utilizationSummary: write a sql query to fetch average percentage of budget utilization Content (please ensure you mask any confidential information): write a sql query to fetch av…Pritha 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 478 views 2 comments 0 points Most recent by Domenico P. Reporting and Analytics for HCM
-
BI Catalog change audit dataSummary: Is there a way to audit the changes done on BI catalogs in Oracle Fusion Cloud? Content (please ensure you mask any confidential information): Version (include …AnuradhaMupdathi 7 views 1 comment 1 point Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
Assistance Required: How to obtain the history of when a role is assigned and revoked to a userHi Team, For audit purposes, we’d like to know if there’s a way to track when a specific role was assigned to a user and when it was revoked. Currently, we can only revo…
-
How can I ensure my BIP report for line managers only returns results of their reporting line?Summary: I've built a BIP report and made it available to managers as a link (static URL page entry in My Team) and it works perfectly except it returns results for all …
-
How to get Questionnaire Answers on a Single Row in OTBISummary: Create an analysis with Checklist questionnaire answers/responses on a single row in the analysis Content (required): I have created an analysis using the Workf…Denise Izzi 983 views 24 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
How to identify if a goal has been added from the goal library?Summary: I have created two basic reports showing employee performance and development goals. I want to know how many of those goals have been added from the goal librar…Sarah Cottrell 38 views 5 comments 0 points Most recent by Paul Campanello Reporting and Analytics for HCM -
Certified payroll - Has Oracle provided delivered reports for certified payrollSummary: Has Oracle provided delivered reports for certified payroll? Can someone, please share any leads to achieve the requirement? Content (please ensure you mask any…Suppu 37 views 2 comments 0 points Most recent by Trisha Hastings Payroll and Global Payroll Interface (GPI)
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract…User_2025-02-11-06-38-03-841 304 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
Issue in Dynamic URL in StructureSummary: We are trying to use dynamic url in structure tab in instance (https://ehzq-dev14.fa.ocs.oraclecloud.com/) to navigate to the report folder but the web applicat…
-
Disability status of My Contacts (People to Cover)Summary: Hi Experts, We have requirment to send email notification to employees when Employee added Contact Relationship (Me→Benefits→Before you enroll→My Contacts) with…Murugaganesh 29 views 2 comments 0 points Most recent by Murugaganesh Reporting and Analytics for HCM -
Payroll administrator is unable to see records updated by Fusion HCMWe have an analysis created using subject area Payroll - Personal Payment Details Real Time. I can see all records having been updated by any user but our Payroll Admini…Deana Wittman 15 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu…TerryM01 97 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What is the exact query to get all values of transaction consoleSummary: What is the Backend Query to get the transaction details of a particular transaction as it is appearing in the transaction console. Content (please ensure you m…JSAHOO1988 33 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.6K views 8 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c…
-
SQL query to get the manager of a particular department in bip report in fusionI need to get a BIP report that should contains person information and department , Department hierarchy till level 3 including top department and the manager's name of …Anjali_Kumari4121 26 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Filter OTBI prompts to only certain criteriaI created a Dashboard for our Learning team, which includes a Course tab, as well as a Specialization tab. The analyses used in each tab filter for the appropriate Learn…
-
Deeplink for line mamager to see direct reportee performance document.Summary: Hi Team, @Naga M -Oracle , I see below deep link will redirect to particular document in redwood version for line manager only when he is a document manager. 'h… -
HR Analyst/Specialist - OTBI Report w EarningsSummary: HR Analyst/Specialist - OTBI Report w Earnings Content (please ensure you mask any confidential information): We have HR Analyst/Specialists that need the abili… -
In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.
-
User Preferences in OTBISummary: Is there a subject area to report on user preferences under "My Account" in OTBI? Would this area report the same data as the user's "Correspondence Language" u…
-
Absence Record Not showing after Global Transfer Or TerminationSummary: Hi Guys, I’m unable to view the absence records after an employee is terminated or globally transferred. Could anyone please help me understand what might be ca…Dharani Dhar Gupta 27 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM