Investment Allocation Job Fails with an ORA-01438 Error

Document ID : KB000117051
Last Modified Date : 05/10/2018
Show Technical Document Details
Issue:
There is a maximum ID that can be reached in INV_INVESTMENT_ALLOCS_FLAT table. Once this maximum has been reached, the Investment Allocation job starts to fail with an ORA-01438 error. 

Steps to Reproduce: 
1. Have records in the INV_INVESTMENT_ALLOCS_FLAT table with ID's of 9999942507 to 9999999999 
2. Create additional investments 
3. Run the Investment Allocation job 

Expected Results: The Investment Allocation job runs without error. 
Actual Results: The job throws this error in the bg-system.log: ORA-01438: value larger than specified precision allowed for this column 
Cause:
Caused by DE43030
Resolution:
DE43030 has been targeted to be fixed in our upcoming PPM 15.5.1 release.