TeleService: Constraint Error JBO-26048 When Adding a Row in Setup Screens (Doc ID 2055116.1)

Last updated on SEPTEMBER 11, 2015

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

- When trying to add a new Service Activity, then the SAC is not saving.
- When trying to add a Problem Code to an existing Category, encountering Unique constraint CS_SR_PROB_CODE_MAPPING_DTL_U1 violation error.

Steps:

[ 1 ]

(R) Service
(N) Setup > Charges > Service Activities

or

[ 2 ]

(R) Service
(N) Setup > Mapping > Problem Code Mapping

 - Create Problem Problem Code Mapping
 - Select a Problem Code (one that does not exist for the Item Category)
 - Click Apply

 => Error "The specified mapping criteria already exists."

Errors:

[ 1 ]

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException:
JBO-26048: Constraint "CS_TRANSACTION_TYPES_B_U1" violated during post operation:
"Insert" using SQL Statement

"INSERT INTO CS_TRANSACTION_TYPES_B (TRANSACTION_TYPE_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,
  SEEDED_FLAG,START_DATE_ACTIVE,NO_CHARGE_FLAG,CREATE_CHARGE_FLAG,CREATE_COST_FLAG,DEPOT_REPAIR_FLAG,
  OBJECT_VERSION_NUMBER,LINE_ORDER_CATEGORY_CODE,INTERFACE_TO_OE_FLAG,TRAVEL_FLAG,UPDATE_TASK_ACTUALS_FLAG)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)".

[ 2 ]

oracle.apps.fnd.framework.OAException: oracle.jbo.DMLConstraintException:
JBO-26048: Constraint "CS_SR_PROB_CODE_MAPPING_DTL_U1" violated during post operation:
"Insert" using SQL Statement

"INSERT INTO CS_SR_PROB_CODE_MAPPING_DETAIL(PROBLEM_MAP_DETAIL_ID,PROBLEM_MAP_ID,PROBLEM_CODE,CATEGORY_ID,OBJECT_VERSION_NUMBER,
 LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
 VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)".
 at  oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
 ...

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