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
-
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…
-
Approvals are in progress. Info is lockedHello, I am trying to transfer an employee from one legal entity to another and I am getting a message that approvals are in progress. I tried to run the Conflicting Tra…
-
In which table I can find this column "Department" ?I'm creating a report with BI Publisher and I need the department column but I've searched several tables and can't find it. I've found the business units and legal empl… -
A comparison is being carried out between non-compatible types DATE and INTEGER. (HY000)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The below formula does not return any errors however when running the report I'm gettin…
-
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar… -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Condtional formating not working for standard fieldsSummary: Adding a conditional formating criteria does not work on standard fields but works fine for flex fields Content (please ensure you mask any confidential informa…