MATERIAL COST COLLECTION WORKER FAILS DUE TO ORA-06502 in Japanese Session
(Doc ID 1926588.1)
Last updated on SEPTEMBER 30, 2024
Applies to:
Oracle Project Manufacturing - Version 12.1.3 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |