My Oracle Support Banner

Sales Order Issue Transaction No Accounting Generated For Some Zero Cost Items (Doc ID 2555093.1)

Last updated on APRIL 23, 2021

Applies to:

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


On : 12.2.6 version, Inventory Costing

Sales Order Material Transaction Accounts in not generating

Material Transaction Accounts not generating when we do sales order Shipping .
Material transaction entry getting generated.
We have customized the COGS workflow and we see CCID getting generated .
As Interface trip stop completing normal and showing COGS account getting generated in the logs

I see in table mtl_material_transactions in column distribution_account_id CCID same as cogs workflow generated .

But on the Material transaction form when we click accounts tab there is no details .

Same i see in table MTL_TRANSACTION_ACCOUNTS there is no entry

 many Sales order like this .
  the same issue with seeded workflow as well.
Created in DEV instance for SO # 1 - seeded w/f
SO# 2 - custom workflow.

Expect Sales Order Issue transaction to show accounting entries

The issue can be reproduced at will with the following steps:
1. Responsibility: Sales order
2. Navigation: Sales order
3. Create SO and book it
4. Order Management > shipping> Release Sales Orders SRS
5. Order Management > shipping> Transactions for Order
6. Order Management > Ship Confirm Deliver
7. Run the following programs:
   CSTRCMCR1 Record Order Management Transactions
   CSTRCMCR Collect Revenue Recognition Information
   CSTRCMCR3  Generate COGS Recognition Events


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.