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
-
Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance. -
BPM Approval notification BI report for "Request a New Position" notificationSummary: When an employee is moved between departments, a "Request a New Position" notification is distributed. This notification provides details on positional details …
-
Email bounce back notification fusion hcmSummary: Client have a requirement where in a recipient try to reply to "sender email address" an email bounce back notification to be sent to recipient. for example: De…
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…
-
-
Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…
-
Is there a way to bring UNION_ID for an employee in FAW? Please suggest a suitable PVO for UNION_ID.How to get UNION_ID for an employee in FAW? It is not present in assignment table: dw_wrkfrc_asg_f.
-
-
Display only Learning Initiative data from the WLF_EVENT_ASSIGNMENTS_F tableSummary: We noticed that data belonging to both Learning Assignments and Learning Initiatives is being stored in the same table: WLF_EVENT_ASSIGNMENTS_F. According to th…
-
Adjusted FTE Table and Views for BI Publisher ReportsHi, I have a couple reports in my system that require the addiction of the Adjusted FTE field as a replacement to the standard FTE field, and I've had a look at the HCM …
-
-
-
expedited element entries querySummary: Hi, We have a report about the expedited element entries but not for HCM Extracts. Do you have any sample query about how to get this report?
-
unable to access data from Compensation- Salary Details Real time with custom roleWe have created an OTBI report using Compensation - Salary Details Real Time. We have created a custom Role for Human Resource Analyst. With this role we are unable to a…
-
Query for Assignment Action and Action reasonSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Restrict BIP report data based on the AORsSummary: Hi All, @Mandeep Gupta --> If you have faced any such type issues kindly help me with this. I have a requirement to build a BIP report in such a way that If emp…
-
Query that fetch Calendar Events and LocationSummary: I need a query to link Locations and Calendar Events, but I couldn't figure how to do it. Anyone have any query like these? So far I've accomplish this one but … -
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
-
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…
-
How to print a prompted date selectionSummary: I have an analysis with a date range prompt on the field Work Relationship Start Date. I would like to display in the report the range that the user selected. W…
-
-
How do I create a severance report using payroll run result real time subject area ?I am trying to build a severance report for codes - SVR, RTN, SVK, SVL, WRN. I am looking to get the earnings in the below format but I am struggling to find the fields …
-
How to extract LEGAL_ENTITY_IDENTIFIER?I need a SQL query for a BI report to extract the LEGAL_ENTITY_IDENTIFIER, starting from a department.
-
Compensation Salary History Details Real Time not showing data for leaversSummary: Hi all I have built a report in OTBI using the Compensation - Salary History Details Real Time. I noticed I am missing data for employees who have left the orga…
-
OTBI Termination Date Filter Syntax QuerySummary: Hiya, I am trying to filter out any records where the Termination Date is before the current date. If the termination date is after the current date then the re…
-
How to Create a Report for "Correct Employment" Transactions?Summary: I need to create a report for all the Correct Transactions performed by the HR team in a day/week/month but not sure which table to use? Is there a way to repor…
-
department reportSummary: How to extract or Query to get this information Note No.of employees Means Count Content (please ensure you mask any confidential information): Version (include…
-
Columns within the PER_SHARE_INFORMATION table is not populating.Summary: Business need request has come in to build a report regarding shared data access. I have used the PER_SHARE_INFORMATION table. This gives me the employees who a…
-
benefits cancelled before coverage start dateSummary: Hello Experts, I have to extract in BIP the employees that cancelled or changed a benefit plan before the coverage effective start date. Can you explain me how …