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.
[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 |