Skip to main content
Question

Data corruption in PART_COST_BUCKET_TAB during Cost Calculation job

  • August 15, 2026
  • 0 replies
  • 33 views

Forum|alt.badge.img+4

During a mass Calculate Part Cost execution, the Qty_Per_Assembly for Raw Material components at Level 0 is being rapidly and repeatedly overwritten with the BOM component quantities of their parent parts.

  • re is a variable scope issue or incorrect parameter passing (Component Part No instead of Parent Part No) in the UPDATE cursor within Cost_Calculation_API or Part_Cost_Bucket_API, causing it to directly commit temporary rollup quantities to the component's own base cost bucket record.

  • Attach the History Log of the RM part and mention the "dancing numbers" observed in real-time on the Part Cost UI