My Oracle Support Banner

EAR 9.2: Pending Item Group Accounting Entries Page Not Triggering Expected Error Message (6030,977) When the Generated Accounting Lines Are Not Balanced for a Credit Item if ChartField Inheritance Is Enabled (Doc ID 3020818.1)

Last updated on MAY 06, 2024

Applies to:

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

Symptoms

Having enabled ChartField Inheritance on Department ID to Always Inherit for the Inheritance Group of Receivables and Billing, a problem has been identified when manually creating the Accounting Entries of a new Credit Amount transaction at the Pending Item Group component. The system is not triggering the expected Error Message (6030,977) letting the User know that the Department ID is needed for balancing in case it is left blank, allowing the save of the entries.

If the same scenario is performed, but this time on a positive amount Item, the system promptly throws Error Message (6030,977) online if the Department ID ChartField is left blank.

This is due to a typo in the delivered codeline from Application Designer Record Field PeopleCode PENDING_ITEM.ITEM.SaveEdit, having a hardcoded value of IT02, when instead, it should be pointing to System Function IT-02.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application as a System Administrator User
    2.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > ChartField Inheritance > Define CF Inheritance Options
    3.- Open existing ChartField Inheritance Group AR/BI, and ensure that Department ChartField is set to 'Always Inherit'
    4.- Navigate to: Set Up Financials/Supply Chain > Common Definitions > Distribution Accounting > Distribution Code
    5.- Define a Distribution Code for the FIN Receivables Control system-generated Accounting Entry (Example: AR), where the Account is defined, but the Department ID is left blank
    6.- Navigate to: Set Up Financials/Supply Chain > Product Related > Receivables > Payments > Define Item Entry Type
    7.- For Entry Type CR (Credit Memo/Item), and System Function IT-02, define the accounting needed for the Entry Reason line (if any) with an AR Distribution Code of AR, and the Accounting Template settings, leaving the Department ID ChartField blank
    8.- Log into the FSCM Online Application as a FIN Receivables User
    9.- Navigate to: Accounts Receivable > Pending Items > Online Items > Online Item Group Entry
    10.- Create a new Pending Item Group under the desired Business Unit, Customer ID, and other desired values, making sure that the Amount is negative (Example: -500.00 USD)
    11.- Notice that at the Pending Item 1 tab, the AR Distribution Code field has been auto-populated by the system with the configuration default (Example: AR)
    12.- Go to the Group Action tab, and click on BALANCE button to save the transaction
    13.- Go to the Accounting Entries tab
    14.- Click on the lightning bolt icon to have the system generate the Accounting Entries from the main defaults (System Function IT-02 comes into place, as it is a negative amount Item)
    15.- Confirm  that there are 2 generated rows: User and AR Types
    16.- Proceed to manually delete the User Accounting Entry row
    17.- Click OK on the Delete Confirmation pop up message
    18.- Click on SAVE button
    19.- PROBLEM: The system validations are not triggering Error Message (6030,977) stating that due to ChartField Inheritance configuration, the Accounting Entries are not balanced by Department ID value, as per needed

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the problem.

ERROR MESSAGE:

    " ChartField DEPTID is set to Always Inherit, and it needs to be balanced for pending items. (6030,977)

      Please enter the ChartField value to make sure the entries balanced. "


The system is allowing the User to create and save unbalanced Accounting Entries, which could cause further problems later on, once the Pending Item Group is set to Post Action Batch Standard, and AR Update is launched, leaving the Group ID with incomplete Accounting Entries.

Just as with Debit Amount Items, (System Function IT-01), the system should trigger the proper validations, and display Error Message (6030,977) letting User know of the unbalanced Accounting Entries, and lack of Department ID ChartField Inheritance value. The codeline from Application Designer Record Field PeopleCode PENDING_ITEM.ITEM.SaveEdit should point to System Function value IT-02.

NOTE: In the images/screenshots/examples mentioned and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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
References


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