What is the transaction types for those pending uncosted transactions?
Also run below query and check DISTRIBUTION_ACCOUNT_ID and provide results for the same.
SELECT DISTRIBUTION_ACCOUNT_ID FROM mtl_material_transactions
WHERE costed_flag IN ('N', 'E')
AND TRANSACTION_id IN (& txns id)
These transactions are of Misc transactions.
and above script's output gives null DISTRIBUTION_ACCOUNT_ID.
Can you please suggest how to clear these transactions. ???
The records are stuck due to proper DISTRIBUTION_ACCOUNT_ID in not associated with those stuck records.
Please refer the below oracle note which provide the script to update DISTRIBUTION_ACCOUNT_ID.
Misc Transactions Errored Out (Doc ID 1398623.1)
Try this script on test environment 1st if not work then go for SR.
Thanks for your reply.
The note was useful for me and helped me to clear the records.