Saturday 28 June 2014

Depreciation calculation Process stuck in Nosuccess and Error.


Depreciation calculation Process stuck in Nosuccess and Error.
then execute the below statement and correct the run control id and rerun the process.
SELECT count(*) FROM PS_OPEN_TRANS                                                          
WHERE BUSINESS_UNIT = '22000'AND CALC_DEPR_STATUS = 'I'
(5 Rows Selected)

 

UPDATE  PS_OPEN_TRANS
SET CALC_DEPR_STATUS = 'P'
WHERE BUSINESS_UNIT = '22000' AND CALC_DEPR_STATUS = 'I'
(5  Rows Selected)