Opening Repository Contracts In Draft Status Causes 'No Surrogate Approver Exists' Error

(Doc ID 2333723.1)

Last updated on NOVEMBER 29, 2017

Applies to:

Oracle Sales Contracts - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

Followed Note 1605160.1 "Error ORA-20002: 3124: Process 'REP_CONTRACT_APPROVAL' For Item 'OKCREPMA/xxxx' Is Not Active" When Attempting to Cancel Repository Contract Approval.

The provided script worked in the environments. The document types returned to DRAFT Status and waiting on the user to re-submit for approval.

Some of the contracts where the script fix was run are giving the following error message:

Error Page "You have encountered an unexpected error. Please contact the system administrator for assistance".

The script returned the contract to Draft as expected but now it cannot be opened to be resubmitted for approval. When the user attempts to open it, the above error message comes up.

Generated the Error stack (attached) and found:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20212: No surrogate approver exists for <User Name>.
ORA-06512: at "APPS.AME_API2", line 1445
ORA-06512: at "APPS.OKC_REP_WF_PVT", line 3045
ORA-06512: at line 1

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