My Oracle Support Banner

Error Received When Attempting to Update Personal Payment Method: ORA-01445 'Could not reserve record (2) Keep trying?' (Doc ID 2732782.1)

Last updated on NOVEMBER 30, 2020

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Warning message is received when updating an assignment's personal payment method. Changes are not saved.

TKPROF on trace shows:

The following statement encountered a error during parse:

SELECT ROWID,RUN_TYPE_ID,EXTERNAL_ACCOUNT_ID,ORG_PAYMENT_METHOD_NAME,PAYMENT_TYPE_NAME,PRIORITY,CURRENCY_CODE,AMOUNT,PERCENTAGE,PAYEE_TYPE,PAYEE_ID,PAYEE_NAME,PRENOTE_DATE,TERRITORY_CODE,PAYROLL_ID,
EFFECTIVE_START_DATE,ORG_PAYMENT_METHOD_ID,PAYMENT_TYPE_ID,ROW_ID,PERSONAL_PAYMENT_METHOD_ID,CATEGORY,ASSIGNMENT_ID,BUSINESS_GROUP_ID,EFFECTIVE_END_DATE,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,
ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,CREATION_DATE,
CREATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,LAST_UPDATE_DATE,COMMENT_ID,OBJECT_VERSION_NUMBER,COMMENT_TEXT,DEFINED_BALANCE_ID,ID_FLEX_NUM,C_BANK_STRUCTURE,PRE_VALIDATION_REQUIRED,PPM_INFORMATION_CATEGORY,
PPM_INFORMATION1,PPM_INFORMATION2,PPM_INFORMATION3,PPM_INFORMATION4,PPM_INFORMATION5,PPM_INFORMATION6,PPM_INFORMATION7,PPM_INFORMATION8,PPM_INFORMATION9,PPM_INFORMATION10,PPM_INFORMATION11,PPM_INFORMATION12,
PPM_INFORMATION13,PPM_INFORMATION14,PPM_INFORMATION15,PPM_INFORMATION16,PPM_INFORMATION17,PPM_INFORMATION18,PPM_INFORMATION19,PPM_INFORMATION20,PPM_INFORMATION21,PPM_INFORMATION22,PPM_INFORMATION23,
PPM_INFORMATION24,PPM_INFORMATION25,PPM_INFORMATION26,PPM_INFORMATION27,PPM_INFORMATION28,PPM_INFORMATION29,PPM_INFORMATION30 FROM PAY_PERSONAL_PAYMENT_METHODS_V 
WHERE business_group_id + 0 = :1 and (ASSIGNMENT_ID=:2) order by defined_balance_id, priority, org_payment_method_name

Error encountered: ORA-01445


MESSAGE ON SCREEN
---------------------------
Could not reserve record (2) Keep trying?

 

The solution from <Note 1081972.1>: Personal Payment Method Error: FRM-40501: Oracle error: unable to reserve record for update or delete was implemented, but did not resolve the issue.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Make update to assignment's personal payment method and attempt to save.


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.