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:

Symptoms

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

STEPS
-----------------------
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

Cause

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