WSHINTERFACE: Open Shipping Transaction Error in Validate_Line : No Open Period Found for Date Entered, Prevents Inventory Close (Doc ID 746268.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 and later
Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
EXECUTABLE:WSHINTERFACE - Interface Trip Stop

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:

Inventory Period Close issue with Order Number = 1419698

Order Number = 1419698 has 4 lines however the issue is with line 2.1
in an AWAITING_SHIPPING status and the associated Delivery for this line
shows that the Delivery is Shipped , however not Interfaced to OM or INV

therefore unable to execute "interface trip stop" on the delivery line.
Delivery status at "Shipped", with Next Step at "Run Interface".
Manually running Trip Stop provides a batch error

ERROR
WSHINTERFACES module: Interface Trip Stop - SRS


[29-OCT-08 06:14:27] INV_TXN_MANAGER_GRP: Error in validate_line : No open
period found for date entered
[29-OCT-08 06:14:27] INV_TXN_MANAGER_GRP: Error:User-Defined Exception
[29-OCT-08 06:14:27] INV_TXN_MANAGER_PUB: Error in Line Validatin
[29-OCT-08 06:14:27] INV_TXN_MANAGER_PUB: Error in Line Validatin
[29-OCT-08 06:14:27] INV_TXN_MANAGER_PUB: Failed Interface ID : 43677972 Item:
6947Org : 204
[29-OCT-08 06:14:27] INV_TXN_MANAGER_PUB: All records failed after line
validation
[29-OCT-08 06:14:27] INVTXNB: Error from INV worker : error_code : Account
period, err_expl :No open period found for date entered
Current Time is ==> 10/29/2008 06:14:27 AM
l_outcome ==> FALSE
MTL_ONLINE_TRANSACTION_PUB.process_online returns false
Error Code:Account period
Error Explanation:No open period found for date entered

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Manually run the Interface Trip Stop with debug on.

-- Business Impact:
The issue has the following business impact:
Month Close issue

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