Data Models
Discussion List
-
HSDL Template to load DFF values in Employment pageSummary: Hi Team, We have configured the DFF value in the Employment page,and need to load the values to list of associates. We tried using HDL Template to load but when…Madhavi konduru-Oracle 73 views 9 comments 0 points Most recent by Madhavi konduru-Oracle Human Capital Management -
Query to get assignment category in Positions pageSummary: I am building a BIP report for the active positions in Fusion. I need to fetch the actual Assignment Category found in Positions page: In hr_all_positions_f tab…Patricia Azucena 280 views 2 comments 0 points Most recent by Patricia Azucena Human Capital Management
-
Which table have nationality information in Oracle HCMSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Add role restriction of table access while developing the sql query and not while viewing the reportSummary: For OTBI and BIP we want restriction to be added on table access while coding the reports for specific modules. The client wants to code reports in the system u…Tarushee Agarwal 1 view 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
Manage Registration ReportSummary: Manage Registration Report Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the active State Withhol…Parag Hiremath 3 views 0 comments 0 points Started by Parag Hiremath Payroll and Global Payroll Interface (GPI) -
"Report Category for Workers" and "Report Category for Third-party Payees" Organization MethodSummary: "Report Category for Workers" and "Report Category for Third-party Payees" Organization Payment Methods Content (please ensure you mask any confidential informa…Visu 13 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Can i get the full query for the last Updated dates made to our approval rules?Summary: Data extraction for audit purpose - last updates made to our approval rules Content (please ensure you mask any confidential information): The auditor has reque…Global Support Desk 21 views 2 comments 0 points Most recent by Global Support Desk Human Capital Management
-
Create user account using rest apiDear All, I am attempting to create a worker using the REST API (/hcmRestApi/resources/11.13.18.05/workers). It automatically generates the user, but when I set the user…
-
Data model not showing edit option in Reports and AnalyticsSummary: We have came across a issue where we are not able to see Edit option for one data model. It shows only properties and More. Edit is not visible We tried to chec…
-
SQL TO GET REQUEST FOR MORE INFORMATION TRANSACTION DETAILS in Absence Transaction in FUSION HCMHi Experts, I am looking for SQL to fetch the Request for more Infomation by Approver in Absence Transaction in oracle fusion HCM. Please let me know the tables or SQL R…
-
I need a query to get the last updated datesHow to get the last updated Dates made to our approval rules for Job Offer, Job Requisition Approval, Termination, Resignation, Salary ChangeGlobal Support Desk 31 views 2 comments 0 points Most recent by Global Support Desk Human Capital Management
-
-
Where is Bypass Approval info stored in backend?Summary: On transaction console we have checkbox to ByPass Approval for a process. Where is this information stored on backend. We want to find out who has updated the f…
-
Electronic Signature loading wrong document of recordsSummary: Electronic Signature loading wrong document of records. When we process the Acknowledgement of Policy Journey the data from the first Journey is re-populated on…
-
Is it somehow possible to increase fields or flexfields characters?Hi Community, We know that Flexfields are limited to 150 characters. However, our customer needs to store more than that amount of characters on the Position Page in one… -
Document Number is empty in FND_DOCUMENTS_VL tableSummary: Hi all, I have an issue when I try to retrive a file loaded on a Document of Record. I use this query because I need to retrieve DM_VERSION_NUMBER,DM_DOCUMENT_I…teresa.marciano 51 views 7 comments 0 points Most recent by teresa.marciano Human Capital Management
-
how manage decree dataSummary: How to manage in Oracle HCM data of ministerial and administrative decree for Employee in the context of Public Administration. Content (please ensure you mask …
-
Weekly working hours - Lov issueSummary: Hello In the field "Working hours frequency", if we select one of the value, we can't go back to an empty field, and then we must enter a value for the working …Alexis_Mogne 22 views 1 comment 0 points Most recent by Girish Singh-Oracle Human Capital Management
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 21 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Human Capital Management -
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… -
Value Set Query to Get Unique Assignment DetailsHi Team, Need input on Value set Creation to get unique assignment details out of multiple rows. Currently, I am using the below query which gives me 2 rows, due to same…
-
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 …Shubham Khandelwal - Accenture 132 views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Human Capital Management
-
HDL loading error LegalEmployerNameSummary: I'm trying to test the bulk load of a HDL file but getting the below error: The METADATA line can't be processed because the LegalEmployerName attribute is unkn…Maria Smith- de Novo Solutions 13 views 4 comments 0 points Most recent by MandeepGupta Human Capital Management
-
Flexfield on Salary pageSummary: Hello, I'm looking to display a Flexfield on different salary pages such as Change salary, salary history. I setup a FF thinking that I was on the right pages (…
-
Resignation Approval reportSummary: We have a requirement to fetch Approvers and Approved date all the Resignation transaction from the system. We were able to retrieve the information for the rec…
-
Include Last Working Day in workflow notification for terminationgood morning experts Could someone help me so that this Last day worked field can be added to the termination notification, I have tried to add it in the MD but I do not…
-
Maximum SSP Weeks report replacement in HCM CloudHi, Our client has been using Maximum SSP Weeks report in EBS. This is out of the box report and they're now looking into getting the same data from cloud HCM. Does anyo… -
How to Add Representative information into ExtarctSummary: Hi Expert, I need your assistance regarding adding representative information to the worker Extract File. I tried to search the user entity for the area of resp…Saher 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Tax Withholding AssociationsSummary: In what table are the Tax Withholding Associations stored? I need to query this data using a Data Model. Content (please ensure you mask any confidential inform…Al Darabaris 32 views 2 comments 0 points Most recent by Al Darabaris Payroll and Global Payroll Interface (GPI)