Trying To Create An Adjustment Gets Error ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small ORA-06512: At "FUSION.ZX_API_PUB", Line 7830 ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small ORA-06512: At (Doc ID 2253682.1)

Last updated on APRIL 10, 2017

Applies to:

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

Symptoms

On Oracle Fusion, 11.1.11.1.0 version, trying to create an adjustment gets error


ERROR:
----------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.ZX_API_PUB", line 7830 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.ZX_SRVC_TYP_PKG", line 18930 ORA-01086: savepoint 'DB_UPDATE_LINES_DET_FACTORS' never established in this session or is invalid ORA-06512: at "FUSION.ZX_SRVC_TYP_PKG", line 8563 ORA-22160: element at index [1] does not exist (AR-855636)

arp_process_adjustment.insert_adjustment exception: ORA-20001: (AR-855636)

ORA-20001: (AR-855636)


EXPECTED BEHAVIOR
-----------------------
Expecting to be able to post the receipt


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Receivables > Billing
3. Query a transaction
4. Click on Action > Manage Adjustments
5. Click on Create
6. Select the options for the adjustments
7. Press submit and observed the error described appears


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