How to Fix Claim Awaiting Transaction Processing Error

How to Fix Claim Awaiting Transaction Processing Error

Symptom-

There no prior or unposted transaction prior to this patient yet whenever you try to post a payment, a message pops up 'This claim was awaiting transaction processing when you pulled up the claim data, but has since finished processing. You must refresh the claim list before posting transactions to this claim. Would you like to refresh now?'  If you click yes and try posting the payment again, it brings up the same error message.

Fix

There is again some records in transaction detail preprocessing without record in transaction preprocessing. Used the below scripts to help find the claims.

SELECT tdp.* FROM transaction_detail_preprocessing tdp

INNER JOIN claims c ON tdp.claim_id = c.claim_id

WHERE c.claim_id = 

 

SELECT ts.description, t.* FROM transaction_preprocessing t

INNER JOIN transaction_status ts ON t.status = ts.status

WHERE trans_id_preprocessing =

 

SELECT p.acct_number, tdp.*

FROM transaction_detail_preprocessing tdp

INNER JOIN claims c ON tdp.claim_id = c.claim_id

INNER JOIN patients p on c.patient_id = p.patient_id

--WHERE trans_desc_id = 310

WHERE trans_id_preprocessing = 9031561

 

SELECT tdp.*

FROM transaction_detail_preprocessing tdp

INNER JOIN claims c ON tdp.claim_id = c.claim_id

--WHERE trans_desc_id = 310

WHERE c.claim_id = 10025831

 

Used the delete script to remove

delete from transaction_detail_preprocessing where claim_id = and trans_id_preprocessing =

    • Related Articles

    • Resolve Batch/Payment Awaiting Processing Error

      How to find the awaiting processing batch:  1. From the claim transaction detail screen, click on the Transaction that is bold with Awaiting Processing Error(s) message 2. Click the "Go To Payment" button in the top right corner - this will take you ...
    • EDI Claim Error - Processing Errors

      Here are the steps to resolve. 1. Pull up claim id# in Claim - General 2. Go to the Claim-Details tab 3. Uncheck any red line items and then recheck, saying OK or yes to any pop-up boxes 4. Release the claim as New
    • Processing Error - Cannot Submit a claim

      Please follow these steps for claims that are in Processing Errors status and the Error reads-Cannot submit a claim detail that exists in an active claim final version. 1. Load the claim into Claim-General 2. Uncheck the box next to the red service ...
    • EDI Claim Error - Processing Errors

      Here are the steps to resolve. 1. Pulled up claim #  2. Go to Claim-Details tab 3. Uncheck line items and then recheck, saying OK or yes to any pop up boxes 4. Release the claim as New.
    • Billing Applet Claim Bucket Definitions

      Introduction A description of each of our claim buckets and the claim types they contain More Information Bucket   Status   Description   For Follow-up                 Statements Not Going   Claims for accounts with statements on hold. Also includes ...