My Oracle Support Banner

CMCICU Update Standard Costs ORA-01400 Cannot Insert NULL Into MTL_TRANSACTION_ACCOUNTS REFERENCE_ACCOUNT (Doc ID 1296744.1)

Last updated on JANUARY 02, 2017

Applies to:

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


On : 12.1.3 version, Cost Maintenance

When attempting to run CMCICU module: Update Standard Costs, the following error occurs.


APP-FND-01564: ORACLE error 1400 in cmcugia()

Cause: cmcugia() failed due to ORA-01400: cannot insert NULL into ("INV"."MTL_TRANSACTION_ACCOUNTS"."REFERENCE_ACCOUNT")

The issue can be reproduced at will with the following steps:

1. Change the price of an item in customer price list.(OM Module)
2. Run "Import Cost From Price List" program. (INV Module)
3. Run "Cost Import Process" program. (INV Module)
4. Run "Update Standard cost" program. (INV Module).
5. Getting the attached error.


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

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