Thursday, October 7, 2021

Running the Customer Interface throwing "racina: ORA-00001: unique constraint(AR.HZ_PARTY_SITES_U2) violated" error:

 When you run "Customer Interface" program by populating ra_customers_interface_all and ra_customers_interface_all interface tables throwing "racina: ORA-00001: unique constraint(AR.HZ_PARTY_SITES_U2) violated". This error is due to the next site number generated using HZ_PARTY_SITE_NUMBER_S is less than the max (party_site_number) that is already generated in system.

Please check party_site_number and exists take action accordingly.

No comments:

Post a Comment

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...