Data Models
Discussion List
-
How to read content of attachment of Document of RecordSummary: How we can read the content of attachment attached to DOR. Content (please ensure you mask any confidential information): We have requirement to read the conten…Alpesh Sanghvi 21 views 1 comment 0 points Most recent by Monica Boita-Oracle Human Capital Management -
Report parameterized with person_id inside journeySummary: Content (please ensure you mask any confidential information): Hello everyone We're experiencing issues with a report to be included in a guided journey. Specif…Gerardo Peluso 21 views 2 comments 0 points Most recent by Gabriele_Cristofalo Human Capital Management
-
How to Convert Contigent Worker into EmplyoeeSummary: Hi Experts, Please confirm. How can we convert a Contingent Worker into an Employee? and after conversion, the contingent worker history is maintained in the sy…
-
Validate transaction console complex triggered approval rule on a completed transaction.Summary: I'm looking to review completed transactions details to see that the correct approval rule has been triggered in the change salary transactions we have had subm…Georgia Puddifoot 11 views 0 comments 0 points Started by Georgia Puddifoot 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 43 views 2 comments 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Human Capital Management
-
How can we store a BI Report (PDF) in the Document of Records without using HCM Extracts?Summary: We have configured a journey for Associates in which they receive a document as part of their task allocation. When an Associate is assigned a task, a correspon…
-
CreatePosition rtf template- DFF not showing in notification templateSummary: Hi Experts, We are trying to add custom DFFs in the CreatePositionrtf template. We modified the template but the DFFs attributes are not showing up once the pos…Revathi Thangaraj 21 views 4 comments 0 points Most recent by Revathi Thangaraj Human Capital Management
-
SQL Query to fetch all Notification details (approval, fyi and reminder notifications).Summary: Need SQL Query to build a Report to fetch all Notification details (approval, fyi and reminder notifications) sent in 2024 for some particular employees. The re…Saurabh Maheshwari 781 views 5 comments 0 points Most recent by Jamie Walsh Human Capital Management
-
Is there any consolidated excel available module wise listing all deep links till 25CSummary: Hi Team, Need the complete list of deep links available in oracle fusion till release 25C. Is there any document available for the same or is there a way we can…
-
Is there a DM Table or Subject area to track log in timesSummary: Is there a DM Table or Subject area to rack log in times Content (please ensure you mask any confidential information): Version (include the version you are usi…
-
Job Requisition Notification is emptyWe have a problem viewing the content of the Job Requisition notification content from the bell icon or in the worklist. It went through an approval cycle to be approved…Mayar Mohamed 22 views 1 comment 0 points Most recent by Emil M-Oracle Recruiting, Opportunity Marketplace
-
How to create Alert Composer filter with a fixed date?Summary: How to create Alert Composer fileter with a fixed date? Content (please ensure you mask any confidential information): Hi experts, I cannot get it to work. Is t…Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov 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.M-HCM 13 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce 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…
-
Table of position request changeHello, We'd like to know if anyone could help with a table or query that might might help extract data in the Position Request Change in the below screenshot. Thanks
-
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 …Saksham S 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
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…
-
SQL to fetch the status of performance documentHello Experts, I am currently working with a BIP report and can't find this status field of performance document, Does anyone know where or what table should I pull this…
-
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) https://support.oracle…KarthikDamamkar 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
V3 Seniority Date HDL file for manually adjusted datesHi Experts, We ran "Seniority Dates V3 - Remove Seniority Dates Transaction Data" Diagnostic process to removes seniority date for the certain configured rules. While ru…
-
Is there a way to dynamically pass the instance name (PROD, TEST, or DEV) into the Alert Composer?Summary: Is there a way to dynamically pass the instance name (PROD, TEST, or DEV) into the Alert Composer body? Content (please ensure you mask any confidential informa…Volodymyr Faranosov 1 view 0 comments 0 points Started by Volodymyr Faranosov Human Capital Management
-
Need Table details storing User information created in Security ConsoleSummary: We need to get the information of User like First Name, Last Name, username and email id of the user created in Security console. Content (required): Person inf…
-
SQL TO GET REQUEST FOR MORE INFORMATION TRANSACTION DETAILS in Absence Transaction in FUSION HCMHi Experts, I am looking for SQL to fetch the Request for more Infomation by Approver in Absence Transaction in oracle fusion HCM. Please let me know the tables or SQL R…
-
We Need to build BI Report in Oracle HCM to fetch parameter used in BI Report.Summary: We Need to build BI Report in Oracle HCM to fetch details of BI Report such as Report Name, Report Path, Parameter, submitted by, If it's schedule or ran manual…
-
sample query to fetch contingent workers along with their locationSummary: Can I get a query that fetches all the list of CWK and their associated BU,LE & Locations ( Active Assignments ) Content (please ensure you mask any confidentia…Mohammed Ehteshamuddin 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
Sample query to fetch person detailsHello, Can anyone please provide a sample query that would fetch "Person Name, Person Number, Assignment Status, Location, Person Type, Business Unit, Legal Employer", J…Mohammed Ehteshamuddin 21 views 1 comment 0 points Most recent by Nivya Mathire Human Capital Management
-
Need columns 'Destination Quick Move Phase' and 'Destination Quick Move State' in BIP ReportSummary: I want following columns in a BIP report - Process Name, Phase, State Name, Destination Phase, Destination State and Comments. I am able to fetch all except des…
-
Need columns 'Custom Filter's Context' and 'Add Custom Filter' in BIP report from Career site - IRCSummary: I am building a BI query to take out all the basic details of career site, here, I have requirement of two more columns 'Custom Filter's Context' and 'Add Custo…
-
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 … -
How to Track Article View Counts in Oracle Fusion Knowledge Management (Self-Service, Email, SR)?We are using Oracle Fusion Service Cloud (Knowledge Management) and would like to understand how to track article view counts across different channels and roles. Specif…