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 26, 2017

Applies to:

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

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

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