Database Operation Sign Contract Failed Error When Attempting to Activate a Service Contract with Vacation Rules Created to Auto-sign Contracts
(Doc ID 2331957.1)
Last updated on DECEMBER 15, 2017
Applies to:Oracle Service Contracts - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Service Authoring
When attempting to Activate a Service Contract after a vacation rule is created to auto-sign contracts the approval workflow fails and an error notification is generated with the following errors
Data Base Operation Failed
Contract Number: SIGN1
Contract Number Modifier:
Details: ORA-00060: deadlock detected while waiting for resource in Package OKS_WF_K_PROCESS_PVT Procedure complete_activity
Database operation Sign Contract failed.
ORA-06519: active autonomous transaction detected and rolled back in Package OKC_CONTRACT_APPROVAL_PVT Procedure k_signed
The issue can be reproduced with the following steps:
1) Service Contracts (R)
2) Contract Administration(N) Administrator workbench
3) Create Vacation Rules
4) Create a Service Contract and submit for approval
5) Approval workflow fails and error notification is generated
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!