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***

Symptoms


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 p7654674_R12.BOM.C_R12_GENERIC.zip 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

   
NAVIGATION
----------------
COST MANAGEMENT Responsibility
Run Concurrent Request : Supply Chain Cost Rollup - Print Report
For specific Item : 450
Review Resource Rate :
Setup==>Sub-Elements==>Resources
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.

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

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