加载中…OracleEBSFA按工作量折旧资产运行折旧时错误提示APP-OFA-48066:Error:Illegalvalue(0)
(2024-12-29 17:48:15)
标签：
app-ofa-48066errorillegalvalue(0 |
分类： OracleEBS财务模块 |
Oracle EBS FA按工作量折旧资产运行折旧时错误提示APP-OFA-48066: Error: Illegal
value (0)
Oracle EBS FA按工作量折旧资产运行折旧时错误提示APP-OFA-48066: Error: Illegal
value (0)
1.
APP-OFA-48066: Error: Illegal value (0) for
Adjusted_Capacity
Depreciation Errors with:
Cause: You have a database problem.
Action: Contact your system administrator.
Error: function faxcde returned failure (called from
fadppa)
Error: function fadppa returned failure (called from
fadadp)
Error: function fadadp returned failure (called from
fadmlp)
Error: function fadmlp returned failure (called from
faddep)
Asset ID ###### (XXXXXX) -> ** FAILED **
Depreciation: 20 assets processed
Error: function faddep returned failure (called from
FADEPR)
产生问题原因
调整后的生产能力（即生产能力-ltd_production）不能为 0 或负数。这是一项标准限制。
Issue assets can be identified via:
select asset_id, production_capacity, adjusted_capacity
from fa_books
where adjusted_capacity is not null
and adjusted_capacity <= 0
and date_ineffective is not null
and book_type_code = ''&Book';
解决方法
update fa_books
set production_capacity = '&NewCapacity'
where asset_id = 'AssetId'
and transaction_header_id_out is null;
COMMIT;
2.
Depreciation Run Error: APP-OFA-48066: Error: Illegal value
(0) for Capacity
Depreciation Errors with:
Cause: You have a database problem.
Action: Contact your system administrator.
Error: function faxcde returned failure (called from
fadppa)
Error: function fadppa returned failure (called from
fadadp)
Error: function fadadp returned failure (called from
fadmlp)
Error: function fadmlp returned failure (called from
faddep)
Asset ID ###### (XXXXXX) -> ** FAILED **
Depreciation: 20 assets processed
Error: function faddep returned failure (called from
FADEPR)
数据生产能力为0 年初至今为0 开始使用至今为0
这类资产数据不需要参加折旧，
解决方法
方法1.取消 折旧的勾选
方法2.
数据修复 fa_books
PERIOD_COUNTER_FULLY_RESERVED,PERIOD_COUNTER_LIFE_COMPLETE
修复为相同值
不会参与折旧
-- 刘轶鹤
喜欢
0
赠金笔