Data Models
Discussion List
-
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 31 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 44 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 8 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 28 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 62 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
Modifying the ESS scheduled process 'Run Grade Step Progression' generated Log Output files in HCMHi All, We would like to request a change in the wording used in the log output file that is generated after running the scheduled process “Run Grade Step Progression” i…
-
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 8 comments 6 points Most recent by Chhaya Govil Human Capital Management -
Fixing Concatenated Terms and Conditions in BI Publisher ReportsI am customizing the PO PDF report in Oracle Fusion. In the application setup, our Terms and Conditions are entered across three lines. However, in the report output, th…Samruddhi Baviskar 2 views 3 comments 1 point Most recent by Sushan Peiris BI Publisher Learning Center
-
Is there any guidance to generate a report of Change Order redline details for integration purposesOur requirement is to integrate item changes by organization into the ERP system. Therefore, we need to generate a report based on the exact change details, categorize t…
-
Procedure Element in HCM ExtractContent Can anyone explain what is a Procedure element and where I can see the list of PROCEDURE ELEMENT? And any white paper introduces how PROCEDURE ELEMENT works? Ver…
-
HDL Error in Termination CWK and creating NonworkerSummary: We are facing HDL error while Termination of CWK with Multiple lines and creating Nonworker. Below is the error message Error : You must provide New Start-Date …
-
Table Name for EIT defined under enterpriseSummary: Need to find out the table name for EIT defined in Manage Enterprise HCM information Content (please ensure you mask any confidential information): Hi, We have …anirbanchatterj7 8 views 1 comment 0 points Most recent by Volodymyr Faranosov Human Capital Management
-
OIC HCM Cloud payroll integration architectureSummary: Hi all, We are building an OIC integration from HCM Cloud to 3rd party system. The downstream payroll system is expecting 11 txt files containing over 150 field…
-
Worker HDL Action code changeeSummary: I am trying to change the action code on a worker from Synchronization From Position to Assignment Change. I am using the worker.dat for a HDL load however I am…Tracy Goodchild 8 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Human Capital Management
-
How to customize approval templates to show/hide dataSummary: I need to customize an approval notification to show/hide data based on security roles. How can i use a conditional region to show/hide? Content (required): I n…
-
Is there a way to dynamically pass the instance name (PROD, TEST, or DEV) into the Alert Composer?Summary: Is there a way to dynamically pass the instance name (PROD, TEST, or DEV) into the Alert Composer body? Content (please ensure you mask any confidential informa…Volodymyr Faranosov 7 views 2 comments 0 points Most recent by Volodymyr Faranosov Human Capital Management -
Reporting on Sexual OrientationSummary Where can I find the Sexual Orientation attribute in OTBI?Content Hello I have created a basic diversity data report in OTBI, obtaining fields for Religion, Ethn…
-
How can we modify this logic to ensure the correct date is displayed in the notification?Summary: Content (please ensure you mask any confidential information): How can we modify this logic to ensure the correct date is displayed in the notification? The not… -
I have created DFF and I'm using the default type as SQL but data are not auto-populate in the UII created the Value Set using the default validation type as SQL, but the data is not auto-populating in the UI. When I check the backend, the data is present, but it do…
-
V3 Seniority Date HDL file for manually adjusted datesHi Experts, We ran "Seniority Dates V3 - Remove Seniority Dates Transaction Data" Diagnostic process to removes seniority date for the certain configured rules. While ru…