Journal Posting Error: Sequence Assignment failure 'No Valid Assignment found as the sequence is disabled'
(Doc ID 2191352.1)
Last updated on APRIL 13, 2023
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.1.11.1.0 and laterOracle Fusion General Ledger - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
Symptoms
Journals contain posting errors with the following error message:
ERROR
-----------------------
Error - Sequence Assignment failure
LOG FILE ERROR:
Inside the FUN_SEQ.Get_Assigned_Sequence_Info
Calling get_assign_context_info
End of calling get_assign_context_info...l_seq_context_id = 30000000######
p_application_id = 101
p_table_name = GL_JE_HEADERS
Calling get_assigned_sequence_header
No Valid Assignment found as the sequence is disabled
End of calling get_assigned_sequence_header
l_assignment_id =
l_seq_header_id =
l_req_assign_flag = Y
No Valid Assignment found as the sequence is disabled
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to General Ledger > Journals > Manage Journals
2. Go to Require Attention Tab and journals reflect error above for each journal batch
Cause
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
| Symptoms |
| Cause |
| Solution |