My Oracle Support Banner

Data Selection Tool Migration Error; ORA-02292 (ASAP.FK_PPTS_PROV_PLAN_TASK_REL) (Doc ID 740171.1)

Last updated on JUNE 26, 2012

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.13 and later
Information in this document applies to any platform.


When a user attempts to Migrate a Provisioning Plan from one database instance to another using the Data Selection Tool, an integrity constraint error occurs.  Below are the messages received:

WARNING message in the GUI

Warning! A plan with the same name, Organization, Jurisdiction, and Service Type Group
already exists in the Target Database.

Are you sure you want to Overwrite it?

ERROR in the GUI

Target Database Error during Migration Process. All changes for this operation will be cancelled.

ERROR in the Plan Migration Log

Error occurred, Migration Aborted!

ORA-02292: integrity constraint (ASAP.FK_PPTS_PROV_PLAN_TASK_REL) violated


The issue can be reproduced at will with the following steps:

1. Using 6.0.13, copy a Provisioning Plan from a source database to a target database


Due to this issue, the Provisioning Plans cannot be copied from one database to another. The business will have to manually enter the Provisioning Plans in all instances.


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

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