Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti… -
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below …
-
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and … -
table name to fetch 'Write to person profile on completion' In learningSummary: Which table stores information about the Field 'Write to person profile on completion' In learning Navigation :- Course ->Skills and qualification -> manage -> …
-
Creating a Unified Report for Job Application Details and Pre-screening ResponsesHello Cloud Customer Connect Community, I hope you're all doing well. I'm currently facing a challenge and would greatly appreciate your expert insights. I am in the pro… -
how to get the Annualized salary of terminated employeesSummary: I just need basic details like thePerson number, Name etc of terminated employees with their annual salary. How do I get this in the OTBI report ? Content (plea…
-
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio…
-
Embed BI Publisher report without Fusion HeaderSummary: Hi - I am trying to embed a BI Publisher report into a page for our Learning admin to use but when I embed the report using the link provided within the catalog…
-
How do I join PersonAM_PersonAddressPVO with PersonPVO in BICC extracts?How do I join PersonAM_PersonAddressPVO with PersonPVO in BICC extracts? There is no column with matching values.
-
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…
-
Add a hyperlink to an image in a BI Publisher Interactive reportSummary: In an interactive report, it is possible to add a link to text using the appropriate icon, but how do you do it on an image? Thank you Content (please ensure yo… -
Task Type in Subject Area Workforce Management - Checklist Real Time - Checklist Task TemplateSummary: 1- Looking for the Task Type in the Subject Area Workforce Management - Checklist Real Time. This is to pull the configured task type for various tasks in the j… -
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI…
-
linkedin learning groups/Communities can be sync to oracle learningSummary: Cleint Requirment is to sync the Linkedin learning groups to oracle learning Content (please ensure you mask any confidential information): Version (include the…
-
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i… -
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…
-
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result… -
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…
-
SQL Query to retrieve employee evaluation in performance documentSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query retrieving the employee overall rating in performance d… -
SQL query to fetch the list of values for each value setSummary: Business requirement is to fetch the list of active values for each value set code in excel. Need to develop SQL query to fetch Each segment Value set code valu…
-
OTBI Analysis not fetch all Consolidation Grouphello expert, I have an OTBI Analysis on payroll balances, but it's not able to fetch data from all the consolidation groups in the system, it only pulls from one one co…
-
employees job interestsSummary: Report on employees job interests Content (please ensure you mask any confidential information): In opportunity Marketplace employees can record their interests… -
OTBI Report integrated within performance document is not loading first timeSummary: OTBI Report integrated within performance document is not loading first time Content (please ensure you mask any confidential information): I have OTBI report c… -
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…
-
Analysis relational filterSummary: I am trying to create an OTBI analysis as a new Oracle customer. Certain fields have multiple values. I am wanting to create one unique row per person , where t… -
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…
-
Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Summary Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Content I have created a OTBI report with the subject area 'Workforce Management - Worke…
-
Active department not found in reportHi, We are using the department level to differentiate between departments (divisions, sections, units). We have created a new tree version based on the new requirements… -
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a…