badsql:Final_Acct( 45 ): ORA-01426: numeric overflow after CMCMCW ends in Warning

During our testing in our R12.2.3 instance, there were some transactions, such as Account Alias Receipt and Account Alias Issue transactions that error out during costing.

The “Material cost transaction worker” (CMCMCW) ends in warning and fails to “Cost” the transactions. The costed_flag on the mtl_material_transactions is ‘E’, the Error Code is ‘ORA-01426: numeric overflow’, and the Error Explanation is ‘badsql:Final_Acct( 45 ): ORA-01426: numeric overflow’. During our testing in our R12.2.3 instance, there were some transactions, such as Account Alias Receipt and Account Alias Issue transactions that error out during costing. I searched Oracle Support and found DOC ID 1381450.1, 1364508.1, and 1386779.1 but these are for ORA-01722 and not for ORA-01426.