My Oracle Support Banner

APP-FND-01934: ORA-01403: When Querying Indented Bills With 1000s Of Components (Doc ID 1254105.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Bills of Material - Version 12.1.3 and later
Information in this document applies to any platform.
Form:BOMFQBIN.FMB - Indented Bill of Material Inquiry


Symptoms

An error occurs attempting to view Bills of Material on the indented bills form (BOMFQBIN.fmb) when a level of the bill has more than 10,000 components.

Error
APP-FND-01934: ORA-01403: no data found in Package BOMPBXIN Procedure BOM_EXPLODER


Steps
1. Navigate to Bills of Material (BOM) > Bills > Intended Bills
2. Choose an item with more than 10000 components within one single level
3. Click on Find.

Changes

This issue occurs after <Patch 9355186> that was included in 12.1.3 RUP.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.