My Oracle Support Banner

Fusion AP: Invoice Validation Error ORA-06502: PL/SQL: Numeric or Value Error: Character to Number Conversion Error at Inserting Distributions (AP-810595) (Doc ID 2929106.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.13.23.01.0 to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

 

Invoices cannot be validated due to error during distribution creation:

“ORA-06502: PL/SQL: numeric or value error: character to number conversion error at inserting distributions” 


This issue happens only when customer uses Default Account on Invoice Line with one of the segment being Statistical Unit of Measure (Stat UOM) as defined in GL setup [Manage Statistical Unit of Measure]. 

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.