EGL: Saving Allocation Step in Allocation Type = 'Arithmetic Operation' and Zero Basis = 'Calc. No Rows as Zero'' Returns Error:'At least one Group By field must be specified for Arithmetic Operation type of Allocation. (5060,79)'.
(Doc ID 2936511.1)
Last updated on SEPTEMBER 25, 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
Allocation Step with Allocation Type = 'Arithmetic Operation', and on Basis tab, Zero Basis = 'Calc. No Rows as Zero' errors at save.
Error:
At least one Group By field must be specified for Arithmetic Operation type of Allocation. (5060,79)
For Arithmetic Operation type of Allocations to Add or Subtract between Pool and Basis, when the Zero Basis option is "Calc. No rows as Zero",
at least one Target or Offset field should be a Group By field to associate between Pool and Basis data.
For Arithmetic Operation type of Allocations to Add or Subtract between Pool and Basis, when the Zero Basis option is "Calc. No rows as Zero",
at least one Target or Offset field should be a Group By field to associate between Pool and Basis data.
Steps to replicate:
1. Navigate to Allocations > Define and Perform Allocations > Define Allocation Step.
2. Set Allocation Type = Arithmetic Operation, set all required fields.
Under Basis tab, set Zero Basis to ‘Calc. No Rows as Zero’.
3. Save.
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 |
| References |