1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package EAM

Discussion in 'Oracle CRM' started by anilk, Jul 3, 2013.

  1. anilk

    anilk Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hello All,

    I am getting the below error message during the creation of Failure combination codes in HTML - Enterprise Asset Management.
    ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package EAM_FailureCodes_PVT Procedure Setup_Combination.

    Please let me know,how to resolve the issue.

    Regards,
    Anil
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package

    Well...you'd have to look at the procedure in the package that is reporting the error. What is the procedure trying to do? What table is it modifying? Then look at the table definition to find the constraints defined against it.

    There's a great definition here :

    http://www.dba-oracle.com/sf_ora_00001_unique_constraint_violated.htm


    CJ
     
    anilk likes this.
  3. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package

    Also, you might consider getting this post moved to another Forum category...
     
    anilk likes this.
  4. anilk

    anilk Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Re: ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package

    Thanks for the reply.

    There was huge data to be loaded,i have created insert scripts and executed in oracle db from back end instead of using HTML UI.

    Step1: INSERT DATA INTO eam_failure_codes;
    Step2: INSERT DATA INTO eam_cause_codes;
    Step3: INSERT DATA INTO eam_resolution_codes;
    Step4: INSERT DATA INTO eam_failure_combinations;

    The scripts executed correctly,we are able to view the data in HTML UI.
    But when we tried to insert data from HTML UI,we are getting the error 'ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package'.

    The problem was,there was some other table which contains the ID's for the table eam_failure_combinations.
    I suspect ID's table may contain the 520 as last ID & eam_failure_combinations having the more records & the id is 3000.


    My question was.
    Is it possible to update the XXX ID's table.How to identify which is the ID table used for the eam_failure_combinations.
    It would be great helpful.How to resolve this issue.

    Regards,
    Anil
     
  5. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package

    If you have already loaded the tables and are able to view the data AND the attempt to run an insert is producing that error....first bet is to check the defined sequence NEXTVAL...it's probably already been used. So you'd have to redefine the sequence with a start value higher than the used value.
     
    anilk likes this.
  6. anilk

    anilk Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Re: ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package

    Thanks for the reply.

    Where to check the defined sequence NEXTVAL in (EAM.EAM_FAILURE_COMBINATIONS_UI) or in package EAM_FailureCodes_PVT Procedure Setup Combination.

    Regards,
    Anil
     
  7. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: ORA-00001:unique constraint(EAM.EAM_FAILURE_COMBINATIONS_UI) violated in package

    That's a good question and depends entirely on how you built everything to begin with. So, you can check the INSERT triggers of the tables which should tell you what sequence is being used. If nothing pops out then you're left w/ checking the code to see if a sequence is being called prior to an insert OR checking the ALL_SEQUENCES table (or is it a view?) for the sequence...assuming you know what the name of the sequence is.

    HTH

    CJ
     
    anilk likes this.