My Oracle Support Banner

EAP: Vendor Intermediary Routing Information is Not Deleted when Vendor Bank Account is Deleted (Doc ID 1957058.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.


Deleting a Vendor Bank Account not deleting corresponding Intermediary Bank Routing Information.

1. Navigate to Vendors > Vendor Information > Add/ Update > Vendor > Location and add a new Vendor Bank Account under Vendor Bank Account section of Payables Options page.
2. Enter Intermediary Bank Routing information for the Bank Account.
3. Save the Vendor.
3. Data is populated into VNDR_BANK_ACCT and VNDR_IBANK_ACCT tables.
4. Delete the added Vendor Bank Account and save the Vendor.

Actual Behavior:
Data is deleted from VNDR_BANK_ACCT but not from VNDR_IBANK_ACCT which is the child record of VNDR_BANK_ACCT.

Expected Behavior:
Data should be deleted from both the tables, VNDR_BANK_ACCT and VNDR_IBANK_ACCT.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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