Data Models
Discussion List
-
How to get the Work Terms Number for an assignment?Summary I am trying to use HSDL for correcting assignment information for some employees which requires the Work Terms Number and i am unable to find it outContent I am …Srikanth Ramaraju 6.8K views 9 comments 2 points Most recent by Parag Hiremath Human Capital Management -
Can I retain reports or reports data when a module is retired?Summary: Can I retain reports or reports data when a module is retired? We have a requirement to access OTBI reports after a module is retired. Can we capture this in OC… -
Offering Start DateSummary: How to get Offering Start Date in HCM Query? Content (please ensure you mask any confidential information): I have a report in development and we are missing of… -
24A BIP report performance issueSummary: We have created 2 reports (w4Federal and ADP Reconciliation) and this two reports completed with in 5 min before 24A patch. Now these reports taking more that 2… -
Projected Start Date SQLSummary: I am looking to create a configurable form DFF field that pulls in a constant SQL for a worker's projected start date (specifically to use on a Journeys task). … -
How to read content of the DOR attahmentContent (required): Hi, How can we read the content from DOR attachment? We would like to get the content of DOR attachment in report. below query gives me UCM id and fi… -
How to customize resignation email notificationSummary: We want to customize resignation email notification based on status of resignation. If Employee has submitted resignation, manager should get email notification…Arpit Dhalawat 230 views 1 comment 0 points Most recent by Cristina Greyling - Oracle-Oracle Human Capital Management -
Employee is unable to complete e-signature task of a checklistSummary: Content (please ensure you mask any confidential information): We have configured a checklist with a e-signature task within it. We have configured a report to … -
PROPOSED PERSON TYPESummary: Hi Team, Does anyone know what table can I get the value for Proposed Person Type? Thanks Content (please ensure you mask any confidential information): Version… -
Need help in getting XML for delivered manage DOR post approval reportSummary: Hello team, we are currently in Post Go live support and client wants us to modify the notification template for DOR workflow. To proceed with the requirement w… -
Which template should I use Excel or RTF for delivering a report (Parent-Child relationship).Summary: The report is related to Learning Module where I have to deliver Course Name and its offering Name, additionally the activity associated with it. Now all these … -
Not all changes made on RTF are reflecting on workflow notificationSummary: Not all changes made on RTF are reflecting on workflow notification Content (please ensure you mask any confidential information): I have made a copy of the see… -
Best way to map UI field with BackendSummary: Those who are from EBS background would know that using About this page-VO details , we can see backend table for UI fields. In fusion, what s the Best way to m… -
Is it possible to attach a document to the bursting email?Summary: Is it possible to attach a document to the bursting email? Content (please ensure you mask any confidential information): Is it possible to attach a document to… -
Enabling Seniority Dates Audit - Performance Impact/ConsiderationsSummary: We received a use case to enable Seniority Dates audit via business objects for Global Human Resources. We are in need to identify if by enabling this object/au… -
Can we segregate Document Records with Remove Person Information ToolSummary: Can the 'Remove Person Information Tool' segregate specific document records? Content (please ensure you mask any confidential information): We have a client wh…Ivy__Valverde 31 views 3 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
How to get Approver Information for completed and In Progress transactionsSteps Followed 1)Initiated Transfer Process from Manager login for an employee(My teams>>My teams>>Transfer) 2)Login as Approver1 and Approved the workflow notification …Rama Krishna Annam 21 views 7 comments 0 points Most recent by Parag Hiremath Human Capital Management -
OTBI Transaction Analysis Real Time to BIP ReportSummary: Hi all, I'm trying to create a BIP report with all history transactions. I see that in OTBI Analyis there is a field "Process Category" that I can't find in the…teresa.marciano 11 views 4 comments 0 points Most recent by Vikash K-Oracle Human Capital Management -
Can we display transaction ID in the approval emailsSummary: Can we display transaction ID in the approval emails. If a DOR is submitted, approvers will get email or notification with task number. How can we display trans… -
Customizations done on AssignmentResignationReport is not showing on Resignation notificationsSummary: Customizations done on AssignmentResignationReport is not showing on Resignation notifications Content (please ensure you mask any confidential information): I … -
How to get the source of user login(Mobile/Browser)Summary: We are looking for improving the Application usage by all staff and hence wanted to track the login frequency and source of login ( Mobile/Browser). We are able…Pavan Kumar Thummalapalli 71 views 1 comment 0 points Most recent by MandeepGupta Human Capital Management -
Error when loading HDL for WorkerHello experts, An employee is still appearing as the incumbent of the Position even this employee have already a different position. We discovered that the reason of thi…Maria Cristina L. San Jose 103 views 3 comments 0 points Most recent by Marius Voicu-Oracle HCM Data Loader (HDL) -
The values 20 aren't valid for the attribute PersonId.Hi I am getting the following error when trying to assigned the JOB roles for existing employees using the HCM Spreadsheet template: The values 20 aren't valid for the a… -
Please help share SQL to extract all oracle fusion hcm setup configuration with data.Hello All, We want to have a download of Config Workbook from the POD,but Configuration Package and Implementation Project setup isnt working as expected. Please help sh… -
Sql query to extract list of all HSDL spreadsheets along with parametersSummary: Hi Team, We are looking for a sql query / table name / any other way, to extract a list of all the HSDLs that we have in our pods (irrespective of whether they … -
how to fetch primary key of each table in fusion hcm??Summary: Hello all, how to fetch primary key of each table in fusion hcm??Chandra Kiran Ushakoela 31 views 1 comment 0 points Most recent by Parag Hiremath Human Capital Management -
Need table name which stores HCM Extract Report CategoriesSummary: Need table name which stores HCM Extract Report Categories Content (please ensure you mask any confidential information): Version (include the version you are u… -
Position Cost Center Mismatch validation errorSummary: When we try to update the position we get Cost center mismatch error but historically it allowed the mismatch to bypass. Hence wanted to check when was the vali… -
an inactive employee is visible from front end but no present in Secured views?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Create an employee using rest apiDear All, I am attempting to create an employee using the following REST API: /hcmRestApi/resources/11.13.18.05/workers. Here is the request body: { "DateOfBirth": "2023…