CSTPDPPC Periodic Cost Distributions Processor Fails with error 'CSTPDPPC.dyn_proc_call...30005There are no accounts defined for the category, for the cost type, cost group and legal entity.CLE_F145_CAL_MAIN_PKG.create_dist_entry : 30'

(Doc ID 2398916.1)

Last updated on MAY 15, 2018

Applies to:

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

Symptoms

On  Period Close, Periodic Average Costing

Transaction is not processing transactions raising error in mtl_material_transactions, and CSTPDPPC Periodic Cost Distributions Processor Fails in error
ERROR
-----------------------
CSTPACIN.COST_INV_TXN:CSTPACDP.insert_account (10) ORA-01400: ("INV"."MTL_TRANSACTION_ACCOUNTS"."REFERENCE_ACCOUNT") cannot be NULL

CSTPDPPC Periodic Cost Distributions Processor Fails with error 'CSTPDPPC.dyn_proc_call...30005There are no accounts defined for the category, for the cost type, cost group and legal entity.CLE_F145_CAL_MAIN_PKG.create_dist_entry : 30'



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Inventory Management
2. Navigation Path: Transactions
3. Material Transactions

--

The issue can be reproduced at will with the following steps:
1. Responsibility: Cost Management
2. Navigation Path: Periodic Costing
3. Submit PAC processes > CSTPDPPC Periodic Cost Distributions Processor Fails in error

Changes

 

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