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.

Symptoms

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

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  

Changes

 

Cause

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