Delete AR

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