Data Models
Discussion List
-
Is there a column in Per_all_assignments_f which can tell us the source for the assignment record?We can do internal movements via core hr and OCR. How do we which assignment is updated via OCR or Core HR? As part of recruitment the assignment type is created as 'O'.…DevasishG 21 views 3 comments 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management -
Fetch Salary LogsSummary: Hello, We have a requirement where we need to understand if we have standard dashboard or report where we can get the logs of all the users who are accessing sa… -
Can a worker historical conversion be done AFTER loading top of stack?Summary: We have been trying to extract and convert historical worker information for several months, but continue to have problems with extracting the data in such a wa…
-
Report related detailsHello, We want to know details for the one of the BI report, how we can find below details, do we have any Query to check all details for the BI report. Report Name, Fol…
-
Extensible Flexfields not auto populating on basis of SQl QueryHi There, I am trying to auto populate Extensible Flexfields through sql. This sql contains recent action code transaction and shows its Effective Start date. In order t…Aviral Tripathi 102 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
we want to mask all NID Details how to do this anyone have any idea on thisSummary: we want to mask all NID Details how to do this anyone have any idea on this Content (please ensure you mask any confidential information): Version (include the …
-
Create a Department Hierarchy - Organizational Tree or Department Tree?Summary Create a Department Hierarchy in Oracle HCMContent Hello everyone, Currently we are using the Organizational Tree area of Oracle HCM to drive security, meaning t… -
Mapping of Seniority dates after V3 Seniorty Dates migrationSummary: We are using PER_PERIODS_OF_SERVICE table's - ORIGINAL_DATE_OF_HIRE( as Enterprise Seniority Date) & ADJUSTED_SVC_DATE (as Legal Entity Seniority Date). After V…User_2025-07-18-06-45-42-477 145 views 3 comments 0 points Most recent by Nidhi515 Human Capital Management
-
Table to get all the historical changes done in an employee recordSummary: We want to get all the changes done in an employee record. Could any one help us in getting the right table to fetch all the historical changes done till date i…
-
User Category Notifications - email to HR RepresentativeSummary: User Category Notifications. Is it possible to send an email to the HR Representative once an user account has been created for an employee? It seems like there…Consultant Ian 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management -
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
BI Report Logo not displaying when exporting report to MS WordSummary: BI Report Logo not displaying when exporting report to MS Word. Content (please ensure you mask any confidential information): I have created a BI report. I use…IanDeKoker 59 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM -
how to get the communication methodsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to change application logo dynamically based on LE mapped to the user who login the application?Summary: Customer has logo for each of the legal entity and have requirement to change application logo dynamically based on LE mapped to the user who login the applicat…
-
unable to change incorrect date of birth and Hire date of few employeesSummary: For few employees the date of birth needs to be changed, when i try it through the application or HDL, it shows the error "You need to enter a date of birth tha… -
Change Salary/Admin Salary Transactions fail with BPM rule or approval issueSummary: we have noticed an issue with Change Salary/Admin Salary Transactions fail due to BPM rule or approval workflow is not triggering and failes Transaction. up on …
-
Dashboard data time to fillSummary: Hello Everyone I have issues with the dashboard data we have a total of 11 offer "time to fill", but when we filter with 2024 it shows only 2 offer letters. Can…Krishna Sigilipalli 21 views 2 comments 0 points Most recent by Krishna Sigilipalli Recruiting, Opportunity Marketplace
-
HCM Extract Completed with Alerts StatusSummary: Production Issue : We scheduled one of HCM Extract, which is completed with alerts error status. The generated log is showing FUNCTIONAL_ERROR at post processin…
-
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.6K 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 212 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…