My Oracle Support Banner

ORA-06502: PL/SQL: numeric or value error showing in Prepare Tranaction Data log file when Prepare Mass Addition Rules are run (Doc ID 2734057.1)

Last updated on DECEMBER 15, 2020

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Prepare Mass Additions automatically, the following error occurs.

ERROR
-----------------------
 ORA-06502: PL/SQL: numeric or value error


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create invoices in Accounts Payable
2. Validate, accounting and run Create Mass Additions
3. Prepare Transaction data is run and shows the error
OR
4. When the lines are in assets, run Actions - Prepare mass Additions Automatically

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.