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

Last updated on JUNE 20, 2016

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms