Error When Amend Contracts: JBO-29000: Unexpected exception caught: oracle.jbo.TxnValException, msg=JBO-27023

(Doc ID 2235574.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Contract Authoring

When navigating to certain Contract, cannot amend the contract and receive the following error -

Producible in PROD and TEST

ERROR
-----------------------
JBO-29000: Unexpected exception caught: oracle.jbo.TxnValException, msg=JBO-27023: Failed to validate all rows in a transaction.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Contract Management > Contracts
2. Search for contract
3. Click Actions > Amend
4. Click "OK" on the pop-up ("The amendment will be effective after contract approval...")
5. View error message: JBO-29000: Unexpected exception caught: oracle.jbo.TxnValException, msg=JBO-27023: Failed to validate all rows in a transaction.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with the implementation. We cannot amend the contract and therefore cannot continue to use/bill this contract. We have an extension from our sponsor we are trying to put into the system but without success. We need this resolved ASAP to process our costs.

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