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
-
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com… -
ORC OTBI Report issue when we export from outputSummary: Hi Team, we getting below issue when we ty to export the data. Thanks, ajay Content (please ensure you mask any confidential information): Version (include the … -
"Test Notification Email Address" TableHi, Is it possible to query the BPM Worklist "Test Notification Email Address" from a table? Thanks, Derrin -
PL/SQL - Absences in UoM: Weeks to be Displayed in Days?Hi all, Hope you are well. We have certain absence types such as Maternity, which have the UoM: Weeks. We have a requirement for reporting purposes to display this as Da…
-
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin…
-
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.
-
I Need a report showing pension contribution by employees and employersSummary: Does anyone know which subject areas I should use to get the pension contribution from employees and employers? Content (please ensure you mask any confidential… -
To remove NULL row occurring due to CASE statementThrough OTBI report, trying to pull element entries having input value as STI Target %, Percentage only. So, put the following formula in the case statement: CASE WHEN "…
-
How to get all Active and Inactive Records Regardless of Assignment Type Except for Inactive PendingSummary: Hi All, I have a report that get all Active and Inactive Records but I want to Exclude Inactive Pending Worker only. Any one have already tried this? Trying to …
-
Office 2019 Oracle BI Publisher ErrorFor example when I try to load a xml data ı got this message Hello I just downloaded Oracle BI Publisher but at my publisher area there is an error . I tried to install … -
Is there way to publish OTBI Reports to Third party RSS FeedsSummary: We are planning to display OTBI reports in ScreenCloud RSS Content (please ensure you mask any confidential information): Is there any way to display OTBI Repor…
-
Does anyone knows how to query current task in Performance Document?Summary: I need the select statement to fetch this value Content (please ensure you mask any confidential information): I'm trying to write a query that selects this fie… -
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti… -
Email bounce back notification fusion hcmSummary: Client have a requirement where in a recipient try to reply to "sender email address" an email bounce back notification to be sent to recipient. for example: De…
-
Moved: In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop…This discussion has been moved. -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…
-
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
Data is not fetching When I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment DetailsSummary: No records are fetching when I add Column: PER_ASG_DF_DESC_UNIT - Worker Assignment Details from Workforce Management - Worker Assignment Real Time with another… -
How to Create a Report for "Correct Employment" Transactions?Summary: I need to create a report for all the Correct Transactions performed by the HR team in a day/week/month but not sure which table to use? Is there a way to repor…
-
unauthorized access: either you do not have the privilegeSummary: Content (please ensure you mask any confidential information): hi team, I have embedded a bi report, but I'm getting this error- unauthorized access: either you…
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom… -
Is there a table or a view holding "Previous Comments" or "Approval History" related to unapprovedSummary: In order to check a detailed approval status of Goals before approval, I'd like to extract data such as "Previous Comments" or "Approval History" . I'd like to …
-
PersonProfileItemPVO Issue post 23D, what's changed to impact this?Summary: We have a nightly extraction that retrieves delta data. Since 23D was applied the extraction is retrieving all data, causing timeouts due to the volume it is tr… -
How to limit Department prompt values to active onlySummary: I have an OTBI report using Workforce Management - Worker Assignment Real time subject area with an optional Department prompt. How can this prompt be limited t…
-
Matrix manager dimension in worker assignment real time subject areaHello Team, I have used attributes in matrix manager dimension of "Workforce Management - Worker Assignment Real Time" subject area to get all direct and indirect report… -
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you. -
in oracle recruiting cloud, which table/column stores external candidate flagSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Migrating OTBI reports from test to production environmentsHello, We are in the process of implementing Oracle HCM system and have created OTBI reports in test environment that we need to move to production. Our implementation p… -
Query for getting learning details of Development Plan GoalSummary: Please help with getting the query of learning details in the Development Plan Goal under Career Development Area.
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…