Inventory Management - EBS (MOSC)

MOSC Banner

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

edited Aug 7, 2012 6:34PM in Inventory Management - EBS (MOSC) 1 commentAnswered ✓
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center