[ FA ] Fixed Assets \ Assignment (APP-OFA-48240 / APP-OFA-47038 / APP-OFA-47661)

使用固定資產若當初AP轉入時有分割, 但產生過折舊後卻無法再合併(merge)
只是點選Assignment 之後, 再點進去看就出現Error

APP-OFA-48240: The units in FA_ASSET_HISTORY and FA_DISTRIBUTION_HISTORY and different

查詢FA \ Inquiry \ Transaction History 時會有多筆的錯誤

Run Depreciation Request has error

1) 檢查移轉的交易資料

畫面路徑: FA \ Inquiry \ Transaction History

TABLE 1: FA_DISTRIBUTION_HISTORY

TABLE 2:fa_transaction_headers.transaction_header_id

TABLE 3:fa_transfer_details.transf_header_id

2) 檢查累計折舊金額

畫面:FA \ Assets \ Asset Workbench \ books按鈕 \ Accumulated Depr (累計折舊)

TABLE: fa_deprn_summary.DEPRN_RESERVE

REPORT 

執行RUN Depreciation \ 完成後會有Request : Journal Entry Reserve Ledger Report 查詢各類資產的折舊與累計折舊金額

Report 

3) 檢查本期折舊金額(注意期間)

3.1 FA_DEPRN_DETAIL. COST / DEPRN_RESERVE 金額有誤

3.2 FA_DEPRN_SUMMARY. DEPRN_RESERVE 金額有誤

3.3 更新fa_adjustments. ADJUSTMENT_AMOUNT

update fa_adjustments set ADJUSTMENT_AMOUNT = 255 where asset_id = 100000963   and transaction_header_id = 7161   and adjustment_type = 'COST'

update fa_adjustments set ADJUSTMENT_AMOUNT = 235 where asset_id = 100000963   and transaction_header_id = 7161   and adjustment_type = 'RESERVE'

4) APP-OFA-47038: Error: An inactive distribution has a nonzero DEPRN_RESERVE balance: 978 -833

檢查LOG檔內的LOG 明細, 將 DISTRIBUTION_ID帶入查詢

SELECT *

  FROM fa_adjustments

 WHERE DISTRIBUTION_ID = 978

5) APP-OFA-47661: Error: Unable to insert into FA_DEPRN_DETAIL table
檢查LOG檔內的LOG 明細, 將 DISTRIBUTION_ID帶入查詢

SELECT H.DISTRIBUTION_ID

       ,ASSET_ID

       ,UNITS_ASSIGNED

       ,H.TRANSACTION_HEADER_ID_IN

       ,H.TRANSACTION_HEADER_ID_OUT

  FROM FA_DISTRIBUTION_HISTORY H

 WHERE DISTRIBUTION_ID IN (1098, 1099, 1100)

刪除錯誤或多餘的交易資料

delete fa_adjustments

 WHERE ASSET_ID IN (100000963)

   AND LAST_UPDATE_DATE >= TO_DATE('20141201','YYYYMMDD')

  and transaction_header_id  in (7154,7156)

 delete fa_transaction_headers

 where asset_id = 100000963

   and transaction_header_id in (7154, 7156)

delete fa_transfer_details

where transfer_header_id in (7154, 7156)