Interface Trip Stop Errors: (ORA-20001 Unable To Locate A Valid Sales Tax Rate) & (ORA-20002: 3135: Wf_Item_Activity_Status)
Last updated on MAY 23, 2018
Applies to:
Oracle Shipping Execution - Version 11.5.9 and laterInformation in this document applies to any platform.
Form:WSHFSTRX.FMB - Shipping Transactions Form
Executable:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
Symptoms
Some orders fail the interface trip stop. The Interface Trip Stop - SRS log file shows a couple of different problems:
1)
Generated CCID :
Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived
Return CCID :
Concat Segments :
Concat Id :
Concat Descriptions :
Error Message : ORA-20002: 3135: 'Wf_Item_Activity_Status.
Set_Error(error_process)' is not permitted in synchronous processes.
LEAVING OE_MSG_PUB.ADD
Exiting OE_Flex_Cogs_Pub.Start_process : E
User-Defined Exception:80
Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3135:
'Wf_Item_Activity_Status.Set_Error(error_process)' is not permitted in synch
ronous processes.
ret_status:E account_id:3399
Unable to get account for delivery detail id 5240993
Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived
Return CCID :
Concat Segments :
Concat Id :
Concat Descriptions :
Error Message : ORA-20002: 3135: 'Wf_Item_Activity_Status.
Set_Error(error_process)' is not permitted in synchronous processes.
LEAVING OE_MSG_PUB.ADD
Exiting OE_Flex_Cogs_Pub.Start_process : E
User-Defined Exception:80
Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3135:
'Wf_Item_Activity_Status.Set_Error(error_process)' is not permitted in synch
ronous processes.
ret_status:E account_id:3399
Unable to get account for delivery detail id 5240993
2)
some error occurred ORA-20001: Unable to locate a valid Sales Tax rate for
transaction. Ensure that an active Sales Tax rate exists for the Location.
transaction. Ensure that an active Sales Tax rate exists for the Location.
Also note the bottom of the log file:
InterfaceTripStop: total stops processed: 54
Stops processed for ORDER MANAGEMENT with status NORMAL: 0
Stops processed for ORDER MANAGEMENT with status WARNING: 3
Stops already interfaced for ORDER MANAGEMENT: 51
Stops processed for INVENTORY with status NORMAL: 0
Stops processed for INVENTORY with status WARNING: 51
Stops already interfaced for INVENTORY: 0
Stops processed for ORDER MANAGEMENT with status NORMAL: 0
Stops processed for ORDER MANAGEMENT with status WARNING: 3
Stops already interfaced for ORDER MANAGEMENT: 51
Stops processed for INVENTORY with status NORMAL: 0
Stops processed for INVENTORY with status WARNING: 51
Stops already interfaced for INVENTORY: 0
The OM interface is not the problem, it is the Inventory interface.
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