ORA-01403: no data found - When Running 'Pre-Explode Configurable Bills of Material' program for an Assembly (Doc ID 2172032.1)

Last updated on AUGUST 13, 2016

Applies to:

Oracle Bills of Material - Version 11.5.10.2 and later
Oracle Configure to Order - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Bills

ACTUAL BEHAVIOR
---------------
The Pre-Explode Configurable Bills of Material program for the parent model XXXXXX, is not populating the bom explosions table.


Getting below error in CZ

9431700:CZ_IMP_SINGLE.EXTR_PS_NODE.11276:No BOM data to extract. Verify that the bill you want to import exists on the import enabled server.
9431700:CZ_IMP_SINGLE.IMPORTSINGLEBILL.XFRPROJECTS.11276:17273829:ORA-01403: no data found


EXPECTED BEHAVIOR
-----------------------
The Pre-Explode Configurable Bills of Material program should populate records into the bom_explosions table.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Pre-Explode Configurable Bills of Material program

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