My Oracle Support Banner

GET_ACCT_PERIOD: no_data_found error Error In Inv_logical_transactions_pub.Create_logical_trx_wrapper (Doc ID 311242.1)

Last updated on AUGUST 11, 2022

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
This document includes all versions of Oracle EBS 11i and R12

FORM:INVTVPTX.FMB - View Pending Interface Activity (Transaction Open Interface form)
EXECUTABLE:WSHINTERFACE - Interface Trip Stop
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS


Symptoms

Find Internal Order Issues transactions stuck in the transaction open interface (MATERIAL_TRANSACTIONS_INTERFACE) table after running the Ship Confirm.
The trip stop interface completed in warning with the following error in the log file.

ERROR
GET_ACCT_PERIOD: no_data_found error
Failed to get acct period id for org:107 message
Error .. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper
**Ex: Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper
oracle.apps.inv.transaction.utilities.InvTrxException


STEPS
1. Go to Order Management > Shipping > Shipping Transactions.
2. Query the related order.
3. Choose the delivery tab.
4. Choose ship confirm.
5. Monitor for the trip stop concurrent program to complete.
6. The trip stop completes with the error noted above.

VERIFICATION
Verified the issue by enabling inventory debug and reviewing the resulting trip stop request log:
See the error noted.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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