Error When Submitting Charges From Agent Dashboard: ORA-01407: cannot update ("CS"."CS_COST_DETAILS"."LAST_UPDATED_BY") to NULL (Doc ID 1946752.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Customer Suppport Specialist

Unable to submit Charges for a service request from Agent dashboard:

Error received:

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

ERROR:
=======

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01407: cannot update ("CS"."CS_COST_DETAILS"."LAST_UPDATED_BY") to NULL
ORA-06512: at "APPS.CS_COST_DETAILS_PKG", line 273
ORA-06512: at line 1



Steps:
- Login via Customer Support Specialist
- Create/Find SR.
- Open Charges page for the SR

- Create an estimate line for a service activity code that has the Costing flag enabled.

- Copy the estimate line to Actuals

- Submit the Actual charge line: error is received.



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