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 JULY 19, 2021
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.
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
The creation date is 21-OCT-2019
so the start date is 21-OCT-2019 in
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"
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