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 7.6K views 10 comments 2 points Most recent by Cristian Ariel Arakaki Human Capital Management -
Salary Certification - QR code generationSummary: We have a requirement from the customer to generate a salary certificate letter from Oracle Fusion HCM that includes approval. The letter must include an auto-g…
-
Can we reuse the PER_IMAGES table to store signature images by defining a custom IMAGE_TYPE?Summary: We need to store employee signature images in Fusion so that we can retrieve them dynamically in BI Publisher PDF and Excel reports. Since UCM images are no lon…
-
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):…
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 145 views 2 comments 0 points Most recent by Cristian Ariel Arakaki Human Capital Management
-
Columns removed while editing the dataset in Data Model for BIP reportHi All, We are editing the 'Statement Generation Data Model' ,. We have few existing columns which are available in the Structure diagram, but same is not available in D…
-
How can we read Person Number and set report parameter in a Report URL on Employment page(Person ManSummary How can we read Person Number and set report parameter in a Report URL on Employment page(Person Management)Content How can we read Person Number and set report …
-
Link on the name bring the Manager to the Connections page for that colleague in Team Activity CenteIs it possible the link on the name bring the Manager to the Connections page for that colleague? (former/ Nux Public Info page). Since it currently opens up the Activit…
-
Job Offer Approval Rule in "Worker Type" we have "Contingent worker " & "Employee".Summary: Hello We have a requirement with Job Offer Approval Rule in "Worker Type" we have "Contingent worker " & "Employee". Employee Need to go for Approval Contingent…Krishna Sigilipalli 32 views 3 comments 0 points Most recent by Sonal_Modi Recruiting, Opportunity Marketplace
-
Backend table for FICAWe're trying to look for the backend table for FICA status for below navigation: My client Groups> Person Management>Search for any person> tasks> payroll>calculation ca…Midathala Indu Sree 1 view 1 comment 0 points Most recent by Yaswanth_Pappu-Oracle Human Capital Management
-
Not able to see the data Annual PDP 2026 from hra_doc_types_tlSummary: I am able to see the performance document Name in OTBI and front end but not able to see in the oracle fusion HCM table hra_doc_types_tl Is this expected or do …
-
Need to fetch Transaction approver start date and the next level approver detailsSummary: We have a requirement to fetch the date the transaction was assigned to each level of approver and also the next level approver details. This is applicable for …
-
In Redwood Resign from Employment-Termination details not displaying in Approval notificationSummary: We have migrated to Redwood V3 Resign from employment. when the Employee Resign from Employment, the approval goes to the Line Manager and HR VP. Though they se…
-
Is it possible to query or export approval rules + conditions for a transaction?Summary: I want to export the configured rules and conditions for the Manage Employment approval rule (Transaction Console > Approval Rules). How can I do this? Is there… -
HDL for custom section in Additional Person Info pageSummary: HDL for custom section in Additional Person Info page Content (please ensure you mask any confidential information): Hi experts, does anyone has a simple HDL te… -
Is there a limit on number of parameters that can be added to a BIP report/Data Model?Hi Team, Is there any restriction to add number of parameters in a BIP Report? Thanks, SatyaChinnamsetti Satyanarayana Swamy 1 view 1 comment 0 points Most recent by Chinnamsetti Satyanarayana Swamy BI Publisher Learning Center
-
Is there an OTBI/BIP Report for Employee Personal Information Change Transactions?Summary: Looking for an OTBI/BIP Report for Employee Personal Information Change Transactions! Content (please ensure you mask any confidential information): Checked the…nikhilnelluri 11 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management
-
Additional Assignment Info - not visble in Employment infoSummary: Hello, We are unable to see the Additional Assignment Info, under employment info, in Redwood. In RUI, the section is correctlu displayed. We deployed online an…
-
Need a sample query of Team Time Card page, to fetch staus value.Need the sample query to get the staus value (Approved, Submited etc..) of Time Cards for an employeeKalpa Sandaruwan 21 views 1 comment 0 points Most recent by HD - Fusion ERP-Oracle Human Capital Management
-
Under HCM only license, capture Department Costing under GL Cost Centre.Under HCM only license, can we capture Department level cost under 'GL Cost Centre' ( Which is used by ERP) ? And if we do would we have any downstream implications? Als…Prosenjit Manna 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Bi Publisher data model parameter not displaying into Bi publisher report parameterHi Team, I observed one issue in FDI Bi Publisher environment data model created with List of Values and parameter. Data model working perfectly. But when same data mode…Indranil Basak-Oracle 42 views 1 comment 0 points Most recent by AbulKhair BI Publisher Learning Center -
How to Add Document of Record Object from HCM Employment Flow to Approval BIP NotificationHas anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added Thanks! Update: I figu… -
What are the ways to identify a no show new hireWe have few new hires which did not show up for some reasons, however as they were provided with a start date, once they became a regular employee few outbound files/rep…
-
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… -
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…M Santoshi-Oracle 81 views 10 comments 0 points Most recent by Gretch Atienza Human Capital Management -
Does Oracle BI Publisher Support WPS Office for Excel Templates and Plugin Use?Hi, We’re currently evaluating WPS Office as an alternative to Microsoft Office and would like to confirm its compatibility with Oracle BI Publisher. Specifically, we’re…
-
Need Approval Group Details in GeneralLedgerHi all, I am working on a GL Manual workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments in GL. P…Chitti Damoder 21 views 0 comments 0 points Most recent by Chitti Damoder BI Publisher Learning Center
-
How to get the user details to whom termination notification is getting sent from workflow .How to get the user details to whom termination notification is getting sent from workflow notification AssignmentTerminationReport. Objective is to customize template b…
-
Query to find transaction details for stuck 'Time Change Request Approval' process_OTL cloudSummary: We have multiple transactions in 'Stuck' status after a DB outage for a certain date, these transactions don't have any details for the dates/time for which the…
-
How to retrieve user information who is running BI reportI need to display user name of who is running a BI report. I am using select :xdo_user_name from dual. But this is returning email id. But from security console I can se…