Oracle DB解锁和 rerun FA depreciation
来源:互联网 发布:公司样本制作软件 编辑:程序博客网 时间:2024/05/21 17:50
--被锁的对象
select t2.SID, t2.SERIAL#, t2.MACHINE, t3.*
from v$locked_object t1, v$session t2, sys.obj$ t3
where t1.session_id = t2.sid
and t1.OBJECT_ID = t3.obj#
order by t2.logon_time;
---Kill session.
alter system kill session 'sid,SERIAL#';
To implement the solution, please execute the following steps:
1) Check status of corporate book and related tax books to find which all have status of 'S'.
2) Run following update scripts in tax book(s) for which status in 'S'.
update fa_book_controls
set deprn_status = 'E',
deprn_request_id = NULL,
mass_request_id = NULL
where book_type_code = '&book'
Then run depreciation for that tax book(s) without closing period and then rollback it.
3) Then run same update scripts for Corp book.
For example:
update fa_book_controls
set deprn_status = 'E',
deprn_request_id = NULL,
mass_request_id = NULL
where book_type_code = '&book'
Then you should be able to run depreciation for the Corp book.
- Oracle DB解锁和 rerun FA depreciation
- Oracle、SQLServer中如何锁定DB和解锁DB
- 4、索引后缀(IA,IB,DA,DB)和堆栈后缀(FD,FA,ED,EA)
- oracle 查看锁和解锁
- oracle表被锁查询和解锁
- oracle 锁表和解锁
- Oracle中的开锁和解锁
- Oracle锁表和解锁
- oracle 查询锁和解锁
- EM算法和FA
- Tivoli 中的RERUN 和 STOP 的区别
- 【DB.Oracle】Oracle用户和权限
- fa
- fa
- fa
- fa
- FA
- fa
- TCP/IP
- Flex中DataGrid绑定(嵌入)ComboBox
- struts1.x bean:write 标签的使用
- IIS启动失败解决办法和思路
- 装了Windows Live Writer
- Oracle DB解锁和 rerun FA depreciation
- 如何让若干个div处于同一行
- char * 为空,为零的区别
- 对map的遍历
- epoll 例子
- 查找相同类名的控件句柄
- CC2430基础实验——外部中断
- SmtpClient发送邮件(用户找回密码)
- JavaScript中数组sort方法的跨浏览器问题