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
-
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… -
Post P2T, how to switch from classic dashboard view to new dashboard view?Summary: We have dashboard in Prod which has a responsive UI as per below. However post P2T, In Test it is showing classic view for the dashboards. How to change this vi…
-
Column order in BIP ReportSummary: Column order in BIP Report Content (required): Hi, We are trying to have specific order of columns in our BIP report (CSV output). Earlier it was word layout wh…
-
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
Help getting interview date - BI report for ORC.Summary: Hello experts, Need input for getting interview date for an ORC report i am working on. This is my first time working on ORC related tables. I can see this tabl…
-
We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference?Summary: Hi Team, We have option to Scheduled the BIP report in more option but why we go with ESS Job any difference? what is the main purpose of ESS JOB . How can we u… -
Performance report including response to questions not rendering while using pivot optionSummary: Have anyone been able to generate a report from Performance Rating real time subject area that includes response to questions with response to each question app…
-
Time Entries SQL HelpHi Experts, we need to fetch all the time entries including Absences.SO for Absences we need to have a column for Absence Type.But i am not sure how can we find the abse…