AR Receipt Unposted Entries To Be Moved To The Next Open Period
Last updated on MAY 23, 2017
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.
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