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
-
Emergency contact detail access via BIP reportSummary: Emergency contact detail access via BIP report Content (please ensure you mask any confidential information): Hi, We've built a BIP report to give emegency cont… -
Custom BI Report is getting time out error while trying with client loginHi, I am facing issue with one of my Global HR Custom BI Report is getting time out error while trying with client logins but it is successfully executing with developer…
-
How to pass multiple input values in a flow pattern as a parameter.Summary: I have to pass multiple cost centers in a flow as a parameter to get the report. Can anyone help me to achieve this requirement. Content (please ensure you mask…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
Why Are TEST and PROD Behaving Differently after Adding Workforce Confidential Reporting Data DutyWe have an urgent issue that we are looking to resolve. A team member informed us that she's unable to view Person Real Time subject areas details like emergency contact… -
OTBI reports for talent review doesn't work with custom objectsSummary: Content (please ensure you mask any confidential information): Hello experts, we created OTBI dashboards for talent review and we enabled filter by talent revie… -
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi… -
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur… -
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…
-
Only 3 formatting rules from excel template will be used when run the BI reportSummary: In BI Excel template, we define 5 formatting rules When we run the BI report, we can see only 3 rules are using. Is anyone know how to resolve it or it is a bug…
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…
-
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I… -
Field Created on in OTBISummary: In which subject area of OTBI HCM can the field created on of an action be found?
-
Performance and Potential box empty for meetingSummary: Content (please ensure you mask any confidential information): Hello experts, we scheduled one meeting for potential and performance and the box names appear in…
-
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme… -
How to filter out Contg Worker in Analysis | Workforce Management-Absence Calendar Details Real TimeSummary: Subject Area: Workforce Management - Absence Calendar Details Real Time Question: How can I filter out/ not include Contingent Workers in Analysis ? System Pers… -
Help needed with OTBI FilteringHi There I have an otbi analysis which is based off on "Workforce Management - Goals Real Time" and i want to filter out some records based off the analysis "Workforce M…
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…
-
Getting error when running OTBISummary: Getting error when running OTBI analysis using Benefits - Person Information Real time Content (please ensure you mask any confidential information): Hi, Gettin…
-
How to retrieve timestamp when candidate submits RMI applicationSummary: Content (please ensure you mask any confidential information): Working to troubleshoot CSP automation and I am looking for a timestamp for when candidates submi… -
BI Publisher - RTF template - write a numeric value in lettersSummary Need to write in letters a numeric value from a BIP fieldContent Hello, I am creating a RTF template that I want to display as a report in BI Publisher. In this …
-
Need a query to find number of users using a privilegeSummary I.E. find number of roles linked to a privilege and hence usersContent The privilege is Manage Performance Goal ran this to get some privilege ids but struggling…
-
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template … -
Unable to extract OTBI Italian Collective agreements information for WorkersSummary: Content (required): Hi team, We are unable to extract standard fields on contracts for Italian Employees related to collective Agreements with OTBI. Do you have… -
OAC lab not found on Core HR implementer courseSummary: no OAC console as it was previously the case when requesting a lab from worforce structures in the Core HR MyLearn Course Content (please ensure you mask any co…
-
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical…