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
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an… -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,… -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …
-
Assistance Required: How to obtain the history of when a role is assigned and revoked to a userHi Team, For audit purposes, we’d like to know if there’s a way to track when a specific role was assigned to a user and when it was revoked. Currently, we can only revo…
-
How to obtain the history of when a role is assigned and revoked to a userSummary: Hello All, As an Audit Requirement we need the complete history of when access is provisioned to a role and it is revoked. The following table ASE_USER_ROLE_MBR…
-
Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…
-
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report … -
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 …