Data Models
Discussion List
-
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 111 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… -
full outer join in BIP fusionHi, I have two queries and I want to use full outer join in BIP but it does not work. I am using select * from t1 full outer join select * from t2 on t1.A = t2.A but giv…Morad Alshammari 31 views 10 comments 0 points Most recent by Morad Alshammari BI Publisher Learning Center -
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 36 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 61 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.… -
Sample HDL or Spreadsheet file for Competency Talent profileContent Does any body have any dat file or sample file for Competency load in talent profile ? We are trying to load competency to Talent profile but it not working. We …
-
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 71 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 71 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need Connection/Join between Business Unit and Legal Employer User EntitySummary: Grouping and summation by Legal Entity and Business unit I am trying to develop a Payroll Balance related HCM Extract where I need to group the data based on Le… -
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 3K 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 180 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 -
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi Experts Select LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. … -
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…
-
HDL Questionnaires with Conditional Questions failsContent Hi all, I have been loading questions with HDL to Fusion which in the main works but fails when I have conditional questions and answers. The Oracle documentatio…