Receivables - EBS (MOSC)

MOSC Banner

AutoLockbox error

edited Sep 25, 2018 5:00AM in Receivables - EBS (MOSC) 1 commentAnswered

Hello Gurus,

I have setup the Lockbox and created a custom Control and Transmission file for importing the data files from external system.  When I import multiple records for same customer and billing location, the receipts are generating correctly, however while trying to import multiple records for same customer but different billing locations, its throwing below errors.

    1) APP: Overflow record with next sequence is missing.

    2) APP: Receipt has invalid overflow records.

Control file:

--  Type 4 - Overflow Receipt

INTO TABLE AR_PAYMENTS_INTERFACE

WHEN RECORD_TYPE = '4'

(STATUS                         CONSTANT 'AR_PLB_NEW_RECORD',

RECORD_TYPE                    POSITION(01:01) CHAR,

BATCH_NAME                     POSITION(02:04) CHAR,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center