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 JANUARY 30, 2017

Applies to:

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.

Cause

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