My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Patch Application Issues

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

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

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

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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