Supply Chain Indented Bills Of Material Cost Report Displays CSTPSCEX.explode_sc_cost_flags():40:ORA-01476
(Doc ID 1904489.1)
Last updated on NOVEMBER 05, 2016
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
After applying patch 13946967 and 17840343, then executing 'Supply Chain Cost Rollup - Print Report'
the following error occurs.
MSG-00000: CSTPSCEX.explode_sc_cost_flags():40:ORA-01476: divisor is equal to zero begin top item id 8097349 top org id: 329 assembly item id: 7961088 assembly org id: 329 component item id:
Business needs to run/view/print the Supply Chain Costed BOM print reports, we can not have report end in error.
"Supply Chain Cost Rollup - Print Report"
MSG-00000: CSTPSCEX.explode_sc_cost_flags():40:ORA-01476: divisor is equal to zero
The "Supply Chain Cost Rollup - Print Report" is critical to the Business, we do not have another tool that provides the complete
supply chain costed BOM information.
This report can not end in error. Business wants any situation where there is a zero BOM component qty and the "Include in Cost Rollup" flag on, to be
a soft error.
Business has documented a
specific need to have zero qty items on the
BOM that they do not want the "Include in Cost Roolup" flag turned off, this is not a common event, but it would still make it very difficult to run
any mass program change and currently we have thousands of Items that would need to be researched to see
if they would be ok to be mass changed or not.
This is a hardship for the business to maintain.
1. Apply patch 13946967 and 17840343
2. Run 'Supply Chain Cost Rollup - Print Report'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!