MATERIAL COST COLLECTION WORKER FAILS DUE TO ORA-06502 in Japanese Session (Doc ID 1926588.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

On : 12.1.3 version, Patch Application Issues

In Japanese session, Material Cost Collection Worker fails due to ORA-06502

ERROR
-----------------------
This is a concurrent log.

CMCCCI module: Material Cost Collection Worker
+---------------------------------------------------------------------------+

Current system time is 01-SEP-2014  03:56:21

+---------------------------------------------------------------------------+

APP-FND-01564: ORACLE error 6502 in cmccci()
Cause: ORA-06502: PL/SQL: numeric or value error: character string buffer too
small
ORA-06512: "APPS.CST_PRJMFG_COST_COLLECTOR", Line 1136

Cause: cmccci() failed due to ORA-06502: PL/SQL: numeric or value error:
character string buffer too small

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receive a project associated PO, and deliver it to Inventory.
2. Run Cost Manager , and Material Cost Collection Worker.

If we run Material Cost Collection Worke in English session, the following warning message is shown instead of ORA error.

5017.000000 -- 000020007 CSTPPCCB.pm_check_error_mmt(50): - System failed to arrive at the first material sub-element for the current item.
Either define atleast one material sub-element for the item in the AVERAGE RATES COST TYPE or else define the organization level default material sub-element.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.