Combo-Edits Error On Define Par Location Page Not Firing As Expected
(Doc ID 2566740.1)
Last updated on SEPTEMBER 07, 2021
Applies to:PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On Define Par Location noticed the chartfield combo-edit error program not firing/checking for errors as expected.
For example, in the past when you change the replenishment option from stock to non-stock and click Save, the combo-edit checks the entire par for combo errors. Attached is example of where the account is billable and dept is non-billable, we are expecting an error for this combination.
The only way it would trigger the error is when user clear all the chartfields values and manually entered them back.
The issue can be reproduced at will with the following steps:
1.Create a new Combintaion. Combination Definition. Use two fields Account and Department
2.Create a simple combination rule and populate the Combination Definition
3.Create a Combination Group. Mark the Anchor Values Not in Rules as Invalid so that other values are not allowed
4.Populate the Process Group for the Ledger
5.Build the Combo data for the BU US001 and RECODRING ledger
6.Make sure you have Combo Edit enabled for INV BU
Issue replication -
1.Define Item > Purchasing Attributes > Account set to 212020
2.Inventory > Replenish Par locations > Define Par location >
BU - US010
Par Location ID - XXXX
ItemID - 10008
Optimal Qty - 1
3.Click on Chartfield overrides and enter same account value as define on Purchasing Attributes setup
4.Enter valid Department value > Click Ok and save
User change the Account on the Purchasing Attributes page.
And here customer have a custom batch job which runs every night to update the Account for the item on the Par Location page
5.Here we ran backend SQL update to update Account on Par location line page
Update PS_CART_TEMPL_INV set account ='210000' where business_unit ='US010' and INV_CART_ID = 'XXXX'
The Account on the Par Location is updated
6.But based on our Combo Setup, Account 210000 & Dept 13000 is not valid.
7.Account was updated through back end, now having wrong combo edits.
Looks like the combo edit validation takes place only when user do a field change on the Account. Whereas if for some reason customer change the compartment, UOM or any other field on the Line level the combo edit does not fire
Customer would like to have the combo edit fire when click on the Save button and not only on the Field Change for account.
If user change the Account and put the same invalid account online, then the combo edit validation kicks off. Click on the ChartField Overrides link
Now, enter the same Account 210000 again and tab out and then click OK.
8.Click Save, in the Par Location page and the combo edit validation fires.
Invalid ChartField Combination(s) for fields ACCOUNT/ DEPTID in group COMBO_1. Error count: 1. (15500,12) An invalid ChartField Combination for the General Ledger Business Unit,
Primary Ledger Group was entered. Although individual ChartFields may be valid, the combination of ChartFields is invalid. Those that are invalid are marked.
Review the ChartField Combination Rules for the Business Unit/Ledger Group and either modify the rules and rebuild the combination data, or provide a valid ChartField Combination.
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