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

Last updated on APRIL 27, 2023

Applies to:

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

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