Post date: Aug 19, 2019 4:12:58 AM
Hi Customer:
Here is the script to correct the data for the new transaction:
********************* FOR TEST INSTANCE FIRST *********************
CUSTOMER_TRX_ID TRX_NUMBER
1789138 119003913
Step 1) data backup & udpate
Create table temp_ps_1789138
as select * from ar_payment_schedules_all where customer_trx_id in (1789138) and term_id=3906;
--3 records will be updated
Update ar_payment_schedules_all
set terms_Sequence_number = terms_sequence_number-2
where customer_trx_id in (1789138) and term_id=3906;
Step 2) commit the database change after confirm the updated record is correct
.
After this,please re-create the accounting for this transaction.
In case not working, please provide the create accounting log.
By the way, if the workaround is work for (119003467), maybe we can use the way for the new one in case the suggested script doesn't work.
Any Question / Doubt about this, Please reply in SR, thanks.
Regards,
Michael
Oracle Customer Support