R12: AP: Unable to Unapply Prepayment Due to Error: "APP-SQLAP-10000: ORA-02049: timeout: distributed transaction waiting for lock occurred in update_payment_schedule<-Unapply_Prepay_Line with parameters"
(Doc ID 2963213.1)
Last updated on JULY 24, 2023
Applies to:
Oracle Payables - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
Prepayment is not getting unapplied from standard invoice due to error
ERROR
-----------------------
AP.PLSQL.AP_PREPAY_PKG.Update_Payment_Schedule Update ap_payment_schedule for the recoupments
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log"APP-SQLAP-10000: ORA-02049: timeout: distributed transaction waiting for lock occurred in
update_payment_schedule<-Unapply_Prepay_Line with parameters (Invoice_id = XXXX APPLY_AMOUNT = 0 APPLICATION_TYPE = UNAPPLICATION APPLY_AMOUNT_REMAINING = 0 CURSOR_AMOUNT = 1111 CURSOR_PAYMENT_NUM = 1 USER_ID = XXXX LAST_UPDATE_LOGIN = XXXX PAYMENT_CURRENCY_CODE = INR)
while performing the following operation:
Update ap_payment_schedule for the recoupments"
STEPS TO REPRODUCE
-----------------------
Login to Oracle and Navigate to Oracle Payables Responsibility : Invoices - Entry- Invoices -
Query the Invoice Workbench- Invoice Num : XXX --> Actions --> Apply/Unapply Prepayment --> tick the checkbox Unapply
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 |