Duplicate external bank accounts for same supplier R11
hi all can anyone help me for a datafix for R11 issue (duplicate external bank accounts for same supplier.)
Here is duplication in ap_bank_account_uses_all
select *
from ap_bank_account_uses_all
where vendor_id = '1820211'
BANK_ACCOUNT_USES_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN CUSTOMER_ID CUSTOMER_SITE_USE_ID VENDOR_ID VENDOR_SITE_ID EXTERNAL_BANK_ACCOUNT_ID START_DATE END_DATE PRIMARY_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE ORG_ID OWNING_PARTY_ID 46262 03-MAY-13 1173 03-MAY-13 1196 10862503
Here is duplication in ap_bank_account_uses_all
select *
from ap_bank_account_uses_all
where vendor_id = '1820211'
BANK_ACCOUNT_USES_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN CUSTOMER_ID CUSTOMER_SITE_USE_ID VENDOR_ID VENDOR_SITE_ID EXTERNAL_BANK_ACCOUNT_ID START_DATE END_DATE PRIMARY_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE ORG_ID OWNING_PARTY_ID 46262 03-MAY-13 1173 03-MAY-13 1196 10862503
Tagged:
0