We have just went live on 11.5.10. In Accounts Payable, the same document sequence was assigned to a

 We have just went live on 11.5.10. In Accounts Payable, the same document sequence was assigned to all AP categories(Including Invoices and Payments).

Our requirement is to have a separate sequence for invoices and payments.

We can create a new sequence for Invoices and Payments in AP but we  need a data fix to update the sequence numbers assigned to already created  AP transactions(Invoices and Payments), so that the sequence numbering is continuous.

This is also a legal requirement for countries in Europe .

Oracle does not support this as this was a mistake in setup.

Any help is greately appreciated.