Lockbox Upload Fails After Enabling Document Sequencing For Invoices But Not For Receipts. (Doc ID 2302964.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Why Lockbox upload fails after enabling document sequencing for invoices but not for receipts.

Users were able to upload receipts using lockbox earlier when document sequence was disabled. After enabling document sequencing, when they tried to upload the lockbox receipts, the process fails. Users have enabled document sequencing only for invoices and not for receipts. The log file of lockbox shows the following:
 

Starting ARLPLB
Warning - Could not get profile option value for AR_ALLOW_OVERAPPLICATION_IN_LOCKBOX
In No data found exception block. Sqlcode:1403.
Document sequence not assigned
AR-ARLVCB: work has been rolled back.

Solution

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 hundreds of Community platforms