To datafix ar date

Ar transactions shoshould be created on 6-jul-2010, in fact they were generated on 25-jun-2010. Because the ship_date_actual is on 25-jun-2010. Reboot .--------------------------------------------------------------------------------
-- Original date: trx_date = 25-jun-2010, gl_date = 25-jun-2010, due_date = 25-jul-2010
Explain select * from Ar. ra_customer_trx_all where trx_number in ('20140901', '20160901') and set_of_books_id = 89
-- Trx_date, ship_date_actualselect * from Ar. Distinct where customer_trx_id in (distinct) Select * from Ar. Distinct where customer_trx_id in (distinct) -- gl_dateselect * from Ar. Distinct where customer_trx_id in (distinct)
-- Due_date solution: ------------------------------------------------------------------------------- update ar. ra_customer_trx_all
Set trx_date = trunc (sysdate-2)
Where trx_number in ('123', '123') and set_of_books_id = 89; Alter trigger ra_cust_trx_line_gl_dist_bri disable; update ar. ra_cust_trx_line_gl_dist_all
Set gl_date = trunc (sysdate-2)
Where customer_trx_id in (9849489,9849490 );

Alter trigger ra_cust_trx_line_gl_dist_bri enable; update ar. ar_payment_schedules_all
Set trx_date = trunc (sysdate-2 ),
Gl_date = trunc (sysdate-2 ),
Due_date = trunc (sysdate + 28)
Where customer_trx_id in (9849489,9849490 );