Data Models
Discussion List
-
RequestPositionChange notification is picking seeded report template instead of customized templateSummary: Content (required): We have customized the template and data model for UpdatePositionReport by following the steps from Oracle. However, we can see the notifica…Riya_Maithani-Oracle 71 views 16 comments 0 points Most recent by Riya_Maithani-Oracle Human Resources -
How to migrate my configuration from test environment to prod environment without copy data baseSummary: Hi dear community! i'm about to ending up my sets up from my test environment and i wonder how can i migrate these config to prod environment without using copy…
-
Query regarding worker numberSummary Query regarding worker numberContent If we set a worker number method as automatic and to start from certain sequence let say 100 and later I want to upload work…
-
HCM Extract Completed with Alerts StatusSummary: Production Issue : We scheduled one of HCM Extract, which is completed with alerts error status. The generated log is showing FUNCTIONAL_ERROR at post processin… -
Issue custom criteria in the person security profileContent Hello Everyone, I have created the following SQL query to be entered into custom criteria (person security profile). &TABLE_ALIAS.PERSON_ID IN (select distinct p… -
HDL Template to convert Non Worker work relationship to Contingent WorkerSummary: Hi All, Can someone please provide the SQL query and HDL template for the below requirement. 1. We need to update the "System person type" from "Non worker" to … -
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… -
Query to download user profile photoSummary: IS there any way we can download the Staff (User)Profile photo from backend (using SQL) Content (required): Version (include the version you are using, if appli…
-
Manager Hierarchy LoopSummary We want a report that can tell us Manager Hierarchy Loop conflictsContent Hi All, We are seeing certain termination and promotion transaction failing due to mana…
-
Release Update Issue 23b: Error in custom reportsSummary: 'ORA-32036: the unsupported case for inlining of query name in WITH clause' Content (required): Hi Everyone, I'm facing an error on reporting level after the Re…
-
Best way to query HCM tables??Summary: Content (required): Hi, so for the past 3 years, the way I've been querying HCM tables is by using a BI data model to write the query and output the data. I'm c… -
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 117 views 7 comments 0 points Most recent by Ramanathan Sockalingam Human Resources
-
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… -
I want to extract distinct user logins that logged in to the systemSummary: Requirement is to extract distinct user logins who logged in to the system and compare the statistics for Q1 2022 and Q1 2023 Content (required): Version (inclu…Keval_Shah 62 views 7 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Doc ID 2331021.1 Release 13 Configurable Notifications Enhancements (20B Update)Summary This is part of a series of Quick Reference Guide "Frequently Asked Questions and Answers"Content To improve the performance of Oracle Business Intelligence (BI)… -
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…
-
V3 Seniority dates BIP query issueHi Experts, I am working with a BIP query using V3 Seniority dates table (PER_SENIORITY_DATES_F), I need to map the seniority date with assignment table or work relation…
-
Department Manager InfoHi, I wanted to extract department details with reporting manager person number and name. Can anyone help me with the userentity where i can extract department details w…
-
How to send documents saved in Document of records?Summary: Hi all, we have a requirement to send the employee document which is saved under documents of records to the downstream system using SFTP. can anyone please let…
-
Create Person Security Profile with AoR and Position TreeSummary: Cannot select position hierachy as scope of responsibility in creation of person security profile. Thus, position tree cannot be referenced rendering our plan t…
-
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…
-
Required documents related to approval delegationSummary: I want documents related to approval delegation.Like how to set approval delegation. Content (required): Version (include the version you are using, if applicab…
-
Mapping of Seniority dates after V3 Seniorty Dates migrationSummary: We are using PER_PERIODS_OF_SERVICE table's - ORIGINAL_DATE_OF_HIRE( as Enterprise Seniority Date) & ADJUSTED_SVC_DATE (as Legal Entity Seniority Date). After V… -
SQL query to fetch all notifications/emails sent by Fusion.Summary: We need to extract all worklist notifications/Approval/email notifications that are triggered in Fusion within a specific time range. Has anyone ever worked on …
-
Table Details that stores all information about a Custom Quick ActionHi All, Please help know the table name that stores Quick Actions ,Eg: If there is a custom Quick Action created like "Colleague Details" under Me TAB,want to know when …
-
How to Add Document of Record Object from HCM Employment Flow to Approval BIP NotificationHas anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added Thanks! Update: I figu… -
Need to edit Enterprise Onboarding TemplateSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We want to display the first name in place of full name in the Enterprise On…
-
Worker.dat is not loading to update SenioritybasisSummary: METADATA|Assignment|AssignmentNumber|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|SeniorityBasis…
-
SQL to fetch all the worker objects to load using HDLHi all, I needed a SQL to extract the worker objects (worker, person_name, phone, assignment, work relationship, assignment supervisor, etc., ) to load into fusion from …
-
Preferred nameSummary Preferred nameContent Most employees with a preferred name would want their preferred name shown and keep their legal first name private if possible. Can the sys…