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

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.0.6 - Release: 12
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 10781 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 10781 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:

Cause

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