My Oracle Support Banner

EGL:How to Reset journal_id when Autonumbering exceeds the 10 char limit of the field definition (Doc ID 3077756.1)

Last updated on MARCH 20, 2025

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

When a journal template has mask defined as 'XXXXX' and the autonumbering reaches 99999 so the next Journal ID generated exceeds the 10 char limit of the field definition ('XXXXX99999') Does numbering start over at '00001' or can we reset the next sequence manually?
 

Solution

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
Goal
Solution


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