Data Models
Discussion List
-
Absence Balances – Resignation – Current Balance and Balance at TerminationSummary: How to display Absence Balances, As-of Date: Current and at Termination Date? Content (required): Embedded OTBI report in Resignation. Report displaying Absence… -
No Negative YTD Pre-Tax Deduction Balance ReportSummary: Need to create a custom "No Negative Pre-Tax YTD Balance Report Content (required): Not sure if an existing OTBI Data model exists? And should an HCM Extract be…User_2025-02-12-15-41-59-245 21 views 6 comments 0 points Most recent by Kathan Bhatt-Oracle Human Capital Management -
Table name for retrieving representative information shown on pubic info page for an employeeSummary: I need to write a BI publisher report where I need to fetch the representatives assigned to an employee based on AOR as shown in the screenshot below .Below we …
-
HCM ReportsHello dear community, I want to know which report exists for every module in fusion hcm. Thanks, Octa -
Where to find Loqate Geography Reference Data for FranceSummary: Content (required): I've found the information in Oracle HCM Implementation Guide that the Loqate supports 82 countries for loading Geography Reference Data. Bu…Evgeniya Repnina 41 views 2 comments 0 points Most recent by Evgeniya Repnina Human Capital Management -
Folder restriction for OTBI sideHow can I remove BI catalogs or make them invisible to users? Users are having difficulties because there are too many folders. For example, we only want to see TAV fold… -
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Checklist Task Email Notification TemplateSummary Templates for checklist email notificationsContent Can someone let me know where to find the templates for the checklist email notifications? We are using the of…Shelly Feyerherm 244 views 5 comments 0 points Most recent by Shanna Oppenheim Human Capital Management -
Need to know tables used for storing geographies for use in BI publisher reportSummary: Need to know tables used for storing geographies'.This info will be used to extract list of all cities and states visible on geography hierarchies for India loc…
-
Looking for HDL file to load the data into the created dff in DORSummary: Content (required): Hi Expert, We have created some dor and in dor we have created a date dff and we want to load the data in it. Please provide the .dat file i… -
Requirement: How to identified if a notification is standard or BurstingSummary: Content (required): Hi Expert, There is a notification triggering but I am not able to identify is a standard notification or is a bursting notification. Versio…
-
Default Expense Account is not acknowledged in Requisition Charge AccountHello, We have a worker.dat file which successfully updates the employee default expense account:…James Coles 99 views 3 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
HR Core: Employment model choiceSummary: Our industry is the public sector. Country Italy. Only one Legal entity. Scenario: every person can have 1 contract and multiple asg. we're about to set up the …Rebecca Tosetti - Oracle-Oracle 31 views 3 comments 0 points Most recent by Rebecca Tosetti - Oracle-Oracle Human Capital Management -
BI Report to print position hierarchy chartSummary: Hi, Looking for the custom BI Report to get the print of the position hierarchy. Content (required): Below Idea logged to enable the print functionality with po… -
Unable to properly attach ESignature document to Esignature TaskSummary: The report path is being directly pulled from OTBI as well as the name of the document, the .xdo?P_SIGN_DATE={SignDate}&P_SIGNER_NAME={SignerName}&P_SIGNER_EMAI…
-
HCM Talk Radio: HCM Cloud Environment Sizing GuidanceSummary HCM Talk Radio: HCM Cloud Environment Sizing GuidanceContent Are your Cloud environments sized appropriately for your operational needs? Listen in to HCM Talk Ra…Frank Cowell-Oracle 37 views 1 comment 2 points Most recent by Alina C.-Oracle Human Capital Management -
How to fetch Employee PII information (Address, Phones) in a BIP ReportSummary: We have a Scheduled BIP report which fetches employee address from PER_ADDRESSES_F table. This was working fine. But recently, the table not returning any recor…Christopher Jothi - HCM-Oracle 52 views 7 comments 0 points Most recent by MandeepGupta Human Capital Management -
Having trouble getting this table-based Value Set to workSummary: Value Set in Fast Formula Content (required): I have been wracking my brain all night/day on this one. The SQL works fine in BI but when I use it as a Value Set…
-
How to download the attachments from transaction table?Summary: How to download the attachments from transaction table? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any co… -
Unable to navigate to "Page Composer" from Sandbox in Change Assignment PageSummary: Hi Team, We are facing a problem where in we are unable to navigate to "Page Composer" in Change Assignment page from a Sandbox. The error faced is as attached.…
-
Where are Sandox details stored?Are they in tables or as files in SoA layer?Summary: Where are Sandox details stored?Are they in tables or as files in SoA layer? Content (required): Where are Sandox details stored?Are they in tables or as files …
-
Upload and delete massive dataSummary: Hello dear community, I want to know how could I delete all the data in my fusion test environment and how could I reset the settings to start from zero? Also h…
-
Configuring User-Defined TableSummary: I am looking for best practices and clear instructions guide for setting up a user-defined table in HCM to store recruitment related information. Content (requi…Giuseppe Cannova 63 views 6 comments 0 points Most recent by Giuseppe Cannova Human Capital Management -
How to get the total Headcount of Employees and contract worker on monthly basis.Summary:We were trying to fetch the Hire and Terminations on monthly basis in OTBI. Please find the Attachment for your Reference. Content (required):We are trying to cr…Harish.M 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Extract correct hourHello everyone, I would need to set when I extract a date to the date set on the system's regional preference. That is, get the correct timezone based on the settings sa…User_2025-02-07-06-30-13-200 21 views 2 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Human Capital Management
-
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n…
-
Deeplink document of recordsHello everyone, I would need to create a deeplink to an employee's document of records page. I found this deeplink, https://hdeh-dev1.fa.em3.oraclecloud.com/fscmUI/faces…User_2025-02-07-06-30-13-200 31 views 3 comments 1 point Most recent by User_2025-02-07-06-30-13-200 Human Capital Management
-
SQl query for fetching data to enter GL Cost Center details at department level using HDLContent (required): Hi everyone I need help to define the SQL query in a data model to fetch the information for the following Metadata-line to be used in HDL:…Daniel Lundsteen Minke 2.9K views 1 comment 0 points Most recent by MandeepGupta Human Capital Management -
RestAPI for organization treeSummary: I need to extract organization tree using RestAPI but I cannot find the information other than a list of items /hcmRestApi/resources/11.13.18.05/organizations :…Charline 11 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Human Capital Management -
Mass Assignments Update Using HDLSummary Mass Assignments Update Using HDL for Location, Departments etcContent Hi Please find the attached Queries which extract the current assignment records and chang…Mansur Khalil 165 views 10 comments 7 points Most recent by Shanna Oppenheim Human Capital Management