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
-
Which view/tables to access to create a report to capture User Login IP Address?Summary Which view/tables to access to create a report to capture User Login IP Address?Content IP Address of Application user in Fusion HCM is to be captured in a repor… -
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th… -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
Can we add a textbox (Number) as runtime parameter in OTBISummary: Hi team, Can anyone please confirm if, we can create a text box as run time parameter and we need to use that runtime parameter in one of the Column formula. Pl…
-
Can we change the row sequence in OTBI reportSummary: I have created an OTBI report, but one of the columns is not displaying in the same sequence as it does on the UI screen. On the UI screen, the column is showin…
-
Leavers Work ScheduleSummary: Hello, Is there a way to bring historical leavers Work Schedule and Work Schedule End Date? I am currently using the Workforce Management - Person Real Time sub… -
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, … -
Change the source environment for FAWHi, Our FAW dev instance is linked to an HCM test environment which has not been refreshed recently.., I'l like to change the source with another HCM test environment wh…
-
FAW average assignment calculationHi, I have a report to produce using the assignment count KPI for different years. I've been struggling in FAW to create the calculation that would allow me to display t…
-
Date prompt to pick dynamic date values from calender in BI Dashboard is not working.I have created a BI publisher report with date parameter and created a variable DB prompt with the Presentation variable as same parameter name, after adding both to Das…
-
Inconsistent results in my analysisSummary: Inconsistent results in my analysis Content (please ensure you mask any confidential information): I have this dashboard. If I filter for year 2024 my analysis … -
Recruiting Real time Subject Area - Candidate Pool missing data?Summary: Hi Experts, I’m wanting to create a Candidate Pool analysis report using the Recruiting Real time Subject Area. I cannot find a data field to capture the start …
-
BI Publisher for word is stuckSummary: BI Publisher for word is stuck Content (please ensure you mask any confidential information): Hi, BIP for MS Word has stopped working and the application is get…
-
Need to Split Job.Job Name into 3 different fields - Primary, Secondary, TeritiarySummary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as Primary Secondary Tertiary Unmapped Unmapped HEAD OF AGRICULTU…
-
Admin tool or (other method) to identify all OTBI Subject Areas that my company can accessSummary: Is there an admin tool (or other method) to identify all OTBI Subject Areas that my company can access? Content (please ensure you mask any confidential informa… -
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in… -
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic… -
Performance Rating DetailsSummary Performance Rating DetailsContent Experts, Whether HRT_RATING_LEVELS_B will have the performance rating details or some other table. Would like to know the table… -
Recruiting Custom Posting Description Fields Query / SQLHello Experts We need to fetch in a query posting descriptions, for internal and external posting, that were entered by the Manager on Job Requisition Creation > Recruit… -
how can we export the questionnaire question response comments in Performance Document?Summary: how can we export the questionnaire question response comments in Performance Document? Content (required): we are now using a quesition to get the feedback fo …
-
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…
-
Need to find table to get all Bank account related informationTeam, i need to fletch all the data related to bank account , can you please suggest which table suits ? Thanks
-
Not able to find Name Field in the subject area OTBIHello Experts, Please help, where can I find the Name Field, I am currently using Human Capital Management - Transaction Administration Real Time, should I need to use a…
-
Top 5 reasons for sicknessSummary: Hi, Has anyone got any ideas how i can get top 5 reasons for sickness and display the same as a % of the total absences? Also how to achieve the top 5 reasons a…
-
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)
-
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…
-
Trans ID is null for Approval Notification Archive Real Time when business process=Approve Job RequiSummary: We are trying to combine requisition subject area(Recruiting - Recruiting events real time) with transaction console(Human Capital Management - Approval Notific…
-
User History ReportSummary: Is there any standard report in Oracle Fusion which provides details of when users were added? I know there's a 'User History Report' - but that needs to be run…