My Oracle Support Banner

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

Last updated on JULY 11, 2022

Applies to:

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


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.

"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"

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

1. Navigator -> Terms library
2. Create a clause
3. Save


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

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