Periodic Mass Copy Program (FAMCP) or Calculate Gain/Loss (FARTE) Failed for TAX Book Where Secondary Ledger Disabled (Doc ID 1456064.1)

Last updated on APRIL 21, 2017

Applies to:

Oracle Assets - Version 12.1.1 and later
Information in this document applies to any platform.
Periodic Mass Copy
FAMCP
Calculate Gains and Losses
FARET

Symptoms


When attempting to run Periodic Mass Copy (FAMCP) the following error occurs.

ERROR
-----------------------
FAMCP module: Periodic Mass Copy

ORA-01403: no data found
Error: function fa_xla_events_pvt.update_transaction_event returned failure
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Error: function FA_RETIREMENT_PUB.calculate_gain_loss returned failure
Error: function FA_RETIREMENT_PUB.do_retirement returned failure
Mass Copy failed on this asset and transaction. Please review log file for more information.
Error: function fa_masscp_pkg.mcp_retirement returned failure
Error: function fa_masscp_pkg.do_mass_copy returned failure
Number of successes: 0
Number of warnings: 0
Number of failures: 1
Module Periodic Mass Copy ended with error

 

OR

When running Calculate Gains and Losses (FARET) this error is seen:

At beginning of Calculate Gain/Loss program
Book: ABC_123_TAX
Request ID: 123456789
ORA-01403: no data found
Error: function fa_xla_events_pvt.update_transaction_event returned failure
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: 12345 Asset Number: 111222333 --> ** Failed **
The Asset Id is 111222333

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms