Data Models
Discussion List
-
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 119 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 21 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 21 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 41 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 1 view 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 21 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 32 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 51 views 5 comments 0 points Most recent by Nimisha A Recruiting, Opportunity Marketplace
-
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.4K 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 1 view 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 1 view 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…