Data Models
Discussion List
-
Change Working Hours approval notification template shows old template in RedwoodSummary: Change Working Hours approval notification template shows old template while submitting via Redwood UI . Showing correct template while submitting via Responsiv…M Santoshi-Oracle 38 views 7 comments 0 points Most recent by Maria Smith- de Novo Solutions Human Capital Management -
Tables store transaction console approver name showing as AssigneeSummary: Tables store transaction console approver name showing as Assignee Content (please ensure you mask any confidential information): Hi, I'm looking table name whi… -
Under HCM only license, capture Department Costing under GL Cost Centre.Under HCM only license, can we capture Department level cost under 'GL Cost Centre' ( Which is used by ERP) ? And if we do would we have any downstream implications? Als…
-
SQL query with BIP tables which gives Approval details for Compensation worksheet in Fusion hcmHi Team, We have requirement with below approvals on Compensation worksheet. The initial manager submits the request. The initial manager’s manager provides the first le…
-
See department tree status in tableHi, We want to see the status of our department trees in a data model. In what table could we see this?Nick H 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
BI Audit Report/Tables connection errorSummary: We are seeing below error when user is trying to run a BI Report which fetches data from fusion iau viewer.bipublisher_v table to capture report access timeline…Venkatesh TR 11 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Clarification Required on Seniority Dates Data Fetching in Oracle HCM BI Report.Summary: A person having 2 Seniority entries- one for worker type as "Pending worker" and other for "Employee" is existing for below Seniority codes- "Legal Employer Sen…Amit Khadakabhavi 23 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Human Capital Management
-
How to see pending or rejected transactionContent HR transactions are submitted by HR (like Change Department on Assignment or Increase Salary) ,until the transaction is approved ,anyone would not able to see it…
-
BIP report to extract approval history and transaction historySummary: BIP report to extract approval history and transaction history for JRs Content (please ensure you mask any confidential information): Hi all, I need to create a…
-
In Redwood Resign from Employment-Termination details not displaying in Approval notificationSummary: We have migrated to Redwood V3 Resign from employment. when the Employee Resign from Employment, the approval goes to the Line Manager and HR VP. Though they se…Saranya B-Oracle 87 views 2 comments 0 points Most recent by Saranya B-Oracle Human Capital Management
-
New Field Added but no data in the field in the HCM Workflow approval Termination reportSummary: Following below document i was able to add a field to the standard report, but could not fetch the data in that field. (Doc ID 2647434.1) Data Model of this rep…
-
Transaction Console WorkFlow notifications(FYI And FYA) in HCMHello Everyone, we have a few requirements from customer regarding the changes in FYI- For You Information and FYA-For your Action notification templates which user rece…KarthikDamamkar 11 views 2 comments 0 points Most recent by KarthikDamamkar Human Capital Management
-
Value Set Query to Get Unique Assignment DetailsHi Team, Need input on Value set Creation to get unique assignment details out of multiple rows. Currently, I am using the below query which gives me 2 rows, due to same…
-
Issue with “View Document” in Documents of Record – PDF Download ErrorHi Team, Whenever we try to add Documents of Record and click on View Document against an employee, the PDF report should download, but it is throwing an error message. …Mahi-Oracle 23 views 1 comment 0 points Most recent by Shweta Ganguly-Oracle Human Capital Management
-
how to get assignment work terms number in fusion data intelligence oac fdiSummary: how to get assignment work terms number in fusion data intelligence oac fdi Content (please ensure you mask any confidential information): how to get assignment…RajaGangavarapu 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
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 116 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 37 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 23 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 292 views 5 comments 0 points Most recent by Valentina_Mih-Oracle Human Capital Management
-
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 22 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…