When Trying To Change The Field "Inherit from Program" Using the value "CONSULTINGDIV" On Asset Integration Rules - Getting Error - SQL Error In PC_AM_RULE_SBR.PC_AM_CAP_SW.SaveEdit CLI0109E String Data Right Truncation.
(Doc ID 2227705.1)
Last updated on FEBRUARY 06, 2019
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
On : 9.2 version, Functionality
In DB2 environment, when trying to modify the the "Inherit from Program" field in Asset Integration Rules on a project, the following error occurs
ERROR
-----------------------
COM Stmt=SELECT B.PROJECT_ID FROM PS_PC_AM_PROJ_DEFN A, PS_PC_AM_PROJ_DEFN B, PS_PC_AM_RULE_PRJ C, PS_PROJECT D WHERE A.PROJECT_ID = :1 AND B.PROJECT_ID <> :2 AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.MANAGED_BY_WO <> :3 AND C.PC_AM_CAP_SW = 'Y' AND (C.PROJECT_ID_2 <> :4 OR :5 = ' ') AND :6 = 'Y'
PSAPPSRV.3972 (136) 1-991 16.05.57 0.024000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-1 type=2 length=2 value=VJ
PSAPPSRV.3972 (136) 1-992 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-2 type=2 length=2 value=VJ
PSAPPSRV.3972 (136) 1-993 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-3 type=2 length=1 value=X
PSAPPSRV.3972 (136) 1-994 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-4 type=2 length=13 value=CONSULTINGDIV
PSAPPSRV.3972 (136) 1-995 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-5 type=2 length=13 value=CONSULTINGDIV
PSAPPSRV.3972 (136) 1-996 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-6 type=2 length=1 value=Y
PSAPPSRV.3972 (136) 1-997 16.05.57 0.003000 SQL error. Function: SQLExec
Error Position: 0
Return: 8601 - [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999
Statement: SELECT B.PROJECT_ID FROM PS_PC_AM_PROJ_DEFN A, PS_PC_AM_PROJ_DEFN B, PS_PC_AM_RULE_PRJ C, PS_PROJECT D WHERE A.PROJECT_ID = :1 AND B.PROJECT_ID <> :2 AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.MANAGED_BY_WO <> :3 AND C.PC_AM_CAP_SW = 'Y' AND (C.PROJECT_ID_2 <> :4 OR :5 = ' ') AND :6 = 'Y'
Original Statement: SELECT B.PROJECT_ID FROM PS_PC_AM_PROJ_DEFN A, PS_PC_AM_PROJ_DEFN B, PS_PC_AM_RULE_PRJ C, PS_PROJECT D WHERE A.PROJECT_ID = :1 AND B.PROJECT_ID <> :1 AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.MANAGED_BY_WO <> :2 AND C.PC_AM_CAP_SW = 'Y' AND (C.PROJECT_ID_2 <> :3 OR :3 = ' ') AND :4 = 'Y'
PSAPPSRV.3972 (136) 1-998 16.05.57 0.000000 ErrorReturn-> 280 - SQL error in Exec. (2,280) PC_AM_RULE_SBR.PC_AM_CAP_SW.SaveEdit PCPC:2367 Statement:27
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > Project Costing > Project Defintion > General Information.
2. Add a new project and save
3. Click on Asset Integration Rules tab and try to populate the field "Inherit from Program" using the value "CONSULTINGDIV"
The above error is returned.
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 |