Data fix script Required -- Receipts Posting Issue: Unprocessed Cleared Receipt Has AR_CASH_RECEIPT_
Dear ALL:
Already read Doc ID 1263294.1 run this script:
select crh.cash_receipt_history_id,
crh.cash_receipt_id,
crh.org_id,
to_char(crh.trx_date, 'DD-MON-YYYY fmHH:MI:SS') trxdate,
to_char(crh.gl_date, 'DD-MON-YYYY fmHH:MI:SS') gldate,
crh.event_id
from ar_cash_receipt_history_all crh
where crh.event_id is null
and crh.posting_control_id = -3
and crh.gl_date between to_date('&startdate','DD-MON-YYYY') and to_date('&enddate','DD-MON-YYYY');
Two record are found.
Data fix script Required.
Ata