My Oracle Support Banner

'BUILD PAYMENTS' PROGRAM ENDS WITH ERROR FOR 'CHECK' PAYMENTS ORA-20001 (Doc ID 1078404.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

'Build Payments' program as part of the payment request run ends in error for payments with format as 'Check'


IBY_CHECKNUMBER_PUB.assignCheckNumbers: Payment instruction xxxxx status committed to CREATED_READY_FOR_PRINTING before numbering.
IBY_CHECKNUMBER_PUB.assignCheckNumbers: Got the payment document name
IBY_CHECKNUMBER_PUB.assignCheckNumbers: User has not explicitly provided a check number to start numbering from. Numbering will start from last issued check number on check stock.
IBY_CHECKNUMBER_PUB.assignCheckNumbers: Available paper stock = 0 for payment document name '2341_Check'
IBY_CHECKNUMBER_PUB.assignCheckNumbers: Deferring payment instruction print xxxxx because of insufficient paper stock.
IBY_PAYINSTR_UTILS_PKG.createErrorRecord: ENTER
IBY_PAYINSTR_UTILS_PKG.createErrorRecord: EXIT
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable: Validation Failed: Insufficient payment documents are available for printing. Number available: 0, number required: 1
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable: Token SQL table will be populated.
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable: Transaction_error_id in token SQL table is populated.
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable: Finished populating the error table.
IBY_CHECKNUMBER_PUB.assignCheckNumbers: Exception occured when performing document numbering.
IBY_CHECKNUMBER_PUB.assignCheckNumbers: SQL code: -20001
IBY_CHECKNUMBER_PUB.assignCheckNumbers: SQL err msg: ORA-20001:
IBY_CHECKNUMBER_PUB.assignCheckNumbers: EXIT
IBY_CHECKNUMBER_PUB.processPaperPayments: Check numbering did not succeed.
IBY_CHECKNUMBER_PUB.processPaperPayments: EXIT
IBY_CHECKNUMBER_PUB.performCheckNumbering: Check numbering process did not succeed. Raising exception ..
IBY_CHECKNUMBER_PUB.performCheckNumbering: Exception occured when performing payment numbering. Payment numbering process will be aborted.
IBY_CHECKNUMBER_PUB.performCheckNumbering: SQLCODE: -20001
IBY_CHECKNUMBER_PUB.performCheckNumbering: SQLERRM: ORA-20001:

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.