Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Redwood Issuing Comments field in Document Record Displays html Text in OTBISummary: We just implemented Redwood for Document Records. The Redwood field for Issuing Comments (seeded Oracle field) displays as a rich text editor field where bold, … -
OTBI - Legal Employers that use this jobSummary: OTBI - Legal Employers that use this job Content (please ensure you mask any confidential information): Subject Area: Workforce Management - Worker Assignment R… -
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …
-
Bold letters are showing in PDF Output?Summary: We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, all the letters are…
-
Steps to fix back dated State tax rate after payroll has been processed.Payroll for January and February has been processed, and the Balance Exception Report indicates discrepancies for multiple employees across various state taxes. What are…
-
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu… -
How to restrict special characters for account holder name in redwood personal payment method pageSummary: Customer want validation needs to be thrown as an error when there are Special Characters in the the Account Holder Name. And in personal payment method page I'…
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.
-
oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: ErrorSummary: Hi, am getting below error in BIP level. oracle.xdo.XDORuntimeException: oracle.xdo12c.xpath.XPathException: Extension function error: Error invoking round:java…
-
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
last update date not getting for Business unitSummary: Hi We have deactivated Business unit. i was looking for last update date in view#fun_all_business_units_v but i am not seeing any change last_update_date. May I…
-
Approach to get historical login details for a userSummary: Hi All - The ASE_USER_LOGIN_INFO table only gives me the latest sign-out details for a user? How can I get historical login/logout data? I also tried to use Fus…
-
Need guide for recurring journeySummary: “Could anyone please share the inputs or steps on how to create a recurring journey?” Content (please ensure you mask any confidential information): I have Enab…
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: …
-
HCM Audit Table Differences - Do the audit tables keep deleted rows and the regular table does not?I want to understand the difference of contents between a "regular" table and an "audit table" that has an "_" underscore at the end of the name. I am calling PER_ALL_AS…
-
Quick action menu created for BIP is not visible after 25DSummary: I have created Quick Action Menu item for BIP report course completion certificate. after 25D, its not appearing , when I checked in Sandbox , it shows message … -
Roles and Privileges Real TimeI am required to show the date when a user was assigned a role. Is that possible either with this subject area or through a custom query. My output needs to be: Person N…
-
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…
-
Email Bursting Fails in Oracle Fusion UAT Instance – Missing SMTP ConfigurationHello Everyone, We are currently performing UAT testing for our Oracle Fusion HCM BI Publisher bursting reports, which send email notifications to users. The same report…
-
Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"?Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"? If so, what is the Subject Area? I've tried several "Knowledge" SA's, and a few "… -
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…
-
Report including Manual scores summary sectionWe want a report on the annual performance review with the Manual Score per section and a Calculation of the average score in the summary section, buit also the managers…
-
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…
-
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…
-
Can we extract personal information occupancy in bytesNeed to extract personal information of candidate and employee from a certain country in bytes. Is this achievable? If yes, please share the steps to get the info.
-
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…
-
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…
-
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 …