Category 81
Discussion List
-
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e… -
Duty travel resumption report is showing for employee not for contingent workerUser A who is a cwk and User B is a emp, both of them are having exact payroll roles. But for user A the Duty travel resumption report is not populating the data only co…
-
Unable to find 'Self-assigned Event Rule' tab under Create Life Event pageSummary: Hi Experts, I’m trying to configure a new Life Event in Oracle HCM, but I’m unable to see the “Self-assigned Event Rule” tab under the Create Life Event page. C…
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…
-
How to find out who/when edited BPM Worklist about Access ActionsSummary: What are the tables/views enable us to find out some audit info that who and when have edited the BPM worklist, e.g. ApprovePerformanceGoal, about the Access > …Hellen Zhao-5941 33 views 2 comments 1 point Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Require User Account Status update history.Summary: Dear Oracle Community, We got an issue regarding the Users Account status. There's statuses turned to Inactive. We want to know who has made changes to the acco…Muzammil_789 13 views 2 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
Enrollment Coverage Through Date in the Benefits subject area is showing 12.31.4712Summary: When creating a open enrollment report for 2026 using Benefits - Enrollments Real time, Enrollment Coverage Through Date is 12/31/4712. Because of that it's sho…
-
How to identify records in ASSIGNMENTNODE PVO that do not appear in Employee's History?Summary: When using the ASSIGNMENTNODEPVO, I see records for employees that I do not see in their history in HCM. For example, an employee resigned and this was entered … -
i need query for approved by nameSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 9 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 740 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 470 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 9 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 10 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 492 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 13 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 990 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 39 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 41 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 307 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 31 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 17 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 102 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 39 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM