My Oracle Support Banner

Material Transaction Has Error CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account ORA-01476 DIVIDE BY ZERO (Doc ID 1108909.1)

Last updated on SEPTEMBER 06, 2019

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.