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
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
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: <
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.
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