My Oracle Support Banner

When Retirement Is Performed Through API 'FA_RETIREMENT_PUB.do_valiation Return Failure' Error Occurs (Doc ID 2992732.1)

Last updated on JANUARY 18, 2024

Applies to:

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


When attempting to perform retirement through API by adding retirement type

the following error occurs.

Error: FA_RETIREMENT_PUB.do_valiation return failure

The API call failed with error User-Defined Exception
The API call failed with error Error: function FA_RETIREMENT_PUB.do_validation returned failure

The issue can be reproduced at will with the following steps:

1. Create Concurrent to execute the retirement API
2. Create Temporary table to pass parameter values to API
3. Execute API script with parameter value for RETIREMENT TYPES
4. Execute the API program
5. Check for Error in concurrent log file


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.