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 get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...