Data Models
Discussion List
-
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 12 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 5 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 20 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.1K 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 51 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… -
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…
-
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 12 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…
-
How to Convert Contigent Worker into EmplyoeeSummary: Hi Experts, Please confirm. How can we convert a Contingent Worker into an Employee? and after conversion, the contingent worker history is maintained in the sy…
-
Enabling the Email URL link as default output type at Custom Folder level for BIP ReportsSummary: How do we enable the Report Output as URL link at Custom Folder level, in order to email the output to User as a URL link instead of an attachment.? Content (pl…
-
Bursting Query for Employee AttachmentsSummary: Hi Everyone, We intend to send four documents as attachments. One of these is the Acceptance of Resignation, which requires dynamic fields such as Termination D…
-
Can we split data into different sheet in CSV output of a BIP report ??I would like to enquire about the Oracle BIP Report CSV output data limit. Do we have a 2 million rows record cap for BIP CSV scheduled report? Can we split data into di…shauli.mukherjee 23 views 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
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 81 views 7 comments 1 point Most recent by Rebeca Barrueco Human Capital Management -
Absence Qualified Entitlement SQL QuerySummary: Hi All , I need SQL Query to fetch Qualified Entitlement Plan Details for the employees .The following is the navigation given: Absence > Absence Records > Plan…Padamatinti Varsha 681 views 3 comments 0 points Most recent by Raj Battiwala Human Capital Management
-
Role Mapping SQL ReportSummary: Hello Experts, I need assistance in developing a SQL query that will generate a Role Mapping report, equivalent to what is configured in the “Create Role Mappin…
-
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 133 views 4 comments 0 points Most recent by Sasank Reddyy HCM Data Loader (HDL)
-
how to see the origin of an absence request (absence or time module)Example: our customer has requirements that allow them to enter an absence via time card OR via add absence, so we have a mixture of how employees are submitting absence…ElijahHopkin 32 views 5 comments 1 point Most recent by Martijn van den Berg Human Capital Management -
Costing of department QueryHello, I'd like to know if anyone has any idea which table or query I can use to get the details shown in the below screenshot. Any help would be very appreciated.
-
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):…
-
REASON_CODE is not populating in PER_ALL_ASSIGNMENTS_M tableWe have custom reports which are using the REASON_CODE column from PER_ALL_ASSIGNMENT_M table. After we enabled Redwood, the REASON_CODE column stopped populating UI sho…