CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account ORA-01476 DIVIDE BY ZERO

(Doc ID 1108909.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Cost Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

The log file of actual cost worker identified this error as one material transaction couldn't be costed. the error message is:

Error
-------

'CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account (10) ORA-01476: divisor is equal to zero''



TRANSACTION_TYPE_ID    TRANSACTION_ACTION_ID  TRANSACTION_SOURCE_TYPE_ID
18                                                                       27                                                             1
The transactions is Receiving from Purchase Order

CURRENCY_CODE CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_TYPE
                     USD                                                   0.00                                              User

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms