BAI2 Lockbox File Is Failing With SQL-02112 When OVERFLOW_SEQUENCE Has More Than 100 Rows (Doc ID 2487276.1)

Last updated on NOVEMBER 15, 2019

Applies to:

Goal

On : 11.13.18.10.0 version, Receipts

BAI2 Lockbox file is failing with SQL-02112 when OVERFLOW_SEQUENCE has more than 100 rows

Customer is using BAI2 lockbox standard format file, their customers paying multiple hundred invoices on each payment. When that remittance information is being added under record type 4, OVERFLOW_SEQUENCE has going beyond 99. When OVERFLOW_SEQUENCE of 100 is populated, since overflow sequence is mapped from 9th byte to 10th byte with only 2 digits, it is not considering 1 and defaulting the OVERFLOW_SEQUENCE to 0 under AR_PAYMENTS_INTERFACE_ALL.OVERFLOW_SEQUENCE. Since for the same batch there are more than 1 records with OVERFLOW_SEQUENCE, lockbox is failing with

In No data found exception block. Sqlcode:1403.
AR-ARLVLN: Error from arlvln.
SEL over: SQL-02112: SELECT..INTO returns too many rows

Customer changed the transmission format configuration for BAI2 to have overflow sequence start from 8th byte to 10th byte but, those changes are not getting picked up the control file "arlockboximportbai2.ctl" is still looking at 9th byte to 10th byte
 

Solution

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