'Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException

'Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException

Unable to Close the Inventory Period

~ Brief Description of Actions : 

Issue: Unable to close the period because of pending shipping transaction   

Solution: Pending Shipping Transaction completes and period can be closed

 

Datafix :

create table mti_06202012 as (select * from mtl_transactions_interface);

UPDATE mtl_transactions_interface
set process_flag = 1,
lock_flag = 2,
TRANSACTION_mode = 3,
last_updated_by = -3519394,
transaction_date = sysdate
WHERE transaction_type_id = 34
and error_explanation like
'Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException';


create table mti_06202012 as (select * from mtl_transactions_interface);

delete mtl_transactions_interface
where error_explanation like
'Error.. in INV_LOGICAL_TRANSACTIONS_PUB.create_logical_trx_wrapper oracle.apps.inv.transaction.utilities.InvTrxException';



create table wdd_06202012 as (select * from wsh_delivery_details where delivery_detail_id = 308530);

update wsh_delivery_details
set inv_interfaced_flag = 'X'
where delivery_detail_id = 308530;

*****************************************************************************************