ORA-06512 "APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG" Error When Maximum Location Length Has Been Exceeded

(Doc ID 1989134.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Migration Issues 11i to R12

Currently in the process of migrating OPM 11i to R12.
For all locations that are 13 characters or longer for an OPM warehouse migrated as a subinventory the migration script is prefixing the location with the subinventory code.

For example:
11i
Plant - AAA
OPM Warehouse - AAA1 -----AA1 discrete org
OPM Location RECEIVING INSP

Migrate plant AAA as existing organization AA1
Migration OPM warehouse AAA1 as subinventory

Migration script is trying to prefix the OPM location RECEIVING INSP as AAA1 RECEIVING INSP which goes over the 16 max character length in IC_LOCT_MST table and the following error is shown in the migration log:

ERROR
-----------------------
Unexpected Location :AAA1 RECEIVING INSP:ORA-20001: OPM-0: Location 'AA1-AAA1 RECEIVING INSP' : value AAA1 RECEIVING INSP for col Location is longer than max 16
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG", line 290
ORA-04088: error during execution of trigger 'APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG' occurred.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run migration from 11i to R12


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