Topic
  • 1 reply
  • Latest Post - ‏2014-05-05T08:23:20Z by S3J2_Divya_V
BTV7_Sachin_Raj
BTV7_Sachin_Raj
1 Post

Pinned topic Duplicate Record Exists

‏2014-04-11T08:05:58Z |

Hi,

I am trying to add a Party Transaction and the in the Request XML i am passing the w TCRMPersonBObj object with same details.

So its throwing the error as Duplicate Party Exists. I know its due to the Business Keys . But can anyone tell me how to pass the Business Keys Validation and the Request XML should run successfully and both the TCRMPersonNameBObj should get Added.

Thanks

Sachin

  • S3J2_Divya_V
    S3J2_Divya_V
    4 Posts

    Re: Duplicate Record Exists

    ‏2014-05-05T08:23:20Z  

    Try to find which attribute exactly causes. Probably its due to Address or Contact methods or Identifiers... Remove one by one and see if XML works to find which one exactly causing issue. And to make sure it passes the Businesskey validation, see if it satisfies it. I framed this Query to get Business keys.. So make sure the one in DB is not the same one you are passing to addparty. Or add a step before triggering Addparty to remove those duplicates

    SELECT group_name,c.name,LISTAGG(ELEMENT_NAME, '; ')
             WITHIN GROUP (ORDER BY v.ATTRIBUTE_TP_CD)
      FROM V_ELEMENTATTRIBUTE v,cdattributetp c
      WHERE      group_name = 'TCRMPartyValue' and c.ATTRIBUTE_TP_CD = v.ATTRIBUTE_TP_CD  
      group by group_name,c.name 

    Updated on 2014-05-05T08:23:56Z at 2014-05-05T08:23:56Z by S3J2_Divya_V