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 enter the 'Export' Action in a DashboardSummary: How to enter the 'Export' Action in a Dashboard Content (please ensure you mask any confidential information): Hi, we created a Dashboard, based on an OTBI Repo… -
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊
-
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …
-
Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation? -
I need to get the updateddate of the workflow when it is approved submitted by employeeSummary: I need to get the updateddate (FA_FUSION_SOAINFRA.WFTASK) of the workflow when it is submitted by employee in the manage document of records. I am using below q…
-
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…
-
calculation card querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…
-
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.
-
How to run Oracle Standard Cheque Report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report cheque report of payroll module of HCM. But I don't know how to run this report. Thanks Content (please ensure y…
-
Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.
-
Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info… -
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
Per_Periods_Of_Service Not adding a Row for Voluntary Termination ActionsWe have been noticing that certain termination actions are NOT hitting the per_periods_of_service table. For example, if I submit a retirement for myself and it goes to …
-
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP report
-
The manager and assignment details are not displaying on the Security Console page for the employee.Summary: The manager and assignment details are not displaying on the Security Console page for the employee. Content (please ensure you mask any confidential informatio…
-
BI Report ran using SOAP service is not picking multiple input parametersSummary: We have a requirement to run BI publisher report using SOAP request. There are 3 input parameters there in the report as well as passed through the SOAP request…
-
immediate updates of information to a PDF outputSummary: I have a question about how to get immediate updates of information to a PDF output of a BIP report. Content (please ensure you mask any confidential informatio…
-
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…
-
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base… -
Issue with counts for the Talent OTBI reportHi All, Facing issues with counts in Performance summary report in OTBI. Due to some fact columns, counts drill down not working as expected. Using 3 subject areas for R…
-
How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta… -
Query overview ofreports and analysis from analytics?Summary: I would like to query the names and file paths of all reports, analysis' and data models in a specific folder in Analytics in HCM. I am specifically looking for… -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …
-
Need to build an analysis report of all pay periods that exist to dateSummary: I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is t…
-
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'… -
Looking for lineage data for a few VOs which are missing in Rel13_24C_BICC_HCM mapping sheetSummary: Looking for linkage details for following PVOs. These are not deprecated but missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects sheet. Any help wil…