My Oracle Support Banner

E1: DB: Journal Receivers Getting Filled Up (Detached Journal Receivers Increasing in Numbers) Due to Records in Table F90012 (Doc ID 2947726.1)

Last updated on JULY 04, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
IBM i on POWER Systems

Symptoms

In 9.2 release when task search feature is enabled, the journal receivers are getting filled up with insert and delete transactions in the table F90012.  When the task search feature is disabled, the number of journal receivers decreases.  When a journal receiver gets filled up, it is detached so the number of detached journal receivers grows in size. 

The command to check the journal receivers is discussed in E1: OS: Primary Note for Journaling Setup, Maintenance and Known Issues with EnterpriseOne on iSeries (Doc ID 1319579.1)

Steps

1. Check the number of detached journals using commands mentioned in E1: OS: Primary Note for Journaling Setup, Maintenance and Known Issues with EnterpriseOne on iSeries (Doc ID 1319579.1)

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
References


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