Data Models
Discussion List
-
Where are absence statuses stored in the tables?We are wanting to add the status of Absences to our reports but we are having difficulty locating them. We have found ANC_PER_ABS_ENTRIES to view absence statuses and Ap… -
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… -
Missing create Data model option under Published Reporting?Summary: Missing create Data model option under Published Reporting? Content (required): Missing create Data model option under Published Reporting? Let me know if any r… -
How to get the original termination date when person is global transferred in fast formula?Summary: Employee joined organization on Jan 2015 and worked till Nov 2020. Later, he got global transferred on 1st Dec 2020. Need to write fast formula to get his termi…
-
Address fields Unique Identifier required for PolandSummary: We require the Unique Identifier for each of the address fields, like code for Address Line 1, Address Line 2 etc and also the Unique Identifier for the values … -
SQL(Table) to get the Countries with Phone Country codesSummary: If we need to fetch the country codes for Phones, this table is really useful. Please see the SQL. Content (required): SELECT TERRITORY_CODE, PHONE_COUNTRY_CODE… -
Create a Department Hierarchy - Organizational Tree or Department Tree?Summary Create a Department Hierarchy in Oracle HCMContent Hello everyone, Currently we are using the Organizational Tree area of Oracle HCM to drive security, meaning t… -
adding data access by roleSummary: Added a data privilege to a security current custom role but need data access to go with that Content (required): we added a data privilege to a security role t…
-
Who has implemented Oracle HCM Cloud and Oracle ERP Cloud on different production instances?Summary: Who has implemented Oracle HCM Cloud and Oracle ERP Cloud on different production instances? Content (required): We would like to discuss the pros/cons and 'les…
-
Need unsecured tables/views for PII related data for open ended reports.Summary: Need unsecured tables/views for PII related data for open ended reports. Content (required): Hi Team, We need to understand how can we have these PII tables(or …
-
Field URL is blank in view fnd_documents_vlSummary: Field URL is blank in view fnd_documents_vl Content (required): We are trying to report on the documents people have, we are trying to use the "URL" field of th… -
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… -
How to change specific Section in a Redwood Theme?Summary: Hi everyone, we are trying to change the theme of a specific section (Directory-My Organization Chart- in ME Tab) to a Redwood theme without changing the system…
-
Document of Records - Attachment is not updated when we are trying to correct/update the data.Summary: we have created a custom report for Document of records and given the path at Document Types. But when we are trying to correct/update the data of existed trans…
-
Regex to extract text from html documentSummary: I need a regular expression to extract words from a html document (or any document which comprises of tags). Content (required): For example, given the followin…
-
General Letters for Document Record is not getting proper values in Draft file.Summary: Unable to get the values in the template in Draft version and final version(after approval created a auto generated file) Content (required): I have created a D…
-
We want to add new primary location under create job requisition which is not available in the listSummary: We want to add new primary location under create job requisition which is not available in the list Content (required): Version (include the version you are usi…
-
Can't access to his teamSummary: When a line manager tries to access screen "My team" and select one of them this error happens Content (required): Version (include the version you are using, i…
-
How to get module column (Finance or SCM) based on the users in user detail reportSummary: Content (required): Hi , I would like to get some query or sample reports to develop a custom user module report as this report is very important for business. …
-
How do we get length of service from backendContent Hi All, How can we get the Length of Service based on any specific date from backend. When we navigate seniority date screen (V3), seniority date is always calcu… -
SQL to extract GeographiesHi! Can someone share an SQL code to extract geographies? We want specifically to extract the values of Postal Code and Cities from Belgium. Kind regards, Pilar Version …
-
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…
-
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…
-
Enable PersonID binding variable for per_passports table.Summary: Hi, Is there any way to enable PersonID or Perosn_ID binding variable for the Per_Passports tabel Content (required): We have requirements where we want to get …
-
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…
-
Seeded Termination Report in Oracle HCMSummary: Good morning everyone, Does anyone know if there is a seeded termination report in Oracle HCM. Also, is there a best practice for verifying inactive employees? …
-
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 41 views 4 comments 0 points Most recent by Maria Luiza Siqueira Human Resources -
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 71 views 6 comments 0 points Most recent by Mandeep Gupta Human Resources