How to Delete Stuckked/corrupted Lock Box Transmission format

Doyensys 2018-09-20 1 min read

select * from APPS.AR_TRANSMISSIONS_ALL
where TRANSMISSION_NAME=’IMCC161107′;

delete from apps.ar_transmissions_all
where transmission_name=’IMCC161107′

select * from apps.ar_payments_interface_all
where ORG_ID=82
and TRANSMISSION_ID=12172459;

Thanks,
Nagaraju M

Related blogs

WIP Job Close via Apex Application

Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming t…

Sivaguru Karunanidhi 2026-08-03 6 min read

Oracle Application Blog

Fixing Incomplete AP Open Balance on the Oracle ECC Supplier Balance Dashboard

Introduction/Issue: Even though supplier setup in Oracle Payables was correct, the “Supplier Balance” dashboard on the Oracle Enterprise Command Center (ECC) wa…

Suchithra Loganathan 2026-07-31 3 min read

Oracle Application Blog

Adding Order Date Filter to the Order Management ECC Dashboard

Introduction / Issue Users of the Order Management – Enterprise Command Center dashboard needed a way to narrow down the Orders by Order Date directly from the…

Suchithra Loganathan 2026-07-31 2 min read