Reporting Sequence Is Not Genereated Correctly When Closing Multiple Periods Simultaneously
Last updated on MARCH 23, 2017
Applies to:Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
XLAREPSEQ Create Reporting Sequence Number program
When attempting to manually enter a journal for January period, observe that the new entered/posted journal is numbered with a value that seems to continue from the previous year numbering range.
The Sequencing Context is defined with Sequence Event : 'GL Period Close' for 'GL Journal Entry'.
The expectation is that the sequence to be restarted each year with sequence number 1 from the 1st of January.
The issue can be reproduced at will with the following steps:
1. Go to the General Ledger responsibility
2. Navigate to Journals > Enter > Enter and Post a new Journal Entry in the first period of the year
3. Check the Reporting Sequencing Number
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