INVOICE ACCOUNTING ENTRIES NOT GETTING CREATED DURING INVOICE CANCELLATION EVENT.Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small " is Observed (Doc ID 1983153.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Financials for India - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Accounting Issues in AP

ACTUAL BEHAVIOR
---------------
When trying to account for an invoice cancellation through Actions>Create Accounting, invoice does not get accounted and Accounted status remains Partial.
Running the create accounting program however accounts for the invoice cancellation.


This is happening only if no IL taxes has been attached to the invoice. If IL Taxes are attached, then this issue is not appearing.

EXPECTED BEHAVIOR
-----------------------
Expect the invoice to be accounted fully even through online accounting.

Steps to replicate the issue:-
---------------------------------------------
1) Create an invoice. Do not attach IL and TDS tax.
2) Validate the invoice and create accounting.
3) Cancel the invoice.
4) Actions>Create Accounting. No Accounting Entries will be present for invoice cancellation event



Business Impact
--------------------------
The user cannot create accounting entries for the cancellation event.

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