'BUILD PAYMENTS' PROGRAM ENDS WITH ERROR FOR 'CHECK' PAYMENTS ORA-20001
Last updated on MARCH 08, 2017
Applies to:Oracle Payables - Version: 12.0.6 - Release: 12
Information in this document applies to any platform.
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_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.processPaperPayments: Check numbering did not succeed.
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:
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