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
-
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which … -
Dynamic Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question…
-
OTBI - values turning to blank after more columns are addedSummary: I have built a report that combines two subject areas: Compensation - Salary Details Real Time and Payroll - Element Entries History Real Time The report is sho…
-
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri… -
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C… -
Can we load the Worker by Passing the LegalEntityId not the Legal Employer Name via HDL ?Summary: As we have a requirement to load the Worker (Person, Person Name and Assignment for new record) via Legal Entity Id not the Name. Can you please suggest any way…
-
Report is taking some time to reflect changed dataSummary: We are noticing that reports in Oracle Fusion HCM are taking considerable time to reflect updated data. For example, when changes are made in the application or…
-
We tried to use Reflect Changes from Edited Reports Sooner solution in fusion but it is not workingSummary: Hi team we have made the changes in the PR PO Approval Pages as per our requirement. We need to test the output. As a standard functionality system will take 24…
-
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…
-
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am … -
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative … -
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
How to create a report that includes employee information and the date of the last system access.?I'm trying to create an analysis with the last access information of employees to Oracle Fusion Cloud and I'm having trouble. Could you help me retrieve this date in the…
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…
-
Employee with Bank Account but no Payment Method ReportSummary: I have a report that picks up all employees that do not have a bank account and a payment method active, but how do I pick up employees that have a bank account… -
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one… -
Need a sample SQL for HDL Business Object Details ReportI'm trying to create a HDL Business Object Details Report, where I wanted to fetch the Name, Label, Required and Lookup fields which I'm unable to find the exact table. … -
Zip File for 'Identifying Authorized Hosted Named Users' no longer available?Summary: Hi, I used to be the primary person managing Oracle Licenses and would utilize the 'Identifying Authorized Hosted Named Users' reports which provided the follow… -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…
-
Link learning evaluation questionnaire to learning assignment in Bi publisherHello, I have a requirement in BI Publisher in wich I need to extract the answer of a specific question from the offering evaluation (in learning) My base is that, howev…
-
Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tablesSummary: Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tables. Content (please ensure you mask any confidential information): We have established a link betwe…
-
We are not getting qstn_answer_id value in the HRQ_QSTN_RESPONSES tableSummary: We have some set of questions in the questionnaire for the performance document and when the user provides the response a row is getting generated in the HRQ_QS…
-
Top Employee Missing from HierarchySummary: Our top employee is not appearing in reporting when the organisation hierarchy is included in a report. Content (required): The head of our organisation current…
-
Fusion Data Intelligence - Data inconsistent across delivered workbooksSummary: After converting workers, I tried running the delivered workbooks. I am getting different data in them. The Team composition overview shows a total headcount of…
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g… -
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid…
-
BI Publisher Preview Options not enabledSummary: BI Publisher Preview Options are not enabled. Content (please ensure you mask any confidential information): We are trying to update our RTF template and the Pr… -
Trend report for Disability and Sexual orientationSummary incorrect calculations when trend subject are is joined with Person real Time Subject are.Content HI, I am having a requirement to show the trend of sexula orien…
-
Discrepancy in Actual Effort Displayed on Screen vs. CertificateHello, I noticed an inconsistency in the Oracle Fusion Cloud Learning system regarding the “Actual Effort” metric after completing training. On the learning screen, the …
-
The HCM Hire transaction shows as Completed (green), but the approval flow appears emptyThe HCM Hire transaction shows as Completed (green), but the approval flow appears empty. However, the History section displays the correct approval flow. The transactio…