Data Models
Discussion List
-
Are document records stored in a server?Summary: Hi Community, Our client is transitioning from PeopleSoft to HCM Cloud. Currently the documents they upload are stored in a File Server in PeopleSoft. Are Docum… -
How is data capture in HCM Events TableSummary: We want to understand how is data captured in HCM Events Table & How does it differ from Audit Table ( which is table with_ at the end)? Can anyone share any in… -
N/APost created by mistakeHumberto Martín-Oracle 11 views 0 comments 0 points Started by Humberto Martín-Oracle Human Capital Management
-
how to change date format un bipSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Query to get the tax name and rate from a draft invoice under contractI need to retrieve the tax name and tax rate applied on the draft invoice (without calculating it manually) under contract management. In the tables pjb_inv_line_dists a…
-
How to get the value from the UDT for the Custom field DFF?Hello Experts, We're adding a Custom Grade Ladder through a Descriptive Flexfield (DFF), where the values originate from the UDT. The expected outcome is that selecting …
-
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-Support-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 101 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 …
-
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sqlSravan Kumar Meka 1 view 0 comments 0 points Started by Sravan Kumar Meka BI Publisher Learning Center
-
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 151 views 3 comments 0 points Most recent by Nidhi515 Human Capital Management
-
BI Publisher Report- Learning Initiatives including Course number and Title-LearningHello All, I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do …Thulasi Ram 132 views 8 comments 0 points Most recent by Soare Oldrich Alexandru-Oracle BI Publisher Learning Center -
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 41 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 51 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
-
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the…
-
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…
-
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…