PeopleSoft Enterprise Grants: view PS_GM_TREE_F_TO_VW contains incorrect condition "AND X.EFFDT = N.EFFDT" causing no data to be returned when tree and node have different effective dates (Doc ID 1213513.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Grants - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.
***Checked for relevance on 17-Jan-2014***

Symptoms

When the effective dates of the Tree Definition and the Tree Node are different, the view PS_GM_TREE_R_EF_VW will not select any rows and the line descriptions will be missing on the invoice in Billing.

Changes

Development has modified the application so that the line description is printed correctly on the invoice.

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