Dispute Tickets Integration with AR_DISPUTE_HISTORY

Hi,

As per the business scenarios, the end-customers of business will raise a billing dispute by sending an email. That email will create a ticket in Service Now.

What should be the ideal way to ensure that transaction details, amount in dispute could be real time / regular basis be updated to Oracle Receivables. What should be the action in terms of integration / interface to ensure the dispute is recorded in the AR_PAYMENT_SCHEDULES_ALL.AMOUNT_IN_DISPUTE and row is created on AR_DISPUTE_HISTORY table for the dispute.

Thanks in advance for your inputs.

Regards,

Saurabh