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 APRIL 22, 2024

Applies to:

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:

Inventory Period Close issue with Order Number

Order Number has 4 lines however the issue is with one line 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 step:
Manually run the Interface Trip Stop with debug on.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.