Transactions Workbench: Unapplying Applied Credit Memo Against Invoice Gives Error Message - ORA-06502 ORA-06512 API EXCEPTION (OTHERS): zx_api_pub.unapply_applied_cm()ORA-06502: PL/SQL: numeric or value error: character to number conversion error (Doc ID 1507778.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12 and later
Oracle E-Business Tax - Version 12 and later
Information in this document applies to any platform.

Symptoms

Unable to change the applied amount or unapply the invoice from the credit memo.  When trying to do so we get following error: 

ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.ARP_PROCESS_APPLICATION", line 9171
ORA-06512: at "APPS.ARP_PROCESS_APPLICATION", line 687

The Debug messages show:

API EXCEPTION (OTHERS): zx_api_pub.unapply_applied_cm()ORA-06502: PL/SQL:
numeric or value error: character to number conversion error
ar.plsql.arp_process_application.Unapply_Regular_CM

The credit memos are created through the Credit Transaction form.

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