My Oracle Support Banner

When Searching On The Award Profile Page, Users Are Unable To Search By Project ID. (Doc ID 2403042.1)

Last updated on JUNE 08, 2018

Applies to:

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

Symptoms

On : 9.2 version, Award Profile

ACTUAL BEHAVIOR
---------------
When searching on the Award Profile page, users are unable to search by project ID.

EXPECTED BEHAVIOR
-----------------------
When searching on the Award Profile page, users should be able to search by project ID.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In the Grants BU set up, Point the EGV05 BU to PC BU - US004
2. Go To Award Profile. Open EGV05 and prompt for PC BU

The following SQL is expected
COM Stmt=SELECT PROJECT_ID, DESCR FROM PS_SP_GM_PRJ_NONVW A WHERE BUSINESS_UNIT=:1 ORDER BY PROJECT_ID
Bind-1 type=2 length=5 value=EGV05

The PC BU of US004 needs to be passed so that the Projects in US004 can be displayed as this is the PC BU that is associated with the Grants BU of EGV05

Changes

 

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!


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