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.

Symptoms

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
Batch Name: MASSRET-XXXX
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.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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