badsql:Final_Acct( 45 ): ORA-01426: numeric overflow after CMCMCW ends in Warning
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.