Data Models
Discussion List
-
Run time issue in the Payroll Costing Results ReportSummary: We are trying to customise the payroll extract called: Payroll Costing Report to include additional columns based on business requirements. However, before proc… -
Delivered Reports in Fusion HCMSummary Delivered Reports in Fusion HCMContent Dear All, Reporting and Analytics is an integral part of any ERP implementation. At times we tend to create reports for cl…Ankur_Fusion_HCM 1.5K views 9 comments 6 points Most recent by Shrikant Gupta Human Capital Management -
Remove compa-ratio from notificationsSummary: Dear Expert, Hi, Our Compensation Manager has noticed that the Compa Ratio field needs to be removed from the notifications. Please see the attached image for r… -
is there any limitation of sending alert from alert composer to user?Summary: Hi Team, We have processed one learning custom alert for 35k learner. But it got triggered to exact 32k employee with warning sign and time out error. Is there … -
Issues on HDL Seniority Dates V3.Summary: Hi experts, we are currently experiencing an issue with the HDL mass loading of Seniority Dates. We are using version V3 of the Seniority Dates and would like t…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Mohammad Afghanul Human Capital Management -
Oracle BI Report gives incorrect value of dataWe are experiencing an issue with a couple of BI Report interfaces that use a drag-and-drop template. The report is scheduled to run monthly and returns incorrect date v… -
Missing Records in PER_MANAGER_HRCHY_CF After Refresh Manager Hierarchy ProcessHi All, We are consistently encountering an issue where records for certain active employees are missing from the PER_MANAGER_HRCHY_CF table, after the Refresh Manager H… -
Is it Possible to add parameter to the customised “Collections Send Dunning Letters” ReportHello Team, We have customised the seeded dunning letter data model in Oracle Fusion Advanced Collections and need to add one custom parameter. We are getting an error a…Voladri Saikiran 11 views 0 comments 0 points Started by Voladri Saikiran BI Publisher Learning Center -
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… -
Oracle HCM Cloud: HSDL for Seniority Date updatesContent Oracle HCM Cloud: HSDL for Seniority Date updates. We are trying to create an HSDL template for Seniority date updates but it seems there is a structural issue w…User_2025-02-10-08-35-40-989 96 views 8 comments 1 point Most recent by Marlon Castillo Maliglig Human Capital Management -
We want to hide certain standard fields, from the OTBI subject area column list.Summary: In Oracle Fusion HCM, we want to hide certain standard (seeded) fields, such as Ethnicity, from the OTBI subject area column list so that no user can see or sel…Gaurav Dolui 42 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Human Capital Management -
You Do Not Have Permission To Add Users Other Than Yourself As Direct Recipients - ErrorHi, We're encountering the following error: "You Do Not Have Permission To Add Users Other Than Yourself As Direct Recipients." Please find the attached screenshot for r…Saurav R-Oracle 213 views 2 comments 0 points Most recent by CA Nirmal Choudhary Human Capital Management -
I need help joining recruitment tablesSummary: I need to validate the inbound "step" for an application managed in 3rd party CRM Content (please ensure you mask any confidential information): I know that irc… -
we giving effective end date of UDT table using below HDL but not updatingSummary: Hi Team, we giving effective end date of UDT table using below HDL but not updating, could you please assist me on ? Content (please ensure you mask any confide…Maddipati Ajay Kumar 31 views 2 comments 0 points Most recent by Maddipati Ajay Kumar Human Capital Management -
We found data missing from data model to report output while RTF layout has XML TagWe found data missing from data model to report output while RTF layout has XML TagUser_V7JI3 20 views 3 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center -
Is there a way to identify if the business unit name is hardcoded in extracts or reports in hcmWe renamed the Business unit and this will have an impact on the seeded/custom reports and extracts so we wanted to do a global search using the string/hardcoded value l… -
Display the DFF value in an Alert Composer messageTeam, We have a requirement to display the below DFF value in an Alert Composer message. Document Records -> Workplace Adjustment Outcome -> Workplace Adjustment Review … -
How to Extract person Images in Changes Only HCM Extract?Summary: Can we extract person images (Blob data) in Changes Only HCM Extract? We have a requirement to get the csv file newhires and any changes in Position and Locatio… -
Impacts after migration to termination v3 to existing employeesSummary: Impacts after migration to termination v3 to existing employees Content (please ensure you mask any confidential information): Hi Experts, we would like to use … -
How to call Fast Formula in BIP report .Summary: Hi Team, We are trying to call Fast Formula outputs directly inside a BIP Data Model SQL query using the WITH FUNCTION + FF_EXEC approach. However, we are facin…Rahul Bhavikatti 34 views 1 comment 0 points Most recent by Rahul Bhavikatti Human Capital Management -
BI Audit Report/Tables connection errorSummary: We are seeing below error when user is trying to run a BI Report which fetches data from fusion iau viewer.bipublisher_v table to capture report access timeline… -
Unable to get data for Secured views pay_payroll_secured_list_vSummary: When the user is trying to run the report not getting the data as secured view used in the report. Content (please ensure you mask any confidential information)… -
Tables and Views for HCM Documentation Available as PDFSummary: Is there a PDF version of the "HCM Tables and Views for HCM" online documentation? Content (required): I am looking for a PDF or other consolidated version of t… -
HDL for Family and Emergency Contacts, missing fieldsSummary: Student Status, Disability Status, Tobacco Use, and Use My Address not available in the Contact.dat Content (please ensure you mask any confidential information… -
Query to get the Highest level(One below CEO) of Manager for an employeeSummary Query to get the Highest level(One below CEO) of Manager for an employeeContent Hi Team We have our requirement where we need to fetch the highest level of Manag… -
Doc ID 2331021.1 Release 13 Configurable Notifications Enhancements (20B Update)Summary This is part of a series of Quick Reference Guide "Frequently Asked Questions and Answers"Content To improve the performance of Oracle Business Intelligence (BI)…Dr Surlina Yin-Oracle 2.2K views 16 comments 13 points Most recent by Nikhil Dugad Human Capital Management -
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 57 views 6 comments 0 points Most recent by Milan_Chandra Recruiting, Opportunity Marketplace -
Timestamp DFF SegmentSummary: Requirement to host Date and Time of employee contract acceptance date. Content (please ensure you mask any confidential information): Hello Experts, I'm not ab… -
BIP HDL loadSummary: I have a BIP report with HDL ready etext format. As of now, we are downloading the text and convert it to .dat and loading the HDL file. I am trying for various…RSampathKumar 11 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management -
In table how to fetch XML cachedata of screen entry value in Transaction tableFor Pending Transaction, we are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have i…