Overview of the AP Supplier Upload

1. Purpose

The AP Supplier Upload enables automatic creation of a bank and/or bank branch for a supplier account if they do not already exist within Oracle EBS. This upload ensures that supplier bank account details are accurately recorded and linked to the supplier, provided the necessary fields are completed.

2. Required Fields for Bank Account Creation or Update

To create or update bank account details, the following fields must be populated in the AP Supplier Upload:

  • Bank Name and/or Bank Number
  • Bank Branch Name and/or Branch Number
  • Bank Account Name and/or Bank Account Number

If these fields are populated, the AP Supplier Upload will invoke standard Oracle APIs to validate the information. Upon successful validation, the Oracle APIs will proceed to create or update the bank, branch, and bank account details.

3. Country-Specific Validations

Oracle EBS applies country-specific validations that dictate the required information and its format. These validations ensure compliance with local banking regulations, such as format checks for routing transit numbers in the U.S. and Canada.

Note: The AP Supplier Upload will only process bank account details if both the Bank Account Name and/or Bank Account Number are provided. This functionality cannot be used solely to create banks or bank branches without associated supplier bank account details. The upload’s purpose is to facilitate creating and linking supplier bank account details to the supplier or updating existing linked bank account details.

4. Common Validation Errors and Solutions

For U.S. and Canadian bank accounts, validation failures may include errors like:

The modulus check validation for Routing Transit Number has failed. Please enter a correct value for the Routing Transit Number.

This error message indicates that the provided bank branch number does not meet country-specific validation requirements. To resolve this, consult the following My Oracle Support documents for the required format and validations:

  • Doc ID 1587838.1: “R12: AP: When Entering Bank Account Number Receive The Following Error: The Check Digit Validation For Routing Transit Number Has Failed.”
  • Doc ID 1287647.1: “R12/CE: Bank Branch Validation USA, CANADA : Profile Option ‘CE: Disable Bank Validations’, Bank Branch Information: Error: Check Digit Validation for Routing Transit Number Has Failed.”

5. Bypassing Bank Validations

If needed, you can bypass bank validations by setting the Oracle profile option CE: Disable Bank Validations to bypass these validations during the upload process.

Important: These validations are enforced by the standard Oracle APIs. The upload will be rejected if the information does not pass the required validation checks.