Data Models
Discussion List
-
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):…
-
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… -
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 11 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 2 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 21 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 52 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…
-
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 1 view 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…