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