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.

Symptoms

After applying patch 13946967 and 17840343, then executing 'Supply Chain Cost Rollup - Print Report'
the following error occurs.

Error
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.
 Example:
"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.


Steps
1. Apply patch 13946967 and 17840343
2. Run 'Supply Chain Cost Rollup - Print Report'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms