Post Mass Retirements (FAMPRET) is Failing with Error ORA-01403 for Mass External Retiremements, but All Assets are Successfully Processed (Doc ID 1315152.1)

Last updated on JUNE 11, 2016

Applies to:

Oracle Assets - Version 11.5.10.2 and later
Information in this document applies to any platform.
Post Mass Retirements (FAMPRET)
***Checked for relevance 25-Jan-2013***

Symptoms


When attempting to run Post Mass Retirements (FAMPRET), to process mass external retirements, the following error appears in the log file, but all records are processed successfully:

ERROR
-----------------------
Number of failures: 0
Number of successes: 3
APP-OFA-48400: ORA-01403: no data found

Number of successes: 3
Number of failures: 0
Module Mass Retirements ended with error

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Insert lines in fa_mass_ext_retirements, having batch name as text (string of characters like 'MASSRET-xxx').
2.Run Post Mass Retirements without entering batch name.


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

Obs:
If it's selected one batch name, when submitting the Post Mass Retirements Request, the program is completed successfully. But this workaround might not be convenient if several batches need to be loaded at the same time.

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