My Oracle Support Banner

ARXSGP-Statement Generation Program Error: ORA-06502 - ORA-01403 When Customer Name > 100 Characters (Doc ID 3059378.1)

Last updated on NOVEMBER 23, 2024

Applies to:

Oracle Receivables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When running the Statement Generation Program (ARXSGP), if there are customers with name or address longer than 100 characters, the log file shows the following error messages: 

ARXSGP: Statement Generation Program
+------------------------------------+

(...)

MSG-20002: Error > ORA-06502: PL/SQL: numeric or value error
ORA-01403: no data found

Steps to Reproduce:
Responsibility:  Receivables Manager
Navigation: Print Documents > Statements
Fill out the corresponding parameters
Click Submit button to run the Statement Generation Program

Changes

 

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
Changes
Cause
Solution
 Running the Statement Generation Program with output format as 'Text' may help in determining where the error is raised:
 1. Bug Summary
References


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