The Structure Bulk Load Ends With Warning Errors ORA-01422 ORA-00936 And No Change Order Is Created
(Doc ID 1916624.1)
Last updated on FEBRUARY 06, 2017
Applies to:Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to run Structure Bulk Load in PIM, the following error occurs.
oracle.apps.fnd.framework.OAException: Application: BOM, Message Name: BOM_VALIDATION_FAILURE. Tokens: ERROR_MESSAGE = Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: ORA-00936: missing expression;
The issue can be reproduced at will with the following steps:
1. Navigate to Development Manager responsibility > Import From Excel > Select Structure as Object
2. Select Type as Manufacturing with primary and component information for import format.
3. Populate details with the components that will be added to the two existing structures.
4. Import the data with the Change Order. The Change Order setup will have only two steps (Open and Complete) which users are using to track the changes and who has done it.
Structure Bulk Load ends in warning and no Change Order is created.
The client was able to complete this process before Patch 16226394: PIM 188.8.131.52 RUP CONSOLIDATION was applied to the environment.
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