Oracle EBS AP付款界面操作提示错误

最新推荐文章于 2023-02-03 23:09:01 发布

跳跃生命线

最新推荐文章于 2023-02-03 23:09:01 发布

阅读量539

点赞数

分类专栏： Oracle EBS 常用模块 #应付模块(AP) 文章标签： Oracle EBS AP付款

本文链接：https://blog.csdn.net/AlexLiu_2019/article/details/125050665

版权

Oracle EBS 常用模块同时被 2 个专栏收录

190 篇文章 10 订阅

订阅专栏

#应付模块(AP)

29 篇文章 0 订阅

订阅专栏

当用户在Oracle EBS或AP系统中遇到'付款单据正在被其他一次性付款使用'及'无法锁定记录'的错误时，可以按照提供的SQL查询步骤进行排查。通过查询DBA_OBJECTS、V$LOCKED_OBJECT、V$SESSION和DBA_LOCKS等系统视图，找出锁定支付文档的会话，并使用ALTER SYSTEM KILL SESSION命令终止该会话，从而解决问题。

摘要由CSDN通过智能技术生成

Oracle EBS AP付款界面操作提示错误

由于其他一次性付款正在使用此付款单据，因此您不能选择此单据

无法锁定此记录。原因：另一个用户正在修改此记录

You cannot select this Payment document because it is in user by other single payment.Please select another payment document

解决方法

In the instance where user can reproduce the issue run the following queries:

1) select * from dba_objects where object_name like ‘CE_PAYMENT_DOCUMENTS’
and owner = ‘CE’;

2) select * from v$locked_object where object_id in (select object_id from
dba_objects where object_name like ‘CE_PAYMENT_DOCUMENTS’and owner = ‘CE’);

3) select * from v$session where sid in (select session_id from
v$locked_object where object_id in (select object_id from dba_objects where
object_name like ‘CE_PAYMENT_DOCUMENTS’and owner = ‘CE’));

4) select * from dba_locks where session_id in (select session_id from
v$locked_object where object_id in (select object_id from dba_objects where
object_name like ‘CE_PAYMENT_DOCUMENTS’and owner = ‘CE’));

Query result 3 provides the session which is having the lock of payment document.

Kill the session which is locking the 'CE_PAYMENT_DOCUMENTS' table

alter system kill session 'session,serial';