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
DE43030 has been targeted to be fixed in our upcoming PPM 15.5.1 release.