R12: AP/IBY: How to Better Debug/Troubleshoot Error ORA-1 On IBY_ACCOUNT_OWNERS_U2 During Supplier Merge (Doc ID 3062646.1)

Last updated on JANUARY 31, 2025

Applies to:

Purpose

When Error ORA-1 Index Violated IBY_ACCOUNT_OWNERS_U2 occur during Supplier Merge program, the error message nor the regular concurrent program Log or FND Debug Log specify the values causing the index to be violated.

Having the values causing the index violation can save troubleshooting/debugging time and expedite resolution time.

This document explains how to add extra debugging code to the Supplier Merge API responsible for merging the Suppliers Bank Accounts (Ownership), server-side package boy IBY_SUPP_BANK_MERGE_PUB, to get the exact values causing the Index violation mentioned.

Troubleshooting Steps

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