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 get Completed By and Task Start Time of Task/Activity?Summary: we need to pull Completed By and Task start time fields using BIP ? Do we have direct columns ? Content (please ensure you mask any confidential information): V… -
query to fetch WorkDayDefId and WorkDayDefinitionCodeSummary: query to fetch WorkDayDefId and WorkDayDefinitionCode Content (please ensure you mask any confidential information): I am trying to fetch WorkDayDefId and WorkD… -
Edit time-out in Administration-> Runtime ConfigurationSummary: Hi Everyone, I'm trying to increase time-out for query and report but unable to edit the query time out in administrator Administration-> Manage Publisher-> Run…
-
Unable to acheive trend analysis using prompt for accounting year in OTBISummary: Unable to use Time series formulae in OTBI to fetch YTD data for past 5 years/ for 5 years based on prompt Content (please ensure you mask any confidential info… -
How can I activate audit trial on PER_CONTACT_RELSHIPS_F tableSummary: How can I activate audit trial on PER_CONTACT_RELSHIPS_F table Content (please ensure you mask any confidential information): Version (include the version you a…
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,… -
DFF in termination under PER_PPS_DF which subject area can we report from?Summary: We have added a DFF to termination under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from? Content (please ensure y…
-
Combing Two Rows into One Based on Person NumberHello everyone, We're working on the earnings report and there are some employees have two assignments for one year. We are looking for the solution to combine them into…
-
We are looking for options to connect to the HCM database from external application eg. ExcelSummary: We are looking for options to connect to the HCM database to pull employee and org data to simplify some of the processes for our HR. Content (please ensure you…
-
How can I combine termination count and hire count in one analysisSummary: I have attached two different analysis One is showing hire count and other termination count But the requirement is that I need to have both the columns in the …
-
Error while promoting SME on FAWHi all, I'm facing an issue while trying to promote SME from my DEV FAW instance to me PROD instance… FYI : I've completed the latest upgrades of both instances (same la…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle
-
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…
-
How to retrieve Country of a Logged in User to be used in a value set of a DFFCreating a DFF to determine Yes/No based on country (and some other details) of the logged in user in the value set of the same. First is it possible at all, if yes then…
-
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e…
-
How can i get the results of a fast formula directly from a querySummary I have a complex fast formula and need to read the result of it through a query. Content (please ensure you mask any confidential information): Version (include …
-
global transfers reportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Use Case and …
-
Error Codes: EKMT3FK5 Limitation of Pivot table in OTBISummary: I pivot 'Balance Name' (around 70 columns) and get this error message if I output too many records, I'm wondering how can I increase this limitation number for …
-
REQUESTED_FOR_PERSON_ID Foreign key for BI ReportSummary: REQUESTED_FOR_PERSON_ID Foreign key for BI Report Content (please ensure you mask any confidential information): Hi, we would like to create a report which prov…
-
impact of scheduled HCM Extract and Reports during the maintenance or upgrade timeSummary: Customer has concern with scheduled BI, OTBI Reports and HCM Extract during the Maintenance window. What will happened with them. C
-
area of responsibiltiesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI Agent to send to HR Business Partner via Username in the agent not sendingSummary: I am setting up a new agent to send via email to users. it is being created by conditional analysis. Get Recipients from the Analysis Used in the Agent Conditio…
-
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…
-
HCM Extract Parameter LOV values are blank and the parameter is made out of Value setsSummary: I am working on HCM to WACS OOTB. HCM Extract Parameter LOV values are blank and the parameter is made out of Value sets . Value sets are configured properly. P…
-
Ability for employee to self report a conflict of interest.Summary: I have a requirement for an employee to be able to self report conflict of interests, including employment of relatives, material interest and outside interest.…
-
Can we delete an assignment from oracle fusion?Summary: Example : Lets assume E000001, E000001-2, E000001-3 assignments are present in the system with same legal employer. Can we delete E000001-3 completely from orac…
-
Benefit Participant Eligibility Employment Assignment Category TableHi, We are trying to create a report to fetch Participant Eligibility information. But not able to figure out the Employment Assignment Category information. Can anybody…
-
What table holds Request More Information data in approval transactions?Summary: What table holds Request More Information data in approval transactions? Content (please ensure you mask any confidential information): Version (include the ver…
-
Response ScoreSummary: Hi, Does anyone know where can I find the Response Score (if it is the correct answer - 1 or the wrong answer - 0) in OTBI? I've tried under Questionnaire Respo…
-
Selection Process Internal vs External - OTBISummary: Hi Expert, I have a requirement to show no application to the respective phase name and with the filter criteria month, year, and candidate Selection process na…
-
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…