Oracle EBS 资产新增提示高速缓冲从 FA_METHODS 表中检索行时出错

Oracle EBS 资产新增提示高速缓冲从 FA_METHODS 表中检索行时出错

高速缓冲：从 FA_METHODS 表中检索行时出错

            折旧方法： STL

            资产寿命（月）：336

原因：数据库出错。

措施：请与系统管理员联系。

ORA-01403: 未找到任何数据ORA-0000: normal, successful completion

错误：功能 fa_cache_pkg.fazccmt 返回失败。ORA-0000: normal, successful completion

Error retrieving row from FA_METHODS table 

Depreciation Method: STL 

Life in Months: 336

Cause: You have a database problem

解决办法 折旧方法中定义 对应的年月即可

1.Navigate to the Depreciation Methods window.

Navigation: Setup: Depreciation > Methods

2.Enter a depreciation Method name and Description.

3.Select Calculated from the Method Type poplist.

4.The calculation basis automatically defaults to Cost (NBV is not valid for calculated methods).

5.Choose whether the depreciation method allows asset depreciation in the year it is retired.

6.Choose the Exclude Salvage Value check box if the method is to exclude the salvage value from the depreciable basis.

7.Enter the number of Years and Months of asset life.

8.Save your work.