My Oracle Support Banner

E-NV: Multiple Chartfield NPlosion Not Summarizing Data Correctly (Doc ID 2545263.1)

Last updated on JANUARY 08, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

Multiple Chartfield nPlosion Not Summarizing Data Correctly

After customer upgraded to 8.55.26 noticed nVision layout utilizing Multiple Chartfield nPlosion is not pulling all of the information it should be.
Specified the two Business Units in the columns, but the intersection that should be a total of the two business units only appears to capture one side.
All rows that do not have MCnP appear to be totaling the values correctly.

Replication Steps:

Layout:
a. Added one MCnP Criteria
    Ex: %,R,FACCOUNT,TQEQ_ACCTROLLUP,XDYYYYY02,NGENADMIN,FDEPTID,TQEQ_DEPT,NADMIN_DIV,XDYYYYY01
b. Added 2 Timespan columns
    Ex: %,LLOCAL,UPOSTED_TOTAL_AMT,SALLYEAR,FDEPTID,TQEQ_DEPT,V10000%,LLOCAL,UPOSTED_TOTAL_AMT,SALLYEAR,FDEPTID,TQEQ_DEPT,V13000

We can see the same data in both the columns in the generated report but it should not.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.