My Oracle Support Banner

GP MEX: When Changing Payment Type in Request Loan Mex Page The Error Message "Duplicate Key Value (15,7)" Appears. (Doc ID 3062878.1)

Last updated on FEBRUARY 13, 2025

Applies to:

PeopleSoft Enterprise HCM Global Payroll Mexico - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unable to update (change the loan payment type) in Request Loans MEX from flat amount to percentage.

Steps to reproduce the issue:

1.Navigate to Global Payroll & Absence Mgmt > Payee Data > Loans > Request Loans MEX and select the employee who have the CRED INFONAV loan:

Employee loan data:

Loan Definition
------
Date: 01/01/2024
Total Amount: 99999999.0000
Payment Type: Flat Amount

Loan Details
-----
01/01/2024 ICV - Loan Definition

Loan Schedule
-----
01/01/2024 Payment Amount 1000

2.Change the Payment Type to ‘Percentage’.

Update the following fields:

Payment Type: Percentage

Loan Details
-------
Date 04/22/2024 - ICV - Loan Definition

Loan Schedule
-----
04/01/2024 Percentage 20

3. Error Message
Duplicate key value (15,7)


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.