Data Models
Discussion List
-
SQL to extract list of all jobs currently runningSummary: SQL to extract list of all jobs currently running Content (required): Can anyone share the SQL to extract list of all ESS jobs currently running in the applicat… -
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 136 views 18 comments 0 points Most recent by Priyanka Manuja Human Capital Management
-
Can we modify the warning message which generate through grade rate when we enter salary outofrange?Summary: Can we modify the yellow highlighted warning message in the below screenshot? Content (required): Version (include the version you are using, if applicable): Co…
-
Alert composer: Retrieving data for next 3 months from current date is not workingSummary: Hello we have a requirement to trigger a probation alert 3 months prior before the end date. We have created a sql query to test the data first before we move t…Tanusha_Ragooah 54 views 2 comments 0 points Most recent by Tanusha_Ragooah Human Capital Management
-
Calculate hire dateSummary: Calculate the hire date considering rehire within 3 months Content (required): Hi All, We need to calculate the hire date and years of experience in a report ba…Gayathri K M-Oracle 46 views 2 comments 0 points Most recent by Gayathri K M-Oracle Human Capital Management
-
How to get a workflow list that has SOA problem?Summary: Situation: The system sent an email on 04/06/2023 with information about the employee's dismissal, but this employee was dismissed on 11/16/21 in POD. We would …Maria Luiza Siqueira 46 views 4 comments 0 points Most recent by Maria Luiza Siqueira Human Capital Management -
Hi.. Can we generate XML output file using BIP Report and send it over FTP?Summary: I have a requirement to generate BIP report which output file format should be XML. From Data model we can manually get XML file with 200 rows at max. But I don…Mallikharjun Purilla-Oracle 141 views 6 comments 0 points Most recent by MandeepGupta Human Capital Management
-
Build report from HRC_TXN_HEADER and HRC_TXN_DATA that are truncated during P2T refreshSummary: As per Document 2929464.1 (oracle.com) HRC_TXN_HEADER and HRC_TXN_DATA that are truncated during P2T refresh, so the tables are having 0 rows. Any idea how to c…
-
System TIMESTAMP as a default value in BI report parameterHi, Is there any possibility to pass System TIMESTAMP as a default value in BI Report Parameter instead of Complete DATETIME. Thanks,
-
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 484 views 4 comments 0 points Most recent by Nagendrababu Kanuru Human Capital Management -
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…Riya_Maithani-Oracle 36 views 0 comments 0 points Started by Riya_Maithani-Oracle Human Capital Management
-
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 46 views 2 comments 0 points Most recent by Bianca Lei Villareal Human Capital Management -
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…
-
Evaluation bi publisher reports what is the security table to support managers direct report view?Hello , We have a bi publisher report ,where we extract population of employees and their evaluation. Issue : the report is run by managers ,we wish that each managers w… -
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…
-
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…User_2025-02-07-06-30-13-200 212 views 3 comments 0 points Most recent by Jared Lonsbury Human Capital Management -
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… -
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 101 views 7 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
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…Yuvraj S-Oracle 397 views 14 comments 0 points Most recent by Ramanathan Sockalingam Human Capital Management
-
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…Yuvraj S-Oracle 75 views 4 comments 0 points Most recent by Yuvraj S-Oracle Human Capital Management
-
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…Naveen setti 35 views 1 comment 0 points Most recent by Rachita Mishra-Oracle Human Capital Management
-
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…Lakshmi Prasanna Aaula-Oracle 46 views 1 comment 0 points Most recent by Mairina Human Capital Management
-
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 …
-
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…