Post Mass Retirements (FAMPRET) is Failing with Error ORA-01403 for Mass External Retirements, but All Assets Are Successfully Processed

(Doc ID 1315152.1)

Last updated on NOVEMBER 29, 2017

Applies to:

Oracle Assets - Version and later
Information in this document applies to any platform.
Post Mass Retirements (FAMPRET)


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:

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

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.


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