ORA-06512 "APPS.GMF_MTL_ITEM_LOCATIONS_BIUR_TG" Error When Maximum Location Length Has Been Exceeded
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.
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.
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:
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.
The issue can be reproduced at will with the following steps:
1. Run migration from 11i to R12
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