PC_EXPRSS_AM ABENDED At Step PC_EXPRSS_AM.PctRows.InsRsTa2 - ORA-00001: Unique Constraint (Doc ID 1568472.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

On :  9.1 version, Interfaces

When attempting to run PC_EXPRSS_AM process using Manual Capitalization Review
the following error occurs.

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

-- 17.18.21 Process 22301 ABENDED at Step PC_EXPRSS_AM.PctRows.InsRsTa2 (Action SQL) -- RC = 805
ROLLBACK
/
-- 17.18.22 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PC_AM_RS1_TAO4) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set Up Financials/Supply Chain> Product Related> Project Costing> General Options> Express Asset Filter Criteria
  a. Modify Filter to have criteria as:  ANALYSIS_TYPE <> ('COR')

2. Create a Project.  Use Asset Integration Rules as follows
  a. Asset Integration Defaults - Enable Integration - checked,  Integration Type - Capitalization, Filter ID: FILTER1
  b. Asset Identification Rule - Many Assets From Each Activity (Distribution - Project Percentage Distribution)
  c. Asset Creation Trigger - Manual Capitalization Review
  d. Asset Adjustment Trigger - Manual Capitalization Review
  e. Transaction Load Type - Additional Cost Add
  f. End of Year Rule - Ignore End of Year

3. Create 2 Activities - TEST1, TEST 2
4. Create a Budget Plan, Budget Detail to create a budget for TEST1
5. Project Costing > Assets > Express Asset Definition. Define Project Percentage Distribution such that it spans across 4 Assets with percentages 10, 20, 30, 40
6. Project Costing > Assets >  Manual Capitalization Review. Search for the Project. Use select All and choose Asset Processing Destination as "Summarize and Run Interface". Click on Send to Asset Management
7. The process runs to success.
8. Without any changes. Go To Project Costing > Assets >  Manual Capitalization Review. Search for the Project. Use select All and choose Asset Processing Destination as "Summarize and Run Interface". Click on Send to Asset Management
9. The process abends at Process 13590 ABENDED at Step PC_EXPRSS_AM.PctRows.InsRsTa2 (SQL) -- RC = 805

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