EAP: Vendor Intermediary Routing Information is Not Deleted when Vendor Bank Account is Deleted
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.
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.
Data is deleted from VNDR_BANK_ACCT but not from VNDR_IBANK_ACCT which is the child record of VNDR_BANK_ACCT.
Data should be deleted from both the tables, VNDR_BANK_ACCT and VNDR_IBANK_ACCT.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms