EGM- Business Unit Doesn't Get Populated In PS_GM_AWD_SD Upon Saving Supplemental Data Page. (Doc ID 2191152.1)

Last updated on OCTOBER 07, 2016

Applies to:

PeopleSoft Enterprise FIN Grants - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Award Profile

ACTUAL BEHAVIOR
---------------
Business Unit doesn't get populated in PS_GM_AWD_SD upon saving Supplemental Data page.

Navigate to Grants > Awards > Award Profile and click on the Supplemental Data link and enter or change data for the fields on the page, BUSINESS_UNIT (Business Unit) is blank, it doesn't get populated on PS_GM_AWD_SD. Please refer the attachment.

EXPECTED BEHAVIOR
-----------------------
Business Unit should not be blank in GM_AWD_SD

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Step 1: Configure Supplemental Data
• Define Record
o Go to Enterprise Components > Supplemental Data > Define Record
o Click ‘Add a New Value’
o Base Record Name: GM_AWARD
o Supplemental Data Record: TEST_BU
o Click Add
o Description: ‘Test BU on Award SD’
o Data Store Record: GM_AWD_SD

Click ‘Fields Summary’ Tab
o Click ‘Field Name’ hyperlink
o Field Name ‘TEST_DATA’
o Description ‘Test BU on Award SD’
o Field Label ‘TEST’
o Use Type: Text
o Field Length: 50
o Mapped to SD_TEXT50_2
o Click ‘Save’
 
o Click on Record Tab
o Change Status to ‘Activated’
o Click Save
 

• Define Display Group
o Go to Enterprise Components > Supplemental Data > Define Display Group
o Click ‘Add a New Value’
o Base Record Name ‘GM_AWARD’
o Display Group ‘TEST_BU’
o Description: ‘Test whether a BU is populated on the GM_AWD_SD table’
o Label ‘Test’
o Left Column Sequence : 1
o Left Column Record ‘TEST_BU’
o Field Name: TEST_DATA
o Label: ‘Enter Test Data’
  Click ‘Save’

• Assign Display Group
o Go to Enterprise Components > Supplemental Data > Assign Display Group
o Component Name: GM_AWARD
o Click ‘Search’
o Add a row
o Sequence 1
o Display Group ‘TEST_BU’
o Click ‘Save’

Step 2 – Enter test Supplemental Data
• Go to Grants > Awards > Award Profile
• Business Unit: EGV05
• Award ID: CON000000000086 (Any Award ID is fine)
• Click ‘Search’
• Click ‘Supplemental Data’ hyperlink

Enter Test Data: “Testing BU ”
• Click ‘Save’

Run SQL to check for BU on GM_AWD_SD
SELECT * FROM PS_GM_AWD_SD ;
• BUSINESS_UNIT is blank

 

Changes

 

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