Receivables - EBS (MOSC)

MOSC Banner

Data fix script Required -- Receipts Posting Issue: Unprocessed Cleared Receipt Has AR_CASH_RECEIPT_

edited Nov 27, 2013 9:56PM in Receivables - EBS (MOSC) 2 commentsAnswered

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

 

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