Data Models
Discussion List
-
HSDL Template to load DFF values in Employment pageSummary: Hi Team, We have configured the DFF value in the Employment page,and need to load the values to list of associates. We tried using HDL Template to load but when…Madhavi konduru-Oracle 97 views 10 comments 0 points Most recent by Ravi Tilekar Human Capital Management -
Which attribute stores the Term correction reason for reportingSummary: We are trying to build a report to fetch the reason change that was entered as part of Termination correction, but we do not see any table storing this update m…Tumpa Mandal 11 views 5 comments 0 points Most recent by Cristina Greyling - Oracle-Oracle Human Capital Management
-
Transaction console data along with the approver name.I have created a report to fetch the all the transactions details from the transaction console, along with the transaction id , process name and approvers name and some …Jagruti2408 38 views 1 comment 0 points Most recent by B S Rafatullah-Oracle Human Capital Management
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
HCM Talk Radio: Localization Best Practices in HCM CloudSummary HCM Talk Radio: Localization Best Practices in HCM CloudContent Are you interested to learn more about localizations and translations in Oracle’s HCM Cloud Servi…Frank Cowell-Oracle 52 views 2 comments 0 points Most recent by Frank Cowell-Oracle Human Capital Management -
Is there a way to see what tables/views have data and which ones are empty in Oracle Fusion HCM?Summary: This is for archiving data from the production system. We are moving to SAP SuccessFactors so need to know data is stored in which tables/views. We are looking …
-
Report on Action Reasons per action and associated taskSummary: Our action reasons need to be reviewed so I would like to be able to report on the existing action reasons that are available for each action and ideally what p…
-
Need SQL Query/ table names to get termination and reverse termination details of an employeeSummary Need SQL Query/ table names to get termination and reverse termination details of an employeeContent Hi All, What I need is to get termination and reverse termin… -
Learn Module SQL Query to get assessment QuestionnaireCreated the attached SQL to fetch the Learn Module SQL Query to get assessment Questionnaire. But Questions Text and Answers are blank. What am i missing?Harish B Choctaw 27 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Create user account using rest apiDear All, I am attempting to create a worker using the REST API (/hcmRestApi/resources/11.13.18.05/workers). It automatically generates the user, but when I set the user…
-
Query to fetch HR Representative personHello All, Need to fetch data either by using BIP or OTBI, HR Representatives associated to a Person. I am able to fetch AOR's Associated to an Employee, But the require…Satish Golla 240 views 5 comments 0 points Most recent by Valentina_Mih-Oracle Human Capital Management
-
Deeplink to vacation rule pageSummary: I have created an alert that is sent to the employee as soon as his/her absence is approved. The alert reminds employees to create a Vacation Rule before going … -
HCM Tables and Views MetadataSummary: Oracle has the below website with table and views metadata for HCM. How can I get this metadata as json files or another metadata format other than the browser … -
Issues with OTBI while extracting Person contact InformationSummary: We are developing a demographic report using OTBI in which we need to display Person contact information such as Contact Tel. # and Address. However, we are fac…
-
Segregating the success and error report to different email id through SOAP UI Request PayloadSummary: I did a POC , using the SOAP UI Payload request i'm able to get the email notification to multiple emails. but the expectation was like for success report we wi…Ankita Mohanty 21 views 0 comments 0 points Started by Ankita Mohanty Reporting and Analytics for HCM
-
SQL to get Checklist Status for EmployeesSummary: SQL to get Checklist Status for Employees Content (required): If we have a requirement to get Checklist status for Employees, below SQL can be leveraged. Versio… -
Role Discrepancy in PER_USER_ROLES Table for Terminated EmployeesSummary: We observed that for a few terminated employees, roles appear to be assigned in the PER_USER_ROLES table when pulling through the report, even though the fronte…Pranav Kakaraparthy 16 views 3 comments 0 points Most recent by Parag Hiremath Human Capital Management
-
DBI'S and Functions related to workforce scheduling module.Hi Team, I would want to know all the DBI'S, and Functions related to workforce scheduling module to use in our custom fast formula to get working days and all.
-
Hide Seeded line manager dashboardSummary: Hi everyone, We’re aiming to hide the seeded Line Manager dashboard from managers. However, since it’s a delivered (seeded) dashboard, we’re unable to restrict …
-
Need an sql query to get the latest leave approver or assignee details from transaction consoleHi Team, I am unable to get the approver or assignee details from the below tables 1. fa_fusion_soainfra.wftask 2. fnd_bpm_task_history_b So Please provide an sql query/…
-
Redwood Identification info - Condition not workingSummary: Hello, According to the Documentation from 25A release, we should be able to use Citizenship and issuing country as condition attributes, if we need to create r…
-
BI query to find the count of Failed, aborted and recovered transactionsWe are working on the list of Failed, Aborted and recovered Core HR transactions. We were able to get the failed and aborted transactions list with the available status …Kavya Sreenivasulu 14 views 2 comments 0 points Most recent by Kavya Sreenivasulu Human Capital Management
-
Kindly help me with SQL Query to get Hire Date of an employeeSummary: Kindly help me with SQL Query to get Hire Date of an employee If an employee has been only globally transferred, query should return enterprise hire date If an …AS 102 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
security role validationSummary: Content (please ensure you mask any confidential information): We have two instances presently test and a dev instance, the dev instance was recently refreshed.…Aishwarya_Saju 2 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Need sql query to fetch approvers list of a transactionSummary: Hi There, I have a requirement to fetch all approvers' names of a transaction, If any one have report for this requirement, please share. Thanks, Lakshmi Conten…Lakshmi Devi Bathala 27 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Document of records - How to define primary attachmentSummary: Hi all, The business requirement is to attach multiple attachment to the same document of record. Only one of the attachments is considered primary by the busin…teresa.marciano 22 views 5 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
how can I know who has updated the profile option last?Summary: Hi Team, how can I know who has updated the profile option last? Is there any SQL query for this? Content (please ensure you mask any confidential information):…
-
Kindly help me with SQL Query to get contact (Spouse and Child) information of an employeeSummary: Kindly help me with SQL Query to get contact (Spouse and Child) information of an employee Content (please ensure you mask any confidential information): Versio…
-
Query (sql) that brings the sequence logic the cost center in budget detailsQuery (sql) that brings the sequence logic the cost center in budget details How to query (sql) that brings the sequence logic of the information in this part of the cos… -
Position Override Flag Changing After HDL LoadSummary: Hello, We are doing a full load for UAT. I have position override set to Y for all active workers. Yet when I load the data it changes to N for some. WHY?? And …