EGL: ORA-12899: Value Too Large For Column "SYSADM"."PS_JCF_BAL2_TAO2"."JOURNAL_DATE" (actual: 9, maximum: 7) , When Running GL_JEDIT_0 - On Line Journal Edit. (Doc ID 1618754.1)

Last updated on NOVEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** checked for relevance 27-Nov-2017 ***

Symptoms

ENVIRONMENT
Release 9.2, Tools 8.53.08, Oracle Enterprise Edition 12.1. 0.1 and above

ISSUE
While running online journal edit GL_JEDIT_0, process abended with error ORA-12899: value too large for column "SYSADM"."PS_JCF_BAL2_TAO2"."JOURNAL_DATE" (actual: 9, maximum: 7)
Batch journal edit runs fine.

STEPS
By following these steps the issue can be reproduced:
1. From the online journal lines page, trigger online journal edit process to run.
2. Process abends

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!

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

EGL: ORA-12899: Value Too Large For Column "SYSADM"."PS_JCF_BAL2_TAO2"."JOURNAL_DATE" (actual: 9, maximum: 7) , When Running GL_JEDIT_0 - On Line Journal Edit. (Doc ID 1618754.1)

Applies to:

Symptoms

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!