用戶“運行折舊”,誤勾選為“關閉期間”,還有一部分資產還需要操作報廢和調整,希望后臺打開關閉的資產會計期
系統環境
RDBMS : 12.1.0.2.0
Oracle Applications : 12.2.9
解決方案
由官方提供SQL腳本代碼如下:
/*rollback120.sql - for Release 12.X only(based on rollback115.sql)-- New version on 4/6/15 spooyathNew script for R12 based on rollback115.sqlRemoved the code which deletes / updates fa_books / fa_deprn_summary / fa_deprn_detailNew script does all the validations needed. Added validation to check i