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 laterInformation in this document applies to any platform.
Symptoms
Warning message is received when updating an assignment's personal payment method. Changes are not saved.
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 |