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 later
Information in this document applies to any platform.
Form:WSHFSTRX.FMB - Shipping Transactions Form
Executable:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
Some orders fail the interface trip stop. The Interface Trip Stop - SRS log file shows a couple of different problems:
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.
Exiting OE_Flex_Cogs_Pub.Start_process : E
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
Unable to get account for delivery detail id 5240993
transaction. Ensure that an active Sales Tax rate exists for the Location.
Also note the bottom of the log file:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms