ABEND At GM_PT_STAGE.AwdBud.InsAwdAm When PS_ITEM_ACTIVITY.ACCOUNTING_DT is Greater Than GM_AWD_FUND_PD.END_DT (Doc ID 2169470.1)

Last updated on SEPTEMBER 06, 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, Functionality

When attempting to run Grants Portal Staging date, GM_PT_STAGE ABENDED at GM_PT_STAGE.AwdBud.InsAwdAm when Payment ACCOUNTING_DT > GM_BUD_PERIOD END_DT

ERROR
-----------------------
-- 15:19:58.709 ..(GM_PT_STAGE.AwdBud.InsAwdAm) (SQL)
INSERT INTO PS_GM_PT_AWB_TA54 (PROCESS_INSTANCE, CONTRACT_NUM, BUSINESS_UNIT,
INVOICED_AMT, RECEIVED_AMT, UNPAID_AMT) SELECT PROCESS_INSTANCE,
CONTRACT_NUM, BUSINESS_UNIT, SUM(INVOICED_AMT), SUM(RECEIVED_AMT),
SUM(INVOICED_AMT) - SUM(RECEIVED_AMT) FROM PS_GM_PT_AWB_TA14 WHERE
PROCESS_INSTANCE = 84279 GROUP BY PROCESS_INSTANCE, BUSINESS_UNIT,
CONTRACT_NUM
/
-- Row(s) affected: 0
-- 15:19:58.811 Process 84279 ABENDED at Step GM_PT_STAGE.AwdBud.InsAwdAm (Action SQL) -- RC = 805
ROLLBACK
/
-- 15:19:58.839 SQL Error: ORA-00001: unique constraint (EMDBO.PS_GM_PT_AWB_TA54) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add invoice and Payment for the award/project. Payment accounting date is after the Budget Period end date.
2. Run GM_PT_STAGE process

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