11i: Norwegian EFT Payment Method:PAYMENTS CANNOT EXCEED 999 PER SUPPLIER IN A PAYMENT BATCH (Doc ID 1051062.1)

Last updated on MARCH 19, 2019

Applies to:

Symptoms

On : 11.5.9 version, Norwegian Localizations for AP, NOEX

Find The bank does not accept the EFT file due to there is a maximum of 999
BETFOR23 records for each BETFOR21 record but the EFT file contains more than
1000 BETFOR23 records for one of the BETFOR21 records

EXPECTED BEHAVIOR
-----------------------
Expect a new BETFOR21 record to be created if you have more than 999 BETFOR23 records.
Each BETFOR21 record must only contain a maximum of 999 BETFOR23 records.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create more than 1000 invoices for a supplier site
2. create a payment batch and format using Noex Telepay XXNOET05.sql
3. View the output file created it will show each invoices in a separate BETFOR23 record under the same BETFOR21 record
This is not accepted by the bank since they have a maximum of 999 invoices to each BETFOR21 record

Cause

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