Oracle data fix remove unposted receipts and Full Merge events

 

 

We have follow the below script.

Step:1 Create back up table
Create table scratch.AR_RECEIPTS_BACKUP_MAY201 as
select * from apps.ar_cash_receipts_all
where cash_receipt_id = 16047898;
Commit;
Step:2 Execute the update script
Update apps.ar_cash_receipts_all
set prev_pay_from_customer = null, prev_customer_site_use_id = null
where cash_receipt_id = 16047898;

 

Recent Posts

Start typing and press Enter to search