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
-
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How… -
Add "Business Object Type" and "Attribute" columns to the Delete Audit ReportSummary: We had a custom report called 'Delete Audit Report' and the client wants to add columns on it for 'Business Object Type' and 'Attribute' same on what we see on …
-
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in … -
Reporting on Termination Counts - An analysisSummary This post provides an explanation on the calculation of termination counts in OTBI.Content The post contains a brief synopsis and also a sample analysis xml to c… -
Assignment Event/Workforce Trends - Counting a Termination on the Termination DateContent Hello Experts! I'm using Assignment Event Real time and have noticed that terminations are counted the day after their termination date. I suspect it's counting … -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio…
-
Are there any dashboard prompt experts or videos out there?Summary: Trying to create an EDI dashboard cross referencing with the new Learning Subject Area Content (required): I need to access data in three subject areas "Workfor… -
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…
-
Reporting on Performance Goal Approval Status in Release 10Content Hi Can someone please advise if I am missing something here, but in release 9 we had performance goals reports which reported out the approval status by goal. No… -
DATE_ADD function ErrorSummary: Hi Everyone! I am try to add specific year to the hire date using Date_add function, but it is throwing "Missing right parenthesis error". Could any one help me…
-
Page Composer -> How to pass pass parameters to embedded dashboard in Talent Profile pageSummary Bind Parameters to OTBI dashboard promptsContent Hello, Can anyone please help on this scenario? I have built a dashboard in OTBI, embedded that inside Talent Pr… -
Procurement and Projects Folders are still available after doing Catalog Lockdown steps!Summary: Content (required): Procurement and Projects Folders are still available after doing Catalog Lockdown steps! Version (include the version you are using, if appl…
-
Analysis with parameter not errors from Reports & Analytics but works from BI CatalogueSummary: We have a report which is available for managers but it errors from the Reports and Analytics page but works from the BI Catalogue. The report has a prompt (dat…
-
Fusion BI Report Output file name along with current date and timeSummary: Fusion BI Report Output file name along with current date and time Content (required): Hi Team Can someone help me how to add date and time in the custom BI rep…
-
Oracle BIP Report Issue with RTF templateSummary: Seeking a solution to fix the corrupted RTP template. Content (required): Enhancing the existing rtf template to add a new field. However, the new field value d… -
Top Employee Missing from HierarchySummary: Our top employee is not appearing in reporting when the organisation hierarchy is included in a report. Content (required): The head of our organisation current…
-
Address change by DepartmentSummary: I need to be able to provide address changes only for certain departments. The Workforce Management - Person Real Time subject area does not appear to have the …
-
Costing table link with gl tables in hcm fusionSummary: I am looking for the below tables Whether its linked with gl tables pay_costs pay_cost_allocations_f pay_cost_allocations_keyflex GL_JE_BATCHES, GL_JE_HEADERS G…
-
Resignation/Termination Approval- Current/Pending Approver DetailsSummary: Resignation/Termination - Pending Approver Details Content (required): Hi All, There is a report requirement to show Resignation/ Termination approval -> curren…
-
Table to pull the ESS Scheduled Job definition details.Summary Required table which stores the ESS scheduled job defiinition details.Content Hi Experts, I would like to know from which table we can pull the ESS Job definitio…
-
View Display Error - Error Codes: EKMT3FKSummary: I am running a fairly simple OTBI analysis and the report won't return all the records. The below error is presented when exporting the report: View Display Err…
-
Report on Employee's Time in Current RoleSummary: Content (required): We're looking to build a report that show us how long an employee has been in their current. Do anyone have recommendations or samples? Vers…
-
SQL not working in Alert composerHello Team, I have created an alert where it needs to be triggered when anyones work schedule got changed. I have created sql filter in alert section but my alert is tak…
-
How to take Resignation Submission date?Summary: How to take Resignation Submission date? Content (required): Hi All, Report requirement to show employee's Resignation Submission Date. From which table we can …
-
SQL for PER_EMAIL_ADDRESSES to obtain Email Address IDSummary: Email Address ID required for HDL worker.dat file to mass upload email address changes. Content (required): We want to use HDL to mass upload email address chan…
-
Restricting the values of a dashboard promtSummary: Hello, We have made a BIP report on an Assessment which will show the candidates who have reached the assessment state and their results/current status etc. The…
-
How can i get access to OTBI?Is there a specific role/privilegie that grants access only to the OTBI? Thanks Guys, Mayko Melo
-
State tax details in hcm fusionSummary: I am looking for the below details in the state tax setup level state tax type state Minimimum wage state of the tax defined Please guide me to refer the table …
-
Rehires are showing twice when using Seniority Years in Wrkfrc Mgmt - Person Seniority Real TimeContent (required): When I add Seniority Years (or months/days) to a report in this subject area, rehires are duplicated with one row calculating based on their enterpri…
-
Report for Position Attributes change HistorySummary Looking for a report whcih can give us history of position attribute changes.Content Hi I am looking for a report to track changes in all position attributes lik…