Data Models
Discussion List
-
Is there a Table Mapping between EBS R12 and FusionSummary Is there a Table Mapping between EBS R12 and FusionContent Is there a Table Mapping between EBS R12 and Fusion for example MTL_SYSTEM_ITEMS_B--> EGP_SYSTEM_ITEMSAshish Vishwakarma-50607 140 views 4 comments 0 points Most recent by Nagendrababu Kanuru Human Resources -
BIP report chart shows months in alphabetical order, and not in sequence of monthsSummary: Content (required): This is the screenshot where I have to add '01-JAN' , '02-FEB' i.e. numbers in front of months to show it in sequence, otherwise it either s… -
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…
-
Which BI Template does the New Hire FYI notification use?Summary: We have added 2 fields to the New Hire notification (Business Title and Position). The fields were already in the data model to add to the RTF template. The "Ap…Leia MacDonald 52 views 1 comment 0 points Most recent by Cristina Greyling - Oracle-Oracle Human Resources
-
EL Expression: Employee should be able to Edit even if they have Manager RoleSummary: We need to accommodate a requirement in Personal Details > Family and Emergency Contacts Page wherein in ESS, all employees should be able to edit while in MSS …Bianca Lei Villareal 42 views 2 comments 0 points Most recent by Bianca Lei Villareal Human Resources
-
Ability To Create Alert for Custom Visas and PermitsSummary: Ability To Create Alert for Custom Visas and Permits Content (required): Hello All, Is it possible to create an alert in HCM for custom permit such as Residency…
-
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 299 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 93 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 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…