Journal Posting failing with error in log PERF0005: Oracle error detected in glpsqs() - ORA-20001: An active sequence assignment is found, but an active sequence or sequence version cannot be found (Doc ID 1614547.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.2.3 [Release 12.0 to 12.2]
Information in this document applies to any platform.
Executable:GLPPOS - Posting

Symptoms

Attempting to post journals for a specific Ledger on the start of a new year and all journals are failing with the
following error being seen in the log file:

>> glpsqs() 14-JAN-2014 15:38:59
PERF0005: Oracle error detected in glpsqs() - ORA-20001: An active sequence assignment is found, but an active sequence or sequence version cannot be found: <<name >>

This was working until the start of the new year.
All journals are seeing this issue.

When viewing the sequence assignment it is enabled and not end dated - check via
General Ledger responsibility, Accounting Setup Manager
Accounting Setups -> Accounting Options -> Accounting Sequence -> Update Sequence Context

Verify Sequence is assigned - has a start date and no end date -  correct Balance type, Journal Source and Category are selected

All appears to be setup correctly and should be generating a Document Sequence when posting.

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