Data Models
Discussion List
-
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 0 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 11 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 74 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 655 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 126 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 22 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…
-
User Activity ReportSummary: Is there a report that would provide me with user activity logs? An example would be an employee logs into the system (the report would provide date and time of… -
Can we modify standard process "Make EFT Payments" in fusion?Summary Can we modify standard process "Make EFT Payments" in fusion? we need to add some fileds so want to understand if we cand modify and what is the data source link…
-
How can we store a BI Report (PDF) in the Document of Records without using HCM Extracts?Summary: We have configured a journey for Associates in which they receive a document as part of their task allocation. When an Associate is assigned a task, a correspon…
-
BI Publisher - Obtain YTD / accumulated balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…
-
activate user and assign role using HDLSummary: Hi all, Wanted to active one inactive user and assign role thru HDL. Can we do that ? Content (please ensure you mask any confidential information): Version (in…
-
how to send the zip files and PDF files as attachments in the email through the bursting bip reporti have requirement to send the zip files and pdf files as attachments in the mail through Bursting report, is there a way to do this? please let me know
-
HCM Cloud Data Dictionary Mapping – UI Labels, Database Objects, and Confidentiality ClassificationSummary: We are working on improving HR metadata awareness and AI readiness within Oracle HCM Cloud, and are looking for a comprehensive HCM Data Dictionary that include…Sandeep Deshwal 23 views 1 comment 2 points Most recent by Sambasivarao Manam Human Capital Management
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 45 views 4 comments 0 points Most recent by CSINGH_KCC Reporting and Analytics for HCM
-
unable to convert the xml fields into spanish in the rtf templatewe have a requirement to display both English and spanish languages in a single offer letter, but in the rtf template we are unable to convert them.is there a way to pop…Kiran Kumar Alle 3 views 1 comment 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
Query/SQL for datamodel in BI Publisher of Other Addresses in Location PageSummary: Hi, Do you know via datamodel/BI Publisher in what table other addresses for locations are stored? We do not find them either in: HR_LOCATIONS_ALL_F_VL or per_l… -
How do I limit a primary dataset based on results in a lookup dataset in a data model?I have a data model with a "primary" dataset that joins to 3 other datasets as "lookups" for additional data. I want to apply a condition to one of the lookup datasets v…CatPenn 22 views 4 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center
-
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… -
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…Yugandhara_Pawar 23 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
HCM Extract | Excel Template | Parent child traversing in templateSummary: Hi, I am working on the HCM extract where excel template is being used. The XML path looks like this: Now, my requirement is to fetch attributes from different …
-
How to get the vertex and loqate geography details in hcm?Summary: As i understand, there is a seeded report available to fetch the details of the vertex and loqate geographies which are loaded in HCM. Any idea what is the path…Ghosh Pooja 58 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
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 54 views 5 comments 0 points Most recent by Nimisha A Recruiting, Opportunity Marketplace