E-Record not saved with a Status of 'Successful' or saved as 'Acknowledged' When using the API EDR_SIGN_GRP. ADD_TRANSACTION

(Doc ID 2012911.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle E-Records - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Evidence Store


The E-Record when saved is not being Updated to 'Acknowledged' and the Status set to 'Successful'.

After a successful E-Signature on an E-Record, when User Queries the E-Record in the Evidence Store, it only returned when they query on all statuses. If they query on only records with a successful status it is not returned.

This Standard E signature code is called in Custom form which calls the API EDR_SIGN_GRP. ADD_TRANSACTION


That when the E-Record is saved after being signed it is saved as being being both 'Acknowledged' and the Status set to 'Successful'.

The issue can be reproduced at will with the following steps:
1. Develop a custom E-Record which requires an E-Signature.
2. User a custom form that calls the API EDR_SIGN_GRP. ADD_TRANSACTION to sign it.

The issue has the following business impact:
Due to this issue, the E-Record is not being saved as 'Acknowledged' and the Status set to 'Successful'.


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