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
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g… -
Issue in fetching review_user_access column from PER_ALL_ASSIGNMENTS_M tableI’m trying to fetch the REVIEW_USER_ACCESS column from the PER_ALL_ASSIGNMENTS_M table in Oracle Fusion HCM, but I’m not seeing it populated. While terminating an employ… -
Restrict line manager access to report on direct reports DOB and Address InformationSummary: Hello, We don't want our line managers to report on their direct reports DOB and Address information. We tried to use data security profiles to restrict access …
-
Candidate Extensible Flexfields recruiting for Job Application specific candidate profileSummary: Hello - 26A release the ability to report off Candidate Extensible Flexfields in OTBI subject area - Recruiting - Recruiting Real Time under the Candidate > Can… -
Could you please provide information on where I can access the standard Time and Labor reports?Summary: Time and Labor Reports. Could you please provide information on where I can access the standard Time and Labor reports? I am specifically looking for reports th…
-
Sql query to get reporting unit hcm information data - tax reporting unit -French Establishment InfoSummary: Hello, We need to extract data in BIP for the reporting unit hcm information data - tax reporting unit -French Establishment Info. Does anyone have more details…
-
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data… -
Accrual Plan Balance value for the future dateSummary: We are trying to fetch the accrual Plan Balance value for the future date records. Content (please ensure you mask any confidential information): As of now, we …
-
"Preview Offer" feature in HTML does not show correctlySummary: The "Preview Offer" task shows the Offer Letter in different formatting on different parts of the page when previewed in HTML. However, when downloaded in PDF f…
-
How to Trigger Bursting Email to Employee with 2 Attachments Along with Email BodySummary: Hi, We have developed a custom bursting report which has Email body configured in Parameter5 and single pdf attachement is generated based on rtf template. We g…
-
Strategy to keep users from accidentally moving folders/reports on the Catalog pageHello. Asking if anyone has a proven strategy to address the risk of a report user, on the Catalog page, accidentally moving folders or reports from their original locat…
-
Oracle criteria to identify BIP reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our BIP reports which are using ‘ORIGINAL_DATE_OF_HIRE’ column from 'P… -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl… -
Table to Extract Vacation Rule DelegationSummary: Hi, I want to extract vacation rules created in HCM Fusion. I have found table that stored vacation rule in Oracle Apps but can't find equivalent table in Oracl…
-
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed …
-
How to extract the details of the Employee and there Line Manager / Supervisor details ?Summary: Hello All, We are trying to extract the details of the Employee and there Line Manager / Supervisor details for all the employees. Is there any Standard report … -
HCM subject area "Workforce Profiles - Library Objects Real Time" join questionHello. Any advice on how to join the HCM subject area workforce profiles - library objects real time to workforce profiles - person profile real time ? Not finding commo…
-
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…
-
Unable to change the End Date of an element entry via HSDLSummary: We have created an HSDL template to Create/Update element entries. The template is working in all scenarios, except where we are trying to change the end date o…
-
SQL query to extract UDT tableHello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following. Can anyone suggest a …
-
Oracle HCM: How to change existing Host Key Fingerprint in BI AdministrationHi Team, We have a requirement to change the Host Key Fingerprint because of change in SFTP hostkey due to recent changes within SFTP application. Are we able to change …
-
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report … -
OTBI Report Access Issue – “Workforce Management - Processed Time Cards Real Time” Subject AreaHi Team, We are encountering the attached error when a user attempts to run an OTBI report developed using the subject area “Workforce Management - Processed Time Cards …
-
How to add custom archival data to the GTN report?Summary: A customer needs to add custom deductions to the Gross to Net summary report, just as they can in the Payslip, which include this feature. The XML does not cont…
-
FDI attributes without Start & End date includedWhen creating reports in FDI, we find attributes that are present in the subject area but the attributes Effective Start Date and Effective End Date (and sometimes other…
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
Interaction tab information is not being stored in retained candidate profile after merge processSummary: I am facing an issue related to candidate merge behavior in Oracle Recruiting and would like to confirm whether this is expected functionality or a limitation. … -
OTBI Historical Talent RatingsHow do we report on Historical Talent Scores (Potential) in OTBI? I see that Workforce Talent Review - Talent Review Meeting Real Time subject area can be used to report…
-
FDI - Custom Security Context LOV returns row-level values instead of value-based valuesHi, We are currently implementing the security configuration in Oracle Fusion Data Intelligence (FDI). In addition to the 5 standard Security Contexts available, we need…