My Oracle Support Banner

"ORA-04088: error during execution of trigger 'PWRLINE.LS_TRG_BEF_LSMARKETATTR'" When Deleting Market Attribute with Related Service Point (Doc ID 987658.1)

Last updated on JANUARY 08, 2018

Applies to:

LODESTAR EIP - Version: 1.5.0 and later   [Release: 1.5 and later ]
Oracle Utilities Billing Component - Version: 1.5.0 to 1.5.0.7   [Release: 1.5 to ]
Oracle Utilities Quotations Management - Version: 1.5.0 to 1.5.0.7   [Release: 1.5 to ]
Information in this document applies to any platform.
***Checked for relevance on 23-Nov-2011***

Symptoms

In EIP version 01.05.00.04.00 when trying to SAVE a Market Attribute record after updating the Attribute Name, an error occurs.

Error

Error (0x90430001): ExecuteNonQueryException:
ORA-01400: cannot insert NULL into ("PWRLINE"."LSSRVCPTMARKETATTR"."UIMARKETATTRTYPE")
ORA-06512: at "PWRLINE.LS_TRG_BEF_LSMARKETATTR", line 8
ORA-04088: error during execution of trigger 'PWRLINE.LS_TRG_BEF_LSMARKETATTR'

Where 'PWRLINE' is the database Qualifier.

Steps to Reproduce

  1. Log into EIP
  2. Go to Data Navigator -> Market Attribute
  3. Search for Attribute Code = LDC
  4. Change the Attribute Name for the record
  5. Click Save. You will get pop-up with the error.

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
      Error
      Steps to Reproduce
  Cause
  Solution
     Bug Fix
     Work Around
  References

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