Document Sequence Error While Creating Contracts/Clauses: ORA-20001: No Document Sequence Assignment exists (Doc ID 2137174.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

Document Sequence error while creating Contracts
Unable to create Contracts. After we give all the Necessary information in the Create Contract window (BU, Legal entity, Start date , End date, Type of Contract, Primary Party and Currency) , on click of "Save And Close" getting the below error.

ERROR
-----------------------
"ORA-20001: No Document Sequence Assignment exists. Details: A Document Sequence Assignment does not exist for Category Code AuthoringCategory, Application 510, Method Code A, Determinant Type LEDGER, Determinant Value {DETVALUE}, and Transaction Date 2016-05-12. ORA-06512: at "FUSION.APP_EXCEPTION", line 61 ORA-06512: at "FUSION.FND_SEQNUM", line 818 ORA-06512: at "FUSION.FND_SEQNUM", line 946 ORA-06512: at "FUSION.FND_SEQNUM", line 914 ORA-06512: at line 1"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigator -> Contract
2. Create a contract
3. Save

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Create a contract successfully

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