Interface Trip Stop Errors: (ORA-20001 Unable To Locate A Valid Sales Tax Rate) & (ORA-20002: 3135: Wf_Item_Activity_Status) (Doc ID 266463.1)

Last updated on DECEMBER 05, 2016

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

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


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.



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


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