Error While Amending Contract Through UI or SOAP API Web Service - "JBO-29000: Unexpected exception caught: oracle.jbo.TxnValException, msg=JBO-27023: Failed to validate all rows in a transaction" (Doc ID 2917741.1)

Last updated on DECEMBER 29, 2022

Applies to:

Symptoms

On : 11.13.22.04.0 version, Authoring

Can not Amend Contract through UI or amendContract [SOAP Service]


While using Enterprise Contracts with a Subscription contract having lines. (Contract 5246066), user cannot Amend Contract through UI or amendContract [SOAP Service]

An Amend Error occurs when trying to do through UI or amendContract [SOAP Service]


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 step:

Amend a Contract having lines through UI

or

AmendContract [SOAP Service] using:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/contracts/coreAuthoring/contractService/types/" xmlns:con="http://xmlns.oracle.com/apps/contracts/coreAuthoring/contractService/">
<soapenv:Header/>
<soapenv:Body>
<typ:amendContract>
<typ:amendContractParams>
<con:Id>xxxxxxxxxxxxxx</con:Id>
</typ:amendContractParams>
</typ:amendContract>
</soapenv:Body>
</soapenv:Envelope>

Cause

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