My Oracle Support Banner

UIM: CURRENTASSIGNMENT Is Not Changed To NULL For Logical Device (Doc ID 2467974.1)

Last updated on MARCH 26, 2024

Applies to:

Oracle Communications Unified Inventory Management - Version 7.3.4.0.0 and later
Information in this document applies to any platform.

Symptoms

"ORA-02292: integrity constraint (UIMADMIN.LOGICALDEVICECURRENTASSIGNMENT) violated - child record found" on Shared resources during un-assign operation.

Shared resources are resources for which “Can be assigned to multiple entities” is enabled.

Sample Scenario:

1. Pre-requisite

# SIMCard, Outdoor unit Logical Devices which are SHARED resources i.e “Can be assigned to multiple entities” is enabled

#Service and SCV with two assignment configItems. One assignment mapping to SIMCARD and other to Outdoor Unit

#Service should have required Design and Assign code for Capture Interaction. i.e RuleSet on “BaseConfigurationManager.automateConfiguration” should exist where assignment on SIMCARD and Outdoor Unit is performed.

#Service should have ruleset on “BaseConfigurationManager.completeConfigurationVersion” i.e before completion of business interaction

#BEFORE_COMPLETION Ruleset includes the code to unallocate the shared resources

2. Run capture, Process, Approve, Issue BI

During Capture Interaction request perform SIMCARD assignment operation on an instance of service and also Outdoor unit assignment operation on same service.

3. Update Interaction with COMPLETE action.

After Step 3, exception is thrown - ORA-02292: integrity constraint (UIMADMIN.LOGICALDEVICECURRENTASSIGNMENT) violated - child record found

 

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
Cause
Solution


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