My Oracle Support Banner

E1: 09: Process Automatic Bank File Does not Process Bank Reference, Customer Reference, or Text Values Correctly When Fund Type Value is V and 88 Continuation Record is Used on BAI2 Bank File (R09600) (Doc ID 2755438.1)

Last updated on FEBRUARY 26, 2021

Applies to:

JD Edwards EnterpriseOne General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The Process Automatic Bank Statements Flat File program (R09600), when processing a BAI2 .txt file, fails to import the Bank Reference (position 7), Customer Reference (position 8), and Text (position 9) values from the  '16' transaction detail record into the correct fields of the F09611 table when the Funds Type value (position 4) on the 16 record is set to 'V' and the Text value (position 9) is contained in an '88' continuation record.

This issue can be produced with the following steps:

a. Create a bank statement .txt file to include one 16 transaction detail record and one 88 record (in addition to the other standard required records). This record should have a value of V in the 4th position (Funds Type), and all of the nine remaining positions except position 9 should be populated in the 16 record. The line should be ended with a lone forward slash / character immediately after the last character of the 8th position (Customer Reference) value. The ninth position value (Text) should be contained on a subsequent 88 continuation record. An example of these two records might be:

      16,475,8000,V,210126,1200,bankref,custref/

      88,text

b. Save the .txt file in the proper folder on the server to be processed by R09600.

c. Set the R09600 Processing Options as follows:

      1 - BAI2, 2 - (whatever the .txt file is named), 3 - (the folder path), 4 - (the folder path), 5 - 0, 6 - (blank).

d. Run R09600.

e. Review the F09611 record that was created. Observe that the Bank Ref, Cust Ref, and Misc Info (Text) values are populated incorrectly or not at all.

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.