My Oracle Support Banner

Interface Trip Stop Errors With No Cost Of Goods Sold Account Is Defined For The Sales Order (Doc ID 2772568.1)

Last updated on OCTOBER 01, 2024

Applies to:

Oracle Order Management - Version 12.1.3 to 12.2.10 [Release 12.1 to 12.2]
Oracle Shipping Execution - Version 12.1.3 to 12.2.10 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Interface Trip Stop errors with the following:



ERROR
-----------------------

[26-APR-21 15:09:43] INV_WORKFLOW.GENERATE_COGS: FND_ELEX_WORKFLOW.GENERATE returned ccid0
[26-APR-21 15:09:43] INV_WORKFLOW.GENERATE_COGS: FND_ELEX_WORKFLOW.GENERATE returned v_concat_segs000.0000.00000.9999.000.0000
[26-APR-21 15:09:43] INV_WORKFLOW.GENERATE_COGS: FND_FLEX_WORKFLOW.GENERATE returned FALSE with error: FNDFND_API.G_MISS_CHARFLEX-VALUE IS EXPIREDFND_API.G_MISS_CHARNFND_API.G_MISS_CHARVALUEFND_API.G_MISS_CHAR9999FND_API.G_MISS_CHAR
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: l_success = FALSE
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: error msg : FNDFND_API.G_MISS_CHARFLEX-VALUE IS EXPIREDFND_API.G_MISS_CHARNFND_API.G_MISS_CHARVALUEFND_API.G_MISS_CHAR9999FND_API.G_MISS_CHAR
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: GET_COGS_FOR_LOGICAL_SO: Expected Error
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: SQL Error: User-Defined Exception
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: get_cogs_acct_for_logical_so returns error
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: create_logical_transactions: Expected Error, l_progress = 390
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: SQL Error: User-Defined Exception
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: Return Status :E
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: AFter calling create_logical_transactions
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: create_logical_transactions returns error
[26-APR-21 15:09:43] INV_LOGICAL_TRANSACTIONS_PUB: create_logical_trx_wrapper error exception, l_progress = 90
[26-APR-21 15:09:43] INV_TRX_MGR: Found rows
[26-APR-21 15:09:43] INV_TRX_MGR: Return status from APIE
[26-APR-21 15:09:43] INV_TRX_MGR: Error .. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper
[26-APR-21 15:09:43] INV_TRX_MGR: Error Message: INVFND_API.G_MISS_CHARINV_NO_COGS_FOR_LOG_SOFND_API.G_MISS_CHAR
[26-APR-21 15:09:43] INV_TRX_MGR: **Ex: Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper
[26-APR-21 15:09:43] INV_TRX_MGR: Error calling the create logical transactions wrapper: oracle.apps.inv.transaction.utilities.InvTrxException
[26-APR-21 15:09:43] INV_TRX_MGR: **Ex: Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException
[26-APR-21 15:09:43] INV_TRX_MGR: BaseTransaction. Rollbacking all changes: oracle.apps.inv.transaction.utilities.InvTrxException
[26-APR-21 15:09:43] INV_TRX_MGR: error expl :Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException
[26-APR-21 15:09:43] INV_TRX_MGR: TrxUtil: stacked message - No cost of goods sold account is defined for the sales order.
Action: Please define a COGS account in the Order Management Transaction Type Setup form.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Set the following profile options to return COGS debug messages:
Account Generator: Run in Debug Mode" to "Yes" at site level.
OM Debug Level = 5
WSH Debug Enabled = Y
WSH Debug level = Statement
INV: Debug Level ==> 15
3. Shipping
4. Interfaces > Interface Trip Stop
5. Set debug parameter = 1 in the ITS parameters
6. Submit

Changes

 

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
Changes
Cause
Solution
References


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