Supply Chain Bills of Material Indented Cost Report No Data Found Loop in the BOM structure (Doc ID 1084984.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.1 and later
Information in this document applies to any platform.
***Checked for relevance 08-SEP-2012***


Supply Chain Cost Rollup - Print Report does not rollup costs for a  particular model .   No error messages are received in the concurrent request logfile, but the Supply Chain Bills of Material Indented Cost Report results in No Data Found.

The FND_LOG_FILE shows that there is a loop found for 6 items as follows:
1 : 450[Org:AM1] ==> 450 BASE[Org:AM1]
2 : 450 BASE[Org:AM1] ==> 590465-001[Org:AM1]
3 : 590465-001[Org:AM1] ==> 539690-002[Org:AM1]
4 : 539690-002[Org:AM1] ==> 539690-402[Org:AM1]
5 : 539690-402[Org:AM1] ==> 539683-005[Org:AM1]
6 : 539683-005[Org:AM1] ==> 590465-001[Org:AM1]
Warning: Please check for Loop in the BOM structure above.
Customer applied  patch but costs are still not rolling up.  Concurrent request logfile now completes with warning and
FND_LOG has slightly different error:

MSG-00000:   Rollup ID = 1443662
MSG-00000: Before  CSTPSCEX.supply_chain_rollup 2010/03/29 14:15:37
MSG-00000: After  CSTPSCEX.supply_chain_rollup 2010/03/29 14:16:34
MSG-00000: WARNING! Loop  found: 7 rows unexploded
MSG-00000: Launched Delete  Supply Chain Cost Rollup Data Request : 35940571

File Versions:
$BOM_TOP/reports/US/CSTRSCCR.rdf       120.9.12010000.4
$BOM_TOP/patch/115/sql/CSTSCEXB.pls    120.12.12010000.3
$BOM_TOP/patch/115/sql/CSTSCCRB.pls    120.15.12010000.5

COST MANAGEMENT Responsibility
Run Concurrent Request : Supply Chain Cost Rollup - Print Report
For specific Item : 450
Review Resource Rate :
Resource : SD_L_SOFT
Cost Type : NX YR STD
Rate : 27.40
After running concurrent program review New item costs :
Item Costs ==> Item Costs
Select Model : 450
Click on Costs
Find Rollup Item Costs for Resource : SD_L_SOFT
Take 7.78858 / .238546 = 32.65
This should be the rate from resource above of 27.40.

Margin calculations will not be correct if costs cannot be rolled up.


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