My Oracle Support Banner

R12:AP: When Tried to Make Payment Before the Creation Date of External Bank Account from Payment Workbench the Error Appears as " APP-SQLAP-4667464: Remit-to Account Is Invalid. Please Re-enter." (Doc ID 2607185.1)

Last updated on JANUARY 27, 2020

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When making a payment the following error occurs:

             "APP-SQLAP-4667464: remit-to account is invalid"

 

 

Steps to reproduce the Issue:

____________________________

1)Responsibility:Payables Vision Operations

 

2)Create a supplier: Payables Vision operation>Suppliers>entry>Supplier >Create  supplier><Supplier>


3)Create external bank account: Payables vision operation>Suppliers>entry>Supplier>Banking details>Create bank account><Bank Account Number>


4)when you create the external bank account


A)The  Supplier Bank Account or external bank account gets stored in the  - IBY_EXT_BANK_ACCOUNTS table the bank_account_num gets stored and generates a unique EXT_BANK_ACCOUNT_ID It has the same START_DATE, CREATION_DATE, once it is created they are not updatable.

B)In  the IBY_EXT_BANK_ACCOUNTS the bank_account_num gets stored and generates a unique EXT_BANK_ACCOUNT_ID which maps to the Payment Instruments - IBY_PMT_INSTR_USES_ALL and stores the EXT_BANK_ACCOUNT_ID as INSTRUMENT_ID  where you find the

INSTRUMENT_TYPE about the bank account

C)Then the user updates the start date of the Bank account in the front end by navigating to the payables vision operation>Suppliers>entry>Supplier>Banking details>Create bank account><Bank Account Number> and saves it.


D)But the start date is not updatable in the - IBY_EXT_BANK_ACCOUNTS table and it is not changed however it gets updated in the Payment Instruments - IBY_PMT_INSTR_USES_ALL table

 

E)For Example:

   __________

The creation date is 21-OCT-2019

so the start date is 21-OCT-2019 in


1)IBY_EXT_BANK_ACCOUNTS


2)IBY_PMT_INSTR_USES_ALL tables

then the customer changes the start date as 1-oct-2019 and saves it then the start date is changed to 1-oct-2019 in Payment Instruments - IBY_PMT_INSTR_USES_ALL table but not in the IBY_EXT_BANK_ACCOUNTS table

Tries to make payment of the Invoice by providing the payment date as 4-oct-2019 then the error appears as "APP-SQLAP-4667464: remit-to account is invalid"

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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