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 MARCH 13, 2018

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 = 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

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 steps:
1. Manually run the Interface Trip Stop with debug on.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.