My Oracle Support Banner

EGL9.2: With Chartfield Balancing Turned On, Edit Journal Process Creates Suspense Lines Not Using Suspense Chartfields. (Doc ID 2974671.1)

Last updated on NOVEMBER 01, 2023

Applies to:

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

Symptoms

Issue:

With Chartfield Balancing turned on, Edit Journal Process creates suspense lines, but not using Suspense Chartfields.
Suspense Configuration is overlooked when Chartfield Balancing/Inheritance is turned on for the Ledger Group for Department and Fund Code.  
Edit Journal process validates the lines and creates the suspense lines, however, ignoring the suspense configuration and is inheriting
the parent line's Department and Fund, further correcting it creates a never ending loop of Suspense Journals.

The issue does not exist when Chartfield Balancing is not turned on.

Steps to replicate:

  1.  Create a new Ledger and define it Ledger Group.
       (General Ledger > Ledgers > Detail Ledger)
       (General Ledger > Ledgers > Ledger Group)
  2.  Set General Ledger Definition set to Recycle.  Note that Suspense will be set up at Source level.
       (Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition)
  3.  In Ledgers for a Unit, define the Combo Edit Group.
       (Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Ledgers for a Unit)
  4.  Ensure proper SetIDs are defined in TableSet Control.
       (PeopleTools > Utilities > Administration > Manage TableSet Controls)
  5.  Ensure Periods are open in Open Period Update page.
      (Set Up Financials/Supply Chain > Business Unit Related > General Ledger > Open Periods > Open Period Update)
  6.  In Ledger Group page, enable IntraUnit Balancing Entries to balance by Department field.
  7.  Chartfield Combination Settings:  (Set Up Financials/Supply Chain > Common Definition > Design Chartfields > Combination Editing)
        - Chartfield Combination Edit Definition.
        - Combination Rule.
        - Define Anchor and Non-Anchor chartfields.  These are values that will be treated by system as valid values.
        - CF Combination Editing Group.
  8.  Run Build Combo Data Request.  
  9.  At Source level, set Journal Balance and Journal Edit Errors Options to Suspend.
       (Set Up Financials/Supply Chain > Common Definition > Journals > Define Journal Source)
10.  Using Spreadsheet Journal Import template, populate Journal header and lines for Source AP, then, import.
11.  Go to Edit Journals Request and run GL_JEDIT process.
      (General Ledger > Journals > Process Journal > Edit Journals)
18.  Go back and review the journal.  Verify that Journal Status = V and that it goes to Suspense.
       Note, however, that a journal line is recorded to an incorrect Department.

See replication document here.

NOTE: In the <images or examples> <above or below> and/or the attached document, user details / customer name / address / email / telephone number represent a fictitious sample (based up made up data used in the Product name test environment). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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


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