My Oracle Support Banner

GM_PT_STAGE ABENDED at Step GM_PT_STAGE.GMPrjBud.SpnDirNB (Action SQL) -- RC = 805 (Doc ID 2417011.1)

Last updated on JUNE 29, 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, Functionality

GM_PT_STAGE failing with unique constraint error at Step GM_PT_STAGE.GMPrjBud.SpnDirNB (Action SQL)

ERROR
-----------------------

-- 11:26:53.102 ...(GM_PT_STAGE.GMPrjBud.SpnDirNB) (SQL)
INSERT INTO PS_GM_PT_PBD_TA04 (PROCESS_INSTANCE, BUSINESS_UNIT_PC,
PROJECT_ID, ACTIVITY_ID, BUDGET_PERIOD_GM, BUDGET_CATEGORY, SEQ_NBR,
AMOUNT_TYPE, START_DT, END_DT, FUNDED_AMT, BUDGETED_AMT, CURRENCY_CD,
BUSINESS_UNIT_GL, LEDGER_GROUP, ACCOUNT, DEPTID, OPERATING_UNIT, PRODUCT,
FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1,
AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, RESOURCE_TYPE,
RESOURCE_CATEGORY, RESOURCE_SUB_CAT) SELECT DISTINCT TA1.PROCESS_INSTANCE,
TA1.BUSINESS_UNIT_PC, TA1.PROJECT_ID, DTL.ACTIVITY_ID,
AWDFUND.BUDGET_PERIOD_GM, ' ', 0, 'SPD', AWDFUND.BEGIN_DT, AWDFUND.END_DT,
TA1.FUNDED_AMT, TA1.BUDGETED_AMT, GM_AWD.CURRENCY_CD, ' ', ' ', ' ',
TA1.DEPTID, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ',
DTL.RESOURCE_TYPE, DTL.RESOURCE_CATEGORY, DTL.RESOURCE_SUB_CAT FROM
PS_GM_PT_SPR_TA14 TA1, PS_CA_DETAIL_PROJ DTL, PS_GM_AWD_FUND_PD AWDFUND,
PS_GM_AWARD GM_AWD WHERE TA1.PROCESS_INSTANCE = 151074 AND
TA1.BUSINESS_UNIT_PC = DTL.BUSINESS_UNIT_PC AND TA1.PROJECT_ID =
DTL.PROJECT_ID AND TA1.CONTRACT_NUM = DTL.CONTRACT_NUM AND
AWDFUND.BUSINESS_UNIT = TA1.BUSINESS_UNIT_PC AND AWDFUND.CONTRACT_NUM =
TA1.CONTRACT_NUM AND AWDFUND.PROJECT_ID = TA1.PROJECT_ID AND
GM_AWD.CONTRACT_NUM = AWDFUND.CONTRACT_NUM AND NOT EXISTS ( SELECT 'X' FROM
PS_PC_BUD_DETAIL PCBUD WHERE PCBUD.BUSINESS_UNIT = AWDFUND.BUSINESS_UNIT AND
PCBUD.PROJECT_ID = AWDFUND.PROJECT_ID AND PCBUD.BUDGET_PERIOD =
TO_CHAR(AWDFUND.BUDGET_PERIOD_GM) AND PCBUD.ACTIVITY_ID = DTL.ACTIVITY_ID)
/
-- Row(s) affected: 0
-- 11:26:53.333 Process 151074 ABENDED at Step GM_PT_STAGE.GMPrjBud.SpnDirNB (Action SQL) -- RC = 805
ROLLBACK
/
-- 11:26:53.412 SQL Error: ORA-00001: unique constraint (EMDBO.PS_GM_PT_PBD_TA04) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Proposal with one Project and 3 Activities. One Activity is associated with Rate Type product and the other 2 activities amount based. This can be done in the F&A Pricing Set up under the Budget Tab
2. No Budgets were added
3. Submit the Proposal and Generate the award
4. Under the Contract Terms page for the associated contract, capture the Project/Activity that is associated with the Rate Type contract line
5. For the other 2 contract lines that are of type amount, remove the current Project/Activity associated with them. Add the Project/Activity that we captured in #4. Make sure the Resource Type is populated differently for each of these lines.
6. Run the GM_PT_STAGE process. The process abends with the above error.

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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