My Oracle Support Banner

EGL: Journal Generator Leaves JGEN_ACCT_ENTRY.GL_DISTRIB_STATUS = 'J' For Loaded Data Using Generic Accounting Entry Defintion Template (Doc ID 3005444.1)

Last updated on MARCH 24, 2024

Applies to:

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

Symptoms

Data is loaded directly to Record PS_JGEN_ACCT_ENTRY using SQL statements. Journal Generator runs and process is successful. However, the balancing line shows the PS_JGEN_ACCT_ENTRY.GL_DISTRIB_STATUS = 'J', but the journal created is balanced through Create/Update Journal Entries.


STEPS
-----------------------

1. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > Define ChartField Value

a. Add Account 400001

b. Monetary Account Type = Revenue

c. Box checked for General Ledger Account

2. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > Define ChartField Value

a. Add Account 713001

b. Monetary Account Type = Asset

c. Box checked for General Ledger Account

3. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > Define ChartField Value > Add Department = ‘P’

4. Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > Define ChartField Value > Add 3 Products: 61121, 61122, 61610

5. General Ledger > Journals > Subsystem Journals > Journal Generator Template > Add Template = REVACC
- Summarization tab > radio buttons selected for Summarize to All ChartFields, All Account Values, Retain Detail (grayed out)

6. General Ledger > Journals > Subsystem Journals > Accounting Entry Definition > GENERIC definition - no changes

7. Run the six SQL's contained in attachment SR_3-35642114851_Updated.sql

8. General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem

a. Box checked for Edit, Post

b. Accounting Definition Name = GENERIC

c. Template = REVACC

9. Query JGEN_ACCT_ENTRY

a. TRANSACTION_ID = POR0207892

b. JOURNAL_ID = blank

c. JOURNAL_DATE = (null)

d. GL_DISTRIB_STATUS = ‘J’

10. General Ledger > Journals > Journal Entry > Create/Update Journal Entries > Journal is balanced, Journal Status = ‘P’

Changes

 

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
Changes
Cause
Solution


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