Data Models
Discussion List
-
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… -
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 6 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…
-
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 75 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…
-
Using SUM function in Table Type Value setContent I am trying to perform the SUM function in a Table Type value set, but it is not fetching results. I have tried various ways like using inline query in the ID Co… -
HDL for Terminate and Re-HireSummary We have a requirement to Terminate & Re-Hire An Existing EmployeeContent We have a requirement to Terminate & Re-Hire An Existing Employee with All The Details E…
-
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 3 views 0 comments 0 points Most recent by Ghosh Pooja Payroll and Global Payroll Interface (GPI)
-
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…
-
BIP Report returns sql time out error for few usersHi, We have a BIP Report which is working fine for few users and returns SQL time out error for few users. The user who is getting error is running the report by using s…Yuvraj S-Oracle 102 views 4 comments 0 points Most recent by vinay.u.sharma Human Capital Management
-
How to schedule the same PDF notification for Casual employees at 6 months, 12 months, and yearlySummary: Hi All, I have a requirement where we need to send the same PDF document to employees whose Assignment Category = Casual based on the following timeline: First …Dharani Dhar Gupta 11 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Human Capital Management
-
Issue with “View Document” in Documents of Record – PDF Download ErrorHi Team, Whenever we try to add Documents of Record and click on View Document against an employee, the PDF report should download, but it is throwing an error message. …
-
GL Trial Balance Report ParameterSummary: I need to show the Future Enterable periods for the user while he is running the GL TB report. currently i cannot see where exactly they define the LOV for Acco…Mohammad Ghannam 1 view 0 comments 0 points Most recent by Mohammad Ghannam General Ledger & Intercompany -
BI Audit Report/Tables connection errorSummary: We are seeing below error when user is trying to run a BI Report which fetches data from fusion iau viewer.bipublisher_v table to capture report access timeline…
-
HCM Extract - With Document of Records Delivery typeSummary HCM Extract - With Document of Records Delivery typeContent Hi Experts, I have a requirement to store the Report in Document of records, for that we have used HC…User_2025-02-10-21-41-28-701 453 views 14 comments 1 point Most recent by Aditya Jadhav Human Capital Management
-
Need sql query to fetch approvers list of a transactionSummary: Hi There, I have a requirement to fetch all approvers' names of a transaction, If any one have report for this requirement, please share. Thanks, Lakshmi Conten…
-
Position Override Flag Changing After HDL LoadSummary: Hello, We are doing a full load for UAT. I have position override set to Y for all active workers. Yet when I load the data it changes to N for some. WHY?? And …
-
XML-23029: (Error) FORG0001: invalid value for cast/constructor ERROR IN BIP REPORTHi All, We are getting below error while running BIP report, while it runs successfully for some orders and gives error for 2-3 orders Can you suggest nay possible solut…
-
Is there any possibility of retrieving the processed or errored HDL files after the retention periodSummary: Is there any possibility of retrieving the processed or errored HDL files after the retention period? Content (please ensure you mask any confidential informati…
-
Need Table details storing User information created in Security ConsoleSummary: We need to get the information of User like First Name, Last Name, username and email id of the user created in Security console. Content (required): Person inf…Sudheer Movva-193114 1.5K views 10 comments 0 points Most recent by s.datta Human Capital Management