Data Models
Discussion List
-
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 51 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 39 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 51 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 64 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 41 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 33 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.4K 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 155 views 10 comments 7 points Most recent by Shanna Oppenheim Human Capital Management -
Education Column/Field in Oracle Fusion HCMContent Dear All, We want for our reporting purpose the column Higher Education from HCM Regards, Shaikh Azaz Version OBIEE 12c -
Element Entries DetailsContent Hi I would like to fetch below highlighted columns in BIP report , any idea which table column hold this data? Navigation :Person Management > search for person …
-
Same report template for multiple workflow notificationsContent Hi - is it possible to use a common report template for multiple workflows ? Currently, the "Promote" process uses the "PromotionReport" template and the "Admini…
-
21B Data Model Update Causing IssuesSummary 21B Data Model Update Causing IssuesContent Hello Everyone, After installing update 21B we noticed that our workflow notifications that are based upon the Employ…
-
How to update the Contact Relationship of an Employee if it was stored 'wrongly' the first time?Content During our contact upload, the source system had wrongly identified few relationships as 'Others' when it should have been 'Domestic Partner'. Now we found this …
-
SQL to fetch Manage employment Contract detailsContent Hi All, Could you please provide SQL for Manage employment Contract details section EFF columns. I searched in per_assignment_extra_info_m, it does not have all …Punam Roy Karmokar 20 views 6 comments 0 points Most recent by Punam Roy Karmokar Human Capital Management -
how to report what vacation rules have been defined?Summary how to report what vacation rules have been defined?Content Is there an analysis or a query that can be used in a data model? Version 19C
-
Do we have any delivered/custom reports which fetches all the contact information of all the EmployeContent If so,could you please let me know the name or share the underlying SQL for any custom reports you have written?Tanmay Pillai 26 views 3 comments 1 point Most recent by Julian Challenger-Oracle Human Capital Management