EGL9.2 ALLOCATION OPTION "CALC. NO ROWS AS ZERO" ON BASIS NOT WORKING AS EXPECTED
Last updated on JULY 13, 2018
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Allocation option "Calc. no rows as zero" on basis not working as expected
Steps to replicate:
The issue can be reproduced at will with the following steps:
1. Setup the Allocation (Type= arithmetic operation , Pool & Basis Zero basis = ‘Calc No Rows as Zero’)
2. Post new journals in order to run Allocation process
3. Run the Allocation process
4. Observe that When Zero basis option selected as ‘Calc No Rows as Zero’, Allocation process should create target rows if pool data exists for a combination but basis data doesn’t.
Please see Replication steps for more details.
Use allocation with arithmetic operation subtract option. The Pool is from Ledger_BUDG and Basis from Ledger_KK. The Basis is defined as "Calc. no rows as zero". When the allocation process is run, the Pool gets calculated on Budget year, Chartfield1 , Deptid, Program code and Implementer. In Basis these fields were specified as well but it does not return any row for one specific Chartfield1 even though Poll has data inside.
When Zero basis option selected as ‘Calc No Rows as Zero’, Allocation process should create target rows if pool data exists for a combination but basis data doesn’t.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms