My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

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


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:XXX]
3 : 590465-001[Org:AM1] ==> 539690-002[Org:XXX]
4 : 539690-002[Org:AM1] ==> 539690-402[Org:XXX]
5 : 539690-402[Org:AM1] ==> 539683-005[Org:XXX]
6 : 539683-005[Org:AM1] ==> 590465-001[Org:XXX]
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 : XXX
Cost Type : XXX
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 : XXX
Take 7.78858 / .238546 = 32.65
This should be the rate from resource above of 27.40.


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.