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
-
HR_6882_HRPROC_ASSERT errorSummary: HR_6882_HRPROC_ASSERT error Content (required): Hi Team, Greetings! We have run into error for the direct deposit process with error log summary as- BIP job pro… -
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th… -
OTBI Filter for Numeric using MAXSummary: Thinking of the approach how to apply Filter in OTBI to get the Max value of column where column is only numbers. Content (required): Data on DFF column is Varc…
-
Report on Job Openings as of Last MonthSummary: I need to report on how many job openings there were as of last month. When I use the sql for last day of last month, the numbers aren't accurate as it is live …
-
Report showing previous month (starters, leavers)Summary: Is there a way to filter results for only a previous month - for example all new hires, terminations - regardless of the date the report is run? Content (requir…
-
Need to display complete History related Employeement changes for the previous and current valuesSummary: Need to display complete History related Employeement changes for the previous and current values Content (required): We need to display complete history employ…
-
Generate automatically incremented check numbers for "Generate Check Payments" processExperts, Request your help here. Can we add custom parameters in a flow pattern copied from "Generate Check Payments"? We need to retrieve the last generated check numbe… -
OBIEE to FTP site?Content Does anyone know if it is possible to create a report in OBI and then drop it to a SFTP site? I don't see a way to do this using the delivery options in OBI, whi… -
Arrears report with Current Deduction And Total ArrearsSummary: Hi, I am trying to create a report that will show current deduction taken for Med, Dental, Vision Arrears along with how much the total is and if the full amoun…
-
How to link custom button in homepage to BI ReportSummary: Content (required): Hello experts, I've created a custom button in homepage under My Client Groups tab. This button should be linked to a custom BI Report saved… -
How do you get the effective date based on the action reason value?Summary: I want to get the parental leave start date which is the effective start date based on the action reason = 'On parental leave' Content (required): I have the co…
-
Gross Pay - Previous Week and YTDSummary Would like to be able to report out on the previous weeks' gross pay along with the year to date balanceContent Currently we have two reports. One to pull the pr…
-
Need a list of all the BPM Approval Workflows from oracle fusionSummary: Content (required): Do we have any report or query or any front end screen which exports the list of all the BPM Approval Workflows from Oracle Fusion? Version …
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great… -
Report is not giving any outputSummary: We have configured Employee Questionnaire and Manager Questionnaire and created performance template to use only these 2 questionnaires. 1st step is employee to…
-
Issue with Report Edit for Bursting QuerySummary: Issue with Report Edit for Bursting Query Content (required): Hi All Greetings! This is an issue as observed when we tried to open the data model- When we try t…
-
Need inputs to fetch the "Third Parties" (My client groups-->Third Parties) informationSummary: Need inputs to fetch the "Third Parties" (My client groups-->Third Parties) information Content (required): We need to know table name/OTBI subject area to fetc…
-
Active assignment - Prompt between datesSummary OTBI - Active Assignment by dates promptContent Hi, I want to create a report that will show us employees which were active between dates. The end user will choo…
-
Find list of requisitions that has internal employees in the Best Candidates.Summary: We have a requirement to find out requisitions that has internal employees in the Best Candidates list. Please share if there is any BI query that I can use to … -
Weird output behavior when reporting learn ItemsContent Hello, How can i change the export of reports so Each learning Item has it's own row? I can't figure this out for the life of me. This is the export now in excel…
-
Could not able to search BI Consumer in PermissionSummary: Hi Experts, I have removed the BI Consumer role from a folder and when I try to add back the BI Consumer role, I could not able to search in "Add Application Ro… -
BIP jobs are getting stuckSummary: BIP jobs are getting stuck Content (required): Hi Team, Greetings! We have been observing that multiple BIP jobs ( manual or scheduled) are getting stuck and re…
-
Data is not coming in an otbi report once ldg is added.Summary: Content (required): In an custom otbi report, data is not coming once ldg is added to that. Version (include the version you are using, if applicable): Code Sni…
-
Report Error - PGA limit (MB) exceededSummary: Report Error - PGA limit (MB) exceeded Content (required): Hi Team, Greetings! We have been getting the error as per the attached file for the report in Product…
-
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…
-
Failed to log into BI Publisher: invalid username or passwordSummary: Failed to log into BI Publisher: invalid username or password Content (required): Hello experts, we have done the P2T in oracle HCM, but after it, the connectio…
-
Security is not working in otbi dashboardSummary: Content (required): A custom role is able to see all the data regardless of their security. Is any privilege or security policy missing? Version (include the ve…
-
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if … -
Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBISummary: Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBI Content (required): Version (include the version you are us…
-
DFF Not showing in some HCM NotificationSummary: Hello, We've been customizing some HCM (NewHire, AddAssignment ...) approval notifications to add additional DFF. Our issue is that some DFF appear and some don…