AR Receipt Unposted Entries To Be Moved To The Next Open Period (Doc ID 2129366.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The accounting entries are not posted and needs sweep to next open period as per business requirement.

The following SQL identifies the record :

select ra.* from ar_cash_receipts cr, ar_receivable_applications ra
where ra.cash_receipt_id = cr.cash_receipt_id
and cr.cash_Receipt_id = &cash_receipt_id
and ra.gl_date between to_date('&start_gl_date','DD-MM-YYYY') AND

To_date('&END_gl_date','DD-MM-YYYY')

and ra.posting_control_id = -3

and not exists

( select 'x' from xla_events
where application_id = 222
and event_id = ra.event_id
and event_status_code = 'P'
and process_status_code = 'P' ) ;

-- Pass the cash receipt Id and gl_date of ar_receivable_appllications_all table and verify if the sql list the desired records.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms