My Oracle Support Banner

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 JUNE 21, 2023

Applies to:

Oracle Shipping Execution - Version and later
Oracle Order Management - Version and later
Information in this document applies to any platform.


-- Problem Statement:
On 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

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
[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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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