Cannot Create Receipts Against Po with Multiple Distributions In Russian or Turkish Language: APP-PO-14142: Get_misc_distr_info-010

(Doc ID 1294677.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms


Using NLS foreign language (Turkish or Russian), when attempting to enter a receipt against a purchase order line with multiple distributions the following error occurs:

APP-PO-14142: get_misc_distr_info-010: ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
In Turkish.
Error: UYG-PO-14142: get_misc_distr_info-010: ORA-06502: PLSQL: character string buffer too small


The issue can be reproduced at will with the following steps:
1. Navigate to Purchase Orders > Purchase Orders
2. Create a purchase order with a line with multiple distributions
3. Navigate to Receiving > Receipts
4. When attempting to receive this PO using Russian (or Turkish language), the system raises the above mentioned errors.

Note: the same action is possible connected in English

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