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

Last updated on MARCH 13, 2024

Applies to:

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

Changes

Cause

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