Opening Repository Contracts In Draft Status Causes 'No Surrogate Approver Exists' Error
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.
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:
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms