Data Models
Discussion List
-
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 22 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
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…
-
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 knowKiran Kumar Alle 2 views 0 comments 0 points Started by Kiran Kumar Alle BI Publisher Learning Center
-
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 1 view 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 31 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…
-
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…
-
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…
-
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 1 view 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…
-
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…
-
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… -
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 6 comments 1 point Most recent by Cyrus Bravo Human Capital Management -
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…
-
How to populate multiple time event attributes within the REST API timeEventRequestsSummary How to populate multiple time event attributes within the REST API timeEventRequestsContent Hi gurus, I faced an issue with populating multiple time event attrib…
-
Unable to reduce the blank space in Contract Terms downloaded and Preview reportSummary: Unable to reduce the blank space in Contract Terms downloaded and Preview report. We've generated a customized report for the downloaded Contract Terms and trie…
-
View National Identifier when RehireSummary: When an HR Rehire an employee, he can't see its National ID, until the process is approved and the Rehiree is in the HR scope Our needs is to see the National I…Alexis_Mogne 11 views 4 comments 0 points Most recent by Katharina_Seidenfuß Human Capital Management
-
Can we burst multiple templates in BI Publisher?Summary Can we burst multiple templates in BI Publisher?Content Hi Team, I have a requirement where I am having two different templates based on a single data model. Eac…
-
Business ID Cards directly from Oracle Fusion HCMHas anyone successfully generated Business ID Cards directly from Oracle Fusion HCM? I created a query to retrieve the employee image (Base64 and URL), name, and person …Juan Angel Palizada 21 views 3 comments 0 points Most recent by Carl Bequilla-Oracle Human Capital Management
-
BIP Report in PDF format not loading in mobile applicationSummary: BIP Report in PDF format not loading in mobile application Content (please ensure you mask any confidential information): we have create a BIP report and the ou…