My Oracle Support Banner

ORA-04063: rule set "APPLSYS.WF_DEFERRED_R" has errors in Package JTF_NOTES_PUB Procedure Secure_Create_note OKC_CONTRACTS_UNEXP_ERROR (Doc ID 1970292.1)

Last updated on JUNE 10, 2019

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


After a workflow issue, when Business Rule Monitor suddenly stopped, sales order shipment transaction failed to update Install Base with following error:

ERROR
-----------------------

ORA-04063: rule set "APPLSYS.WF_DEFERRED_R" has errors in Package JTF_NOTES_PUB Procedure Secure_Create_note OKC_CONTRACTS_UNEXP_ERROR (SQLcode=-1086) (SQLerrm=ORA-01086: savepoint 'Create_K_coverage_ext_PVT' never established in this session or is invalid ORA-06512: at "APPS.OKC_API", line 80 ORA-06512: at "APPS.OKS_COVERAGES_PVT", line 10380 ORA-06510: PL/SQL: unhandled user-defined exception)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(R): Install base Administrator
(N): Transaction Error Summary and Details form
Query affected serial number
Above error will be displayed

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!


In this Document
Symptoms
Changes
Cause
Solution


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