Workflow Type "Contract Clause Approval" Erroring After Patch Application - Contracts Minipack J Patch 4028184 (Doc ID 1335352.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Procurement Contracts - Version 11.5.10 and later
Information in this document applies to any platform.
Checked for relevance 03-Nov-2014

Symptoms

Contract Terms Authoring
After applying <Patch:4028184> (Contracts Minipack J), workflow type "Contract Clause Approval"... are in error status.

Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. applying <Patch:4028184>
2. Status Monitor (T) Search for the employee owning the workflow


Workflow Loader Errors

ACTIVITY 'WFSTD/XMLTRANSFORM' is protected, no changes were saved.
wferr:
- 1602: Could not save.
- 1400: Could not save to database. MODE=UPLOAD EFFDATE=<null>
- 1401: Could not upload ACTIVITY entity 'OKCARTAP/ARTICLES_ADOPTION_PROC'.
- 210: Oracle Error: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.WF_LOAD", line 2139
ORA-06512: at line 1
. SQL text: BEGIN WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE(:process_activity_id, :name, :protect, :custom, :value, :value_type, to_date(:effective_date, 'YYYY/MM/DD HH24:MI:SS'), :level_error); END;
$ WFLOAD apps/apps 0 Y FORCE $OKC_TOP/patch/115/import/US/OKCARTAP.wft

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