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 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

To view full details, 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 a vibrant support community of peers and Oracle experts.