Signing History is not being Cleared from the CS_CONTACT Table when a New Amendment is Created
(Doc ID 2600248.1)
Last updated on MAY 25, 2021
Applies to:PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 and later
Information in this document applies to any platform.
Signing history is not being cleared from the CS_CONTACT table (where the external signer details are stored) when a new amendment is being created for an existing agreement. When routing the amendment for e-Signature through Adobe Sign, the system is updating the signing details with the signing history from the previous version of the document. If the new version of the document is being sent for e-Signature and the external signer is listed as signer 2, once the first signer has signed the agreement, the signature status updates to fully signed even though the second signer (the external signer) has not yet signed.
The issue can be reproduced at will with the following steps:
Add a new PO Contract.
Click Add a Document
Click Import Document
Make sure to select a PDF document to import.
Click Done with Import
Click Prepare and Route for e-Signature
Enter two Signers
Select the External Signer checkbox for signer 2
Click Send to route for eSignature
Document has been sent for signature
Signer 1 signs the document
Signer 2 signs the document
Click Get e-Signature Status button to update the signing details and set the status to signed
Change Delivery Method to Manual and click OK
Click Execute Contract
Run query below to view external signer CS_CONTACT row details (SELECT CS_DOC_ID, EMAILID, CS_SIGNER_FLG, CS_SIGN_NBR, CS_SIGN_STATUS, CS_SIGN_DTTM FROM PS_CS_CONTACT WHERE CS_DOC_ID = 'xx')
Run query below to view external signer CS_DOC_COL_USER row details (SELECT CS_DOC_ID, EMAILID, CS_SIGNER_FLG, CS_SIGN_NBR, CS_SIGN_STATUS, CS_SIGN_DTTM FROM PS_CS_DOC_COL_USER WHERE CS_DOC_ID = 'xx')
Click Create Amendment button
Status is now Draft and Amendment is 1
Run the select statement again to view the external signer
Run the select statement again to view the Internal Signer
Click ByPass Approvals to set the status to Approved
Click Prepare and Route for eSignature
Make no changes to signers. Click Send button
Prior to signing expand Signing Details. Issue (#1 Note that the signature for the External signer is already displaying a Signed DTTM and signed status of Signed, although he has not yet signed the document.)
Only Signer 1 signs the document
Click Get e-Signature Status
Issue #2. Document sows as fully signed even though only the first signer has signed
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