Component item's quantity is showing incorrect in Cost rollup — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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) = 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!