Credit a Transaction with a Payment Schedule Id > 2147483647 Error - ORA-01426: Numeric Overflow Error (Doc ID 1567187.1)

Last updated on MAY 07, 2019

Applies to:

Oracle Receivables - Version 12 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Attempting to credit a transaction with payment schedule id > 2147483647 and receive the following error:

ERROR
-----------------------
Error calling arp_process_header.post_commit ORA-01426: numeric overflow

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to credit a transaction with payment schedule id > 2147483647 either using an API or from front end