Component item's quantity is showing incorrect in Cost rollup

Summary:

Component item's quantity is showing incorrect in Cost rollup

Content (required):

Hello Experts,

I have encountered one issue and need some help to rectify the same. The data set is as follows:

The picture above is the exact representation of how the BOM is setup for FG item in Oracle system.

I am performing Cost Rollup for FG Item (ITEM_FG_1). In Rollup, the quantity of Level 4 Component item (highlighted in yellow) comes up as 1, however, it should be proportionate to Phantom quantities that are level above it.

Example: The expected quantity of Level 4 Component item in Cost rollup is 1 (Phantom Level 1 Quantity) * 0.002 (Phantom Level 2 Quantity) * 0.0425 (Phantom Level 3 Quantity) =