My Oracle Support Banner

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

Last updated on MARCH 01, 2021

Applies to:

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


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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.