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
-
Automating HDL Worker loading via BIP ReportWhat is the process to Automating HDL Worker loading via BIP Report -
How do we update default expense account information for a person in Fusion HCM in Responsive UIPlease point to any screenshots/ links/documentation as i could not find any place which shows default expense account and position for employees. -
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "… -
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H… -
Number of attempts by each learner are not showingHello, I need to get the number of attempts that a learner did on a course. Example below: Offering Title: JV Test 01/18_SP Person number: 001670007 1st attempt - 50 2nd… -
How to embed an OTBI report or dashbaord on a redwood page?Summary: Content (please ensure you mask any confidential information): Is it possible to include or embed an OTBI report/dashboard on a redwood page (e.g., Journeys pag… -
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva… -
Reports return SQL error since applying security profileHi there, Since doing a restructuring of the business, we applied a person security profile to one of the HR roles so that they could only search for and work with peopl… -
We updated our integration URLs with workers api but not workingSummary: We have rebuild our integration URLs with Worker API but when we are testing getting error like: "Request parameter expand with value workRelationships.assignme… -
Unable to find 'Activity Attempt ID ' In OLC ModuleProblem Description We have requirement to fetch the column 'Activity Attempt ID' in OLC module basically Activity Attempt ID is a part of activity learning item but bac… -
How to add Calendar chart in OTBI Analysis under Learning Module?Summary: Hi Everyone, I have a requirement to implement a Calendar Dashboard that has an identifier if an activity is scheduled for that date - e.g. turns green if class… -
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics. -
Is there any documentation available on using AND, OR, and groups in OTBI report filters?Summary: I am trying to set up filters in an OTBI report to pull a subset of employees for an assignment in Oracle Learn. I need to select a group of employees and then … -
Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w… -
Brazil HR unable to access the Custom folder under OTBISummary: Has anyone had issues with their Brazil HR being unable to see the Custom folder in OTBI? If I log in from Canada as this Brazil HR person, I can see the Custom… -
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor… -
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_… -
Does an Agent(OTBI) continue to run even though the user who set it up is inactive?Summary: Is there any way to find out the agents created by a user(Inactive now) in "MY Folder"? Also does an Agent continue to run even though the user who set it up is… -
Query to get the failure reason of a transactionSummary: Please share any sample query to get the issue description of a failed transaction Content (please ensure you mask any confidential information): From the scree… -
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp… -
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash Jayavel -
Need help finding field in OTBI reportSummary: I have everything done on a custom OTBI report out of Performance Task Status Real Time except I need to pull the "Step" as shown in my image below. I cannot fi… -
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure… -
How to fix legislation code in table per_person_names_f_v?Summary: The following query gives two different legislation codes for the same Employee due to which the extract doesnt pull the gender information for that employee: p…
-
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the … -
create a performance template section based on goals subtypeSummary: Create 2 goals section in performance template Content (please ensure you mask any confidential information): Hello, I have a request to use the subtype to spec… -
Remove column from Excel BI Publisher reportI have a report containing many columns that I prepared using Excel Publisher and I want to remove a column, but when I upload it back to the system by clicking delete t… -
Identifying duplicate emailsSummary: An analysis that highlights the same emails being registrered to multiple persons Content (please ensure you mask any confidential information): I need an OTBI … -
Created new Measure with conditions incorrect result, Workforce Management - Workforce Assignment RTSummary: Hello all, I have created a new measure - Count of Female Managers - FILTER("Worker Assignment"."Assignment Count" USING ((DESCRIPTOR_IDOF("Workforce Management… -
Why does the Compensation - Salary History Details Real Time not show the correct adjustment?Summary: In the subject area Compensation - Salary History Details Real Time it is showing a value which is not in the front end for adjustment. Content (please ensure y…