Missing event_id for credit memo application
Hello
We are having a situation where every month, there are hundreds of creditmemo's that remain as unposted items, when in fact they have been posted to GL.
This query confirms it.
SELECT ra.receivable_application_id,
ra.customer_trx_id,
ct.trx_number
FROM ar_receivable_applications_all ra,
ra_customer_trx_all ct
WHERE ct.customer_trx_id = 5446001
AND ra.posting_control_id = -3
AND ra.application_type = 'CM'
AND ra.event_id is null
AND ra.customer_trx_id = ct.customer_trx_id
Working on numerous SRs, recommendation is to apply RPC4 patch.
We are currently on R12 AR RPC Aug 2014 and R12 SLA RPC Aug 2014