My Oracle Support Banner

R12:AP: IBYBUILD: Build Payments Program Errors as "ORA-06502: PL/SQL: numeric or value error: character to number conversion error" (Doc ID 2989666.1)

Last updated on NOVEMBER 29, 2023

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempt to run Payment process request and Build program errors out as below 

ERROR
---------

Enter: iby.scheduler.BuildPayments.runBuildPayments()
Sql to be executed: BEGIN IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31); END;
BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
An error occurred. Roll back any changes.
IBY_VALIDATIONSETS_PUB.evaluateCondition: IBY_VALIDATIONSETS_PUB.evaluateCondition: ORA-06502: PL/SQL: numeric or value error: character to number conversion error IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:User-Defined Exception IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when validating documents. Document validation will be aborted and no document statuses will be committed for payment request xxx IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: 1 IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: User-Defined Exception Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request

Steps to Reproduce:

1. Login to Payables responsibility
2. Navigate Setup -> Payments -> Payment Administrator-> Formats->Formats->Click on GO
3. Query the Payment Format and click on update
4. Navigate to user defined validation -> Add -> Create user defined validation for Document Payee Bank Account Number less than or equal to xx.
5. Navigate to Payments -> Entry -> Payments Manager 
6. Submit a new Payment Process Request (PPR) and under processing options check the checkbox to stop for selected invoice review
7. Once the PPR finishes selecting invoices click on Go To Task to review the invoices selected
8. Click to process the PPR and submit the build
9. Review the log file to see the error and PPR stuck with Failed Build Payments - Unexpected Error also not able to terminate PPR option is disabled.

 

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
Cause
Solution


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