FA 计算损益 请求错误

Calculate Gains and Losses

+---------------------------------------------------------------------------+

Assets: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FARET module: Calculate Gains and Losses

+---------------------------------------------------------------------------+

Current system time is 30-DEC-2009 08:51:41

+---------------------------------------------------------------------------+

日志:

xxx                           Retirements Execution Report                             30/12/2009 08:50:49

At beginning of Calculate Gain/Loss program

Book: XXXX_FABOOK

Request ID: 1300762

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX109833

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX109833

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7006 Asset Number: XXXX109833 --> ** Failed **

The Asset Id is 115129

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX102056

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX102056

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7009 Asset Number: XXXX102056 --> ** Failed **

The Asset Id is 111985

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX102055

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX102055

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7010 Asset Number: XXXX102055 --> ** Failed **

The Asset Id is 111984

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX102054

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX102054

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7011 Asset Number: XXXX102054 --> ** Failed **

The Asset Id is 111983

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX102052

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX102052

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7012 Asset Number: XXXX102052 --> ** Failed **

The Asset Id is 111981

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX102053

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX102053

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7013 Asset Number: XXXX102053 --> ** Failed **

The Asset Id is 111982

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX103950

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX103950

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7014 Asset Number: XXXX103950 --> ** Failed **

The Asset Id is 111628

Cache: Error retrieving fraction of calendar year for:

Calendar Type: XXXX_FA_CALENDAR

Book: XXXX_FABOOK

Fiscal Year: 2010

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcde returned failure

FAXCDE: Error in calculating depreciation

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

Error: function fa_gainloss_dpr_pkg.fagcdp returned failure

FAGCDP: Failed to get depreciation number information for asset XXXX102600

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure

FAGRET: Fail to retire asset XXXX102600

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Retirement ID: 7019 Asset Number: XXXX102600 --> ** Failed **

The Asset Id is 110117

Number of successes: 0

Number of failures: 8

Module Calculate Gain/Loss ended with error

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

+---------------------------------------------------------------------------+

Executing request completion options...

Output is not being printed because:

The print option has been disabled for this report.

Finished executing request completion options.

Concurrent program returned no reason for failure.

+---------------------------------------------------------------------------+

Concurrent request completed

Current system time is 30-DEC-2009 08:51:42

+---------------------------------------------------------------------------+

解决方法:

What-If Depreciation Analysis Ends With ORA-1403 Error Retrieving Fraction Of Calendar Year [ID 397656.1]

Applies to:

Oracle Assets - Version: 11.5

This problem can occur on any platform.

EXECUTABLE:RXFAWD - RX-only: What-If Depreciation Analysis

Symptoms

When attempting to run the What-If Depreciation Analysis (RXFAWD), the following error occurs in the logfile:-

--------------

Cache: Error retrieving fraction of calendar year for:

Calendar Type:

Book:

Fiscal Year:

Cause: You have a database problem.

Action: Contact your system administrator.

ORA-01403: no data found

Error: function fa_cache_pkg.fazcff returned failure

Error: function fa_cde_pkg.faxcfyf returned failure

Error: function fa_cde_pkg.faxcde returned failure

Error calling What-If Engine in Normal mode for asset_id nnnn.

-----------------

Cause

Incomplete calendar setup.

The Depreciation or Prorate Calendar (with the name given in the error message text) is not set up sufficiently far to allow the system to calculate the fraction of the fiscal year (also specified in the error message text).

Solution

To implement the solution, please execute the following steps:

1. Navigate to Setup > Asset System > Calendars

2. Query back the calendar name given in the error message text.

3. Extend the setup right to the end of the Fiscal Year given in the error message text (and this should also be right to the end of the Fiscal Year containing the last period in the What-If request).

4. Save.

5. Re-run the What-If Depreciation Analysis and the report should now complete successfully.