EGL:7.5 JEDIT Combo Error for Fields ACCOUNT/DEPTID/xx_xxxxx/PRODUCT IN GROUP xx_1
(Doc ID 609104.1)
Last updated on JANUARY 08, 2020
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 7.5 and later
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 689153
*******Checked for relevance on 20-05-2010***
Customer created a Combination Rule with the Effective Date from 01 Jan 1999 to 01 Jan 2099.
Attached the Rule to a Combination Group then attached the Group to a Ledger.
Then created several journals with the dates between June 1999 to Dec 1999.
Some Accounts used in a Combo Rule were then changed in the Tree by moving them to new nodes in the same tree. The Build Combination Data process FSPECBLD (COBOL SQL) was run twice; once for 1 BU for 1 Ledger with options Validate and Purge and again with the option Wildcard in Combination and Explode.
The Journals using these changed accounts were edited resulting in the following Journal Line Edit Errors:
Combo Error for Fields ACCOUNT/DEPTID/XXXXXXX/(chartfield) PRODUCT IN GROUP XX_XX (group).
Customer ran PTUGAPTR to test if the Tree was corrupted and it abended with:
"Cannot insert duplicate key row in object 'PSTREELEAF' with unique index 'PS_PSTREELEAF'
I sent the customer the SQL Scripts to test Tree corruption and asked him to check the Rules.
The results are :
1. The Node_Count & Leaf_Count in the Tree are both consistent.
2. Ran all the Tree Corruption SQL Scripts to check whether the tree is corrupted or not. All return ZERO rows.
3. All the 4 Chartfields, Account, DeptID, Operating Unit & Product are specified in the Combination Rule.
4. The Chartfield Combination Rule 1 panel specifies that DEPTID as a required field. And Chartfield Combination Rule 2 panel contains the Anchor Chart Field Account, and 3 others namely PRODUCT, PROJECT_ID & Operating Unit
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