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
-
How to create an ER diagram that illustrates the relationship between tables within Oracle Fusion?Summary: How to create an ER diagram that illustrates the relationship between the PER_LOCATION_EXTRA_INFO_F table and the LOCATION_ID and LOCATION_NAME columns in HR_LO… -
Need inputs to fetch the Absence "Plan Use" informationSummary: Need inputs to fetch the Absence "Plan Use" information Content (please ensure you mask any confidential information): In the absence records, we need to fetch …
-
Query to get Statement of Earnings (Payroll> Person Results> Calculate Payroll> Standard Earning.)Summary: Could anyone please provide a query to retrieve the following data? Query to get Statement of Earnings (Payroll> Person Results> Calculate Payroll> Statement of… -
Query or subject area to link internal candidate information to current assignmentSummary: For our internal applicants in Oracle recruiting, we have many report requirements to be able to link their employee assignment to the candidate and requisition… -
I am not able to get an etext output without Special charactersSummary: I am getting special characters in my etext output. I tried using UTF-8 character set, that still didnt help. I used save as encoding UTF-8 on rtf template. Tha…
-
What table(s) joins the converted work assignment to the pending work assignment?Summary: I am seeking information on what table(s) joins the converted work assignment to the pending work assignment? Use case is that information stored on job offer a… -
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time … -
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
How to report the 'Attachment Count' of a DoRSummary: How to report the 'Attachment Count' of a DoR Content (please ensure you mask any confidential information): Hi, we created a Document Of Record. The employee h…
-
OTBI report created using the subject area "WFM - Document of Records Real Time" is not showing dataSummary: I have created an OTBI report using the subject area "WFM - Document of Records Real Time" which is not showing all the data, no filters applied still only one … -
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…
-
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…