Receivables - EBS (MOSC)

MOSC Banner

Missing event_id for credit memo application

edited Feb 17, 2016 4:17AM in Receivables - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center