R12.1 Incorrect LOV For Parameter Statement Number From- Bank Statement Import

(Doc ID 2131517.1)

Last updated on AUGUST 26, 2016

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Bank Statement Load and Import

ACTUAL BEHAVIOR
---------------
Bank Statement Import issue

The issue is with Parameter Statement Number From and Parameter Statement Number To , for Bank Statement Import process.

If there are two bank statements in the interface, for two bank accounts with the same bank account number , but different bank account name , regardless of the bank account the user selects in the Bank Account parameter, the LOVs for parameters Statement Number From and Statement Number To lists two bank statement numbers.

 

Example :

1. Load first bank statement into the interface tables :
Account Name = 0110014478806603
Bank Account Number = 0110014478806603
Statement Number = 00275/002 - 01-SEP-15
Bank Name =Bank of America
Bank Branch Name = Central Branch
Currency = GBP

2. Load second bank statement into the interface tables:
Account Name = 0110014478806603-USD
Bank Account Number = 0110014478806603
Statement Number = 00275/001 - 01-SEP-15
Bank Name =Bank of America
Bank Branch Name = Central Branch
Currency = USD

3.
Submit the Bank Statement Import concurrent request:
Parameters :
Bank Branch Name = Central Branch
Bank Account Number = 0110014478806603
Statement Number From : LOV shows : 00275/002 - 01-SEP-15 and 00275/001 -
01-SEP-15

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms