My Oracle Support Banner

SPA_PROJ_EXP Process Is Failing With Unique Constraint Error (Doc ID 2492521.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



SPA_PROJ_EXP process is failing with Unique constraint error








Error message:
10:35:15.959 SQL Error: ORA-00001: unique constraint (SYSADMIN.PS_SPA_PE_TE_TAO4) violated

Error Message:
10:14:36.200 SQL Error: ORA-00001: unique constraint (SYSADMIN.PS_SPA_PE_TE_TAO4) violated


The issue can be reproduced at will with the following steps:
Scenario 1:
1. Create an Expense sheet with more than one line and approve.
2. Run SPA_PROJ_EXP and push the expense sheet to projects
3. Run Invoice generation process
4. Run SPA_PROJ_EXP again and this time it is failing with unique constraint error at Step SPA_PROJ_EXP.BUILDTAO.PCEXP_HD.

Scenario 2:
1. Create an Expense sheet against at resource based work order, whose expense reporting option is set to Percentage (SP_EXP_REPORT_OPT = 'P')
2. Approve the expense sheet and run SPA_PROJ_EXP process
3. Process failed with unique constraint error at step SPA_PROJ_EXP.BUILDTAO.INV_HDRE


The issue has the following business impact:
Due to this issue, users cannot create expense reports

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
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.