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.
ENGUCMIB.pls
ChangeImportManager.java

Symptoms

When attempting to run Structure Bulk Load in PIM, the following error occurs.

ERROR

STEPS

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.

Changes

The client was able to complete this process before Patch 16226394: PIM 12.1.3.2 RUP CONSOLIDATION was applied to the environment.

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