EGL9.2:Incorrect SQL Generated At PeopleSoft Allocation Process SQL - FS_ALLC_POOL.iNRZero.iPool
(Doc ID 2899173.1)
Last updated on SEPTEMBER 28, 2022
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
When Zero Pool Amount Option is selected as Calc. No rows as Zero in Pool and the Amount field for Pool is selected as Posted Total Amount in the Allocation Step, the SQL at FS_ALLC_POOL.iNRZero.iPool generated incorrect NOT EXISTS clause where the joins are missing between the records - PS_LEDGER A , PS_TSEL_P_TAO4 TB, PS_TSEL_P_TAO4 TC and this is causing significant performance issue.
Steps to replicate:
The issue can be reproduced at will with the following steps:
1) Define Allocation Step via Main Menu > Allocations > Define and Perform Allocations > Define Allocation Step, make sure that in Pool Tab Zero Pool Amount Option is selected as Calc. No rows as Zero
2) Run FS_ALLC Application Engine from Main Menu > Allocations > Define and Perform Allocations > Request Allocation
3) With a large volume of data a performance issue occurs
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