My Oracle Support Banner

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 JANUARY 27, 2020

Applies to:

Oracle Service Contracts - Version 12.2.6 and later
Information in this document applies to any platform.


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!

In this Document

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