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

Last updated on APRIL 04, 2017

Applies to:

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

Symptoms

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

Steps:
---------
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms