Oracle DB解锁和 rerun FA depreciation代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】 Oracle DB解锁和 rerun FA depreciation

作者:Dezai.CN / 发布于2011/7/14/ 1401

<div>
--被锁的对象
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.
</div>

试试其它关键字

　解锁　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)