Bank Tabs – Supplier and Site
Supplier Bank Acc
If changing or creating bank details an ‘Update Mode’ is required of either ‘Create’ or ‘Update’.
The ‘Supplier Bank Acc’ tab will display all of the existing supplier bank details in the worksheet as sub tabs. To add new Supplier Bank details, click on the tab as indicated below. You will then be able to enter details for the new bank and this will be inserted into the worksheet when you close the form by selecting the ‘Ok’ button.
Site Bank Acc
If changing or creating bank details an ‘Update Mode’ is required of either ‘Create’, or ‘Update’. If using ‘Assign’ or ‘Assign and Update’ please refer to this section: Update Modes
The Site Bank tab is associated with a site therefore to enter the Site Bank details you first need to select the Site and then the Site Bank tab on the form.
After navigating to the ‘Site Bank’ tab, you will note that Site 2 has been selected. To add a new bank account to the site, click on the 
tab as indicated below.
An additional tab will then be provided which will enable you to enter the appropriate details.
These details will be added to the worksheet when you close the form by selecting the ‘Ok’ button at the base of the form.
Assign Existing Bank Details
Click here to watch a video on Assigning Bank Accounts.
Oracle E-Business Suite allows you to allocate an existing bank to multiple suppliers and allocate the suppliers account to an associated site.
New Feature available in Version 4.01.01 or Later
As detailed below the assignment of existing bank accounts may fail as the appropriate Bank Account Ownership records do not exist for the supplier you intend assigning to.
In Version 4.01.01 or Later a new Setup ribbon toggle button is available where you can direct the Wizard to automatically create the required account ownership record at the same time the assignment of the bank account is uploaded.
If the button is highlighted (toggled on) the Wizard will automatically perform the Account Ownership before attempting to assign the bank account.
There are two methods to enter the bank account information you intend to assign into the Wizard.
1) Using the Wizard Data Entry Form
The ‘Select Supplier Bank Account’ button is supplied to enable you to access a bank account which has been entered into Oracle and has an association with the supplier or site.
When you select this button, the following form will display. Select the down arrow on the form to display all bank accounts associated with this supplier/site.
Note: If no data exists in this field the following error message will be displayed:
'No Selectable Bank Accounts found for Supplier Id…'
To resolve this, add a new Bank Ownership record for the new supplier against the Bank Account you are assigning. This can be entered in the 'Banking Details' form in EBS or by using the appropriate 'Acc Owner' section in the Wizard (see the 'Account Owner' section below).
Once the bank account is selected, select ‘OK’ and the details will be displayed on the sub tab. Notice the Account Id is now populated which is a required field to complete the assignment.
2) Entering Data into the Wizard Sheet
Either download into or type directly into the appropriate ‘Bank Acc’ Wizard section.
Important: The 'Bank Acc Update Mode' must be 'Assign'. Or if the user wants to both assign and update, the Mode must be ‘Assign and Update’ for the ‘Site Bank’ details.
The 'Account Id ... Bank Acc' must be populated with the bank account id of the account you are assigning.
Note: If the Account ownership is not already created for the new supplier you may encounter the following message during validation:
'Invalid Assignment: Account XXX is not available…'
To resolve this, add a new Bank Ownership record for the new supplier against the Bank Account you are assigning. This can be entered in the 'Banking Details' form in EBS or by using the appropriate 'Acc Owner' section in the Wizard (see the 'Account Owner' section below).
If you subsequently change the details of an existing bank account, these will be changed for all other suppliers/sites that use this record.
Account Owner
The Supplier Wizard provides the ability to give other suppliers access to the appropriate bank account. To create or update the account owner you must have the bank details in your worksheet.
At the base of the Bank tab (Supplier or Site) is the ‘Supplier Acc Owner’ section.
• Update Mode - If changing or creating an account owner an ‘Update Mode’ is required.
• Supplier Number/Name - The Supplier Number is required and can be obtained by either the Supplier Number or Name in the appropriate field.
Enter a value directly into the field provided then select the search button to validate the value. The Supplier Name and Number will be populated automatically. If a partial value is known, then the wild card (%) can be added to the known value. Select the search button then select from the list of values provided.
• End Date – Either enter an End Date for the account ownership or leave this blank.
• Primary – This indicates who the primary account holder is and can be changed from one supplier to another. If you are changing the primary account holder use the ‘Update’ mode to change the ‘Primary’ flag from null to ‘Yes’. There is no need to change the existing primary owner as this will be updated at the same time as the new owner is updated.
Notes:
1. In version 4.01.01 or later a new Setup Ribbon toggle button is available where you can direct the Wizard to automatically create the required account ownership record at the same time the assignment of the bank account is uploaded. See the description in the 'New Feature available in Version 4.01.01 or Later' section above.
2. If you encounter an error while creating an account owner, please ensure this account owner does not already exist against the account.
Refer to section:
