My Oracle Support Banner

Unplanned Depreciation Errors with ORA-21780: Maximum Number Of Object Durations Exceeded. (Doc ID 886986.1)

Last updated on AUGUST 16, 2019

Applies to:

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

Symptoms

When attempting to do unplanned depreciation,following error occurs

FRM 40735 ON-ERROR trigger raised unhandled exception ORA-01001

After clicking OK another error appears

APP-FND-01564 ORACLE ERROR 3114 in audfrm failed due to ORA-03114 not connected to ORACLE
The SQL statement being executed was &SQLSTMT and was executed from the file

Following this application is disconnected from the server


Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Asset work bench
2. Books
3. Unplanned depreciation

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

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