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

Last updated on OCTOBER 20, 2023

Applies to:

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

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

Cause

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