My Oracle Support Banner

Make Payment Causing Error : APP-SQLAP-10000:ORA-06502: PL/SQL: Numeric Or Value With Get Gendor Site Code (Doc ID 2237975.1)

Last updated on FEBRUARY 17, 2023

Applies to:

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


When attempting to make payment causing error in Enter/Adjust Invoices Window:

APP-SQLAP-10000:ORA-06502: PL/SQL: numeric or value error ORA-01403: no data found occurred in update invoice payments form> step 13 with parameters(&PARAMETERS)while performing the following operations get vendor site code

Issue also Observed in Autoselect Program:

APXPBASL module: Payment Process Request Program


ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind occurred in
select invoices
with parameters (p_checkrun_id xxxxx,P_template_id ,p_payment_date ,p_pay_thru_date ,p_pay_from_date )
while performing the following operation:
Open payment


The issue can be reproduced at will with the following steps:
1. Open Payments Workbench
2. Enter/Adjust Invoice > Select invoice to be paid 

 Observe error>APP-SQLAP-10000:ORA-06502: PL/SQL: numeric or value error ORA-01403


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

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