Forecast Interactive Report Is Not Displaying Revenue When Account Description Is Too Large (>= 30 Characters).

(Doc ID 1991415.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Functionality

When reviewing the Forecast Interactive Reports for the "GL Detail Revenue By Account", The report displays does not show the Revenue Forecast amounts when the number of characters for Account Description and Account value crosses 30 characters.
An error is thrown in analytic server logs
When attempting to run ca_ae_bam app engine, there is an issue when building account description fields which are passed to the grid. When description fields are too long, the cause the analytic engine to fail with messages like this: PSANALYTICSRV.3407 (1) [2014-11-26T11:48:25.176 XXXXX@XXX.XXX.X.XXX ProbInst2](0) (ANALYTICSRV): Member Customer Payment Discounts (620000) is 35 characters long. The maximum allowed length is 30 characters. Involved steps are ca_ae_bam.get_rd.ac3 and ac4
the following error occurs.

ERROR
-----------------------
PSANALYTICSRV.4292 (1) (ANALYTICSRV): Member Product Revenue678901234567890 (400000) is 39 characters long. The maximum allowed length is 30 characters.
PSANALYTICSRV.4292 (1) (ANALYTICSRV): Member ID's cannot exceed a certain length. Please check the Member ID either in the Tree or in the Data table and make sure that it is within the limits. If not please correct it and reload the model.
PSANALYTICSRV.4292 (1) (ANALYTICSRV): Member Product Revenue678901234567890 (400000) is 39 characters long. The maximum allowed length is 30 characters.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. In Demo, Navigate to Set up Financial Supply Chain > Common Definitions > Design Chart Fields > Chartfield values. Choose Account and Modify the account description for 400000 as 'Product Revenue678901234567890'
2. Create a Contract and add Rate based contract lines.
3. Populating the accounting distribution such that Revenue Forecast details are populated. Make sure the account chosen as 400000
3. Navigate to Customer Contracts > Forecast > Create Forecast and create a Forecast. Populate the estimate amount ($5000) and any other required fields.
4. Navigate to Customer Contracts > Forecast > Forecast Interactive Report and enter the parameters for the Contract and Launch Interactive Reports
5. Select "GL Detail Revenue By Account" from the drop down.
6. Forecast values are not displayed.
7. Now modify the Account description to 'Product Revenue' and then run the same Interactive Report again.
8. The value of 416.67 is displayed for forecast revenue for that account.

The expectation is step #6 should have displayed the forecast revenue amount as well for the account with complete account description.

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