Material Cost Transaction Worker Error GET_TRANSFER_PRICE ORA-06510 UHANDLED USER-DEFINED (Doc ID 1321153.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===

On : 12.1.3 version,

Material cost transaction worker is completing with an error when trying to process an internal sales order line that was shipped. Log file says


+---------------------------------------------------------------------------+
Bills of Material: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

CMCMCW module: Material cost transaction worker
+---------------------------------------------------------------------------+

Current system time is 22-APR-2011 14:48:29

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

before uncosted_trx...
Transaction group id is 8686116.000000

Fetched txn 8685673.000000
DS parent_txn_id = 0.000000, parent_txn_ind = -1.
pd_txfr_ind = 0
Costing Transaction, ID = 8685673.000000
trans_id is 8685673.000000
CSE Cost Distribution Hook Used: 0
Flow schedule flag = 0
The transfer pricing option = 1
In function get_transfer_price()
The price list ID = 7010
appl/bom/12.0.0/bin/CMCMCW Program was terminated by signal 11


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Create Internal Requisition. Create Internal Sales Order. Ship Internal Sales Order. Check Material Transaction line Distributions. No distributions exist since the line is not getting costed

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