My Oracle Support Banner

Post Mass Retirements Completed Normal but Assets are not Picked (Doc ID 2866147.1)

Last updated on MAY 13, 2022

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.


Problem Statement
Post mass retirement program completed successfully but they did not picked up.
This is observed for assets where they were initially failing with an error as

Error message
ORA-01403: no data found
Error: function FA_RETIREMENT_PUB.do_validation returned failure
Error: function FA_RETIREMENT_PUB.do_retirement returned failure
This asset failed during retirement. Please view logfile for details.
Error: function fa_cua_mass_ext_ret_pkg returned failure
Number of failures: 1

Log file from current run
Book: XXX Book
Request ID: XXXXXX
Number of failures: 0
Number of successes: 0
Program Post Mass Retirements completed successfully


Steps for replication
This issue is replicated at will by following below:-
1. (N) Mass Transactions > Retirements > Post.
2.  The Post Mass Retirement concurrent program will prompt for the Book and batch number parameters of the retirement transaction.
     After the parameters are entered, select Submit to complete the mass retirement transaction.

Expected Behavior
As the initial error stands corrected and rectified, expectation is such that when Post mass retirement is run
the relevant assets should be picked and processed.





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.