EGL9.2 ALLOCATION OPTION "CALC. NO ROWS AS ZERO" ON BASIS NOT WORKING AS EXPECTED

(Doc ID 2422828.1)

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.

Symptoms

Issue
------------

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.


ACTUAL BEHAVIOR
---------------
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. 
 

EXPECTED BEHAVIOR
-----------------------
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.


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms