My Oracle Support Banner

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 DECEMBER 20, 2018

Applies to:

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

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.

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
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.