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… -
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 … -
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… -
SQL query to fetch all notifications/emails sent by Fusion.Summary: We need to extract all worklist notifications/Approval/email notifications that are triggered in Fusion within a specific time range. Has anyone ever worked on …Piyush Pokharkar-Oracle 2.5K views 10 comments 1 point Most recent by MandeepGupta Human Capital Management
-
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 19 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/…
-
Impacts on Tables post enabling redwoodHi Team, In lower pod, we have enabled Redwood Profile options and we would like to know about the impacts on the tables, viz we have come across a scenerio wherein for …
-
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 13 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 32 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 5 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 17 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 21 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 …
-
DoR Approval Notification: ‘Date/Time’ Flexfield Displayed in UTC Time instead of Iraq Time (UTC3)Summary: Document of Record Approval Notification : Flexfield of Data Type ‘Date/Time’ Displayed in UTC Time Zone instead of Iraq Time Zone (UTC+3) Content (please ensur…
-
SQL Sample Query for Native Electronic SignatureI am looking for help on modifying the SQL query I'm using in a data model for the native electronic signature task type. I'm looking to add a parameter for job title an…
-
How to create a document of record from a BI report and add it to employeeSummary: we have a bussiness usecase to add service certificate as document of record in the employee document of records. We already have a BI report which is sending s… -
Is there a table where I can find the name of a deleted Document of Record attachment?Summary: Hi. I'm trying to create a custom audit report that lists any attachments that have been deleted from a Document of Record type. I can't seem to find any table …
-
What are these apps and what is the use of itApps Available Under Others Tab What are these apps : Resource Directory and My Dashboard What roles have access to them?Mohammed Khair 2 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Is it possible to add the Parent Position Code Field to the Workflow Notification/Approval window?Summary: Is it possible to add the Parent Position Code Field to the Workflow Notification/Approval window that is generated from the delivered Workflow Notification Dat…
-
need HDL to load workday definitionSummary: after clicking on working hours(i have marked as yellow) this assignment hour details comes, for that we want HDL to load workday definition is there any templa…
-
BPM Worklist Transaction Report based on BPM worklist transaction statusHi, We are building a report to pull the list of transaction from BPM Worklist including Transaction information, Person information, assignment information along with a…Haryi 65 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management