My Oracle Support Banner

R12 CE: BANK_ACCOUNT_TEXT Not Populated from Bank Statement Line (BAI2) When Bank Account in Continuation Rec_id 88 (Doc ID 2060227.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Bank Statement Load and Import

BANK_ACCOUNT_TEXT is not populated in the Bank Statement (BAI2)
When using BAI2 Bank statement format for loading Bank statement data in Cash Management, if there are SWEEP IN and SWEEP OUT transactions in the Bank statement and the destination account (account to which funds needs to be transferred) coming in record 88 not in 16.

Example: 

NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

03,30992602,USD,010,180132721,,,015,179993197,,,030,179993197,,/
16,577,139524,V,150923,,31525100045,NONREF/
88,FR:ACT TRANSFER DR
88,ENDT:20150923
88,TRID:NONREF
88,PY:ACT TRANSFER ____ ACCOUNT30992602 TWITTER, INC.

Basically extract the BANK_ACCOUNT_NUM and populate into: BANK_ACCOUNT_TEXT during the bank statement load process.

This to insure the sweep generation program to create sweep in / out types of transactions / cashflows in Cash Management.

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!


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