PC_AM PROCESS ABENDED AT STEP PC_AM.30000000.37500000 (SQL) (Doc ID 1500766.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
Checked for Relevance on 16-May-2014

Symptoms

PC_AM process ABENDED at Step PC_AM.30000000.37500000 (SQL) -- RC = 1407 (108,524) with below error.

Error:
------

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1603 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/SUN64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=5, TABLEID=13337, COLNO=60" is not allowed. SQLSTATE=23502
(SQLSTATE 23502) -407
Failed SQL stmt:UPDATE PS_PC_AM_DEFN SET INTFC_TYPE = ( SELECT DISTINCT C.INTFC_TYPE FROM PS_PC_AM_PROJ_DEFN B , PS_PC_AM_RULE_ACT C , PS_PC_AM_RULE_PRJ D WHERE B.BUSINESS_UNIT_AM = PS_PC_AM_DEFN.BUSINESS_UNIT_AM AND B.ASSET_ID = PS_PC_AM_DEFN.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND B.ACTIVITY_ID = C.ACTIVITY_ID AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.PROJECT_ID = D.PROJECT_ID AND D.PC_AM_CAP_SW = 'Y') WHERE EXISTS ( SELECT 'X' FROM PS_PC_AM_PROJ_DEFN E WHERE E.BUSINESS_UNIT_AM

Replication Steps:
-----------------------
1.Create a Project
2.Enable Integration.
3.Create an Activity.
4.Add ‘ACT’ transaction.
5.Define asset.
6.Click on Relate by Asset.
7.Relate by Asset and click onto assign transactions to Assets.
8.Click on Assign Transactions.
9.Search the transactions based on activity id and select action as ‘Include’ and click onto Assign Transactions.
10.Navigate back to Asset Integration Rules on Project General information component and uncheck “Enable Integration”.
11.Process PC_AM

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