FUSION DOO: Product Transformation Rule Fails When Using a Decision Table - Argument conversion or method invocation failure for method toString

(Doc ID 2101688.1)

Last updated on JANUARY 28, 2017

Applies to:

Oracle Fusion Distributed Order Orchestration - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***

Symptoms

Order Creation is failing with a - Transformation of Order Failed - error

Customer has created a Decision table Product Transformation Rule to add a new order line. This rule checks

1. That the order number starts with 'DN'
2. That the Inventory_item_id = Some Value

If this is true a new line is added to the Order.

Product  failing with an Exception:
    Transformation of Order Failed
    An internal error was encountered: Argument conversion or method invocation failure for method toString in class java.lang.Long.[[at line 13 column 3 in /Ruleset(TransformationCustomRS)/Rule(NewProductRuleRule1)/Pattern(v0_FulfillLineVO)/Test[4]

NOTE 1:
A similar IF/THEN rule works correctly

SETUP
A bucket set has been created with a data type of long. this contains the value of the inventory Item Id that is tested against - 300000000653136

Decision table is defined where:

Conditions are:

OrderTransformationRules.HeaderVO.SourceOrderNumber.starts with("DN") is true
AND
OrderTransformationRules.FulfilLineVO.InventoryItemID = 300000000653136

THEN

assert new ORderTransformationRules.AddNewOrderLine
  newItemId:Long
viewRowImpl:OrderTransformationRules.ViewRowImp


/apps/OrderOrchestrationServer_1-diagnostic.log shows:

[2015-12-22T14:44:44.390+01:00] [OrderOrchestrationServer_1] [ERROR] [] [oracle.apps.appslogger] [tid: 11] [userId: FUSION_APPS_SCM_SOA_APPID] [ecid: 0000L79vp7pFS8A5zbp2iW1MNmZN004R85,0] [APP: OrderOrchestrationApp#V2.0] [APPS_THREAD_NAME: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [APPS_TERRITORY: US] [APPS_SESSION_ID: 277C83AEE6FC5170E053486B040A063C] [APPS_AUTO_LOG: false] [APPS_USER_NAME: FUSION_APPS_SCM_SOA_APPID] [APPS_USER_ID: 155B5DD2A0CFEC52E050040A83800A3B] [APPS_DB_CONNECTION_URL: jdbc:oracle:thin:@db69.dvp.corp.telenet.be:1569/dvp69] [APPS_SOURCE: scm.doo.decomposition.receiveTransform.receiveSalesOrder.model.applicationModule.PersistSourceOrderAMImpl] oracle.rules.rl.exceptions.EngineException: An internal error was encountered: Argument conversion or method invocation failure for method toString in class java.lang.Long.[[
at line 13 column 3 in /Ruleset(TransformationCustomRS)/Rule(NewProductRuleRule1)/Pattern(v0_FulfillLineVO)/Test[4]
at oracle.rules.rl.exceptions.ExceptionFactory.createEngineException(ExceptionFactory.java:899)


[2015-12-22T14:44:44.393+01:00] [OrderOrchestrationServer_1] [ERROR] [] [oracle.apps.appslogger] [tid: 11] [userId: FUSION_APPS_SCM_SOA_APPID] [ecid: 0000L79vp7pFS8A5zbp2iW1MNmZN004R85,0] [APP: OrderOrchestrationApp#V2.0] [APPS_THREAD_NAME: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [APPS_TERRITORY: US] [APPS_SESSION_ID: 277C83AEE6FC5170E053486B040A063C] [APPS_AUTO_LOG: false] [APPS_USER_NAME: FUSION_APPS_SCM_SOA_APPID] [APPS_USER_ID: 155B5DD2A0CFEC52E050040A83800A3B] [APPS_DB_CONNECTION_URL: jdbc:oracle:thin:@db69.dvp.corp.telenet.be:1569/dvp69] [APPS_SOURCE: scm.doo.decomposition.receiveTransform.receiveSalesOrder.model.applicationModule.PersistSourceOrderAMImpl] Transformation of Order Failed


[2015-12-22T14:44:44.407+01:00] [OrderOrchestrationServer_1] [ERROR] [] [oracle.apps.appslogger] [tid: 11] [userId: FUSION_APPS_SCM_SOA_APPID] [ecid: 0000L79vp7pFS8A5zbp2iW1MNmZN004R85,0] [APP: OrderOrchestrationApp#V2.0] [APPS_THREAD_NAME: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [APPS_TERRITORY: US] [APPS_SESSION_ID: 277C83AEE6FC5170E053486B040A063C] [APPS_AUTO_LOG: false] [APPS_USER_NAME: FUSION_APPS_SCM_SOA_APPID] [APPS_USER_ID: 155B5DD2A0CFEC52E050040A83800A3B] [APPS_DB_CONNECTION_URL: jdbc:oracle:thin:@db69.dvp.corp.telenet.be:1569/dvp69] [APPS_SOURCE: scm.doo.decomposition.receiveTransform.receiveSalesOrder.model.applicationModule.PersistSourceOrderAMImpl] oracle.apps.scm.doo.common.DooJboException: An internal error was encountered: Argument conversion or method invocation failure for method toString in class java.lang.Long.[[
at line 13 column 3 in /Ruleset(TransformationCustomRS)/Rule(NewProductRuleRule1)/Pattern(v0_FulfillLineVO)/Test[4]
at

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