Create INV Snapshots ERROR where MSC Source Setup = Y generates ORA-06502: PL/SQL: numeric or value error: host bind array too small ORA-06512: at line 1

(Doc ID 2304364.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, upgraded from 12.1.3, Data Collections Create INV Snapshots completes in error:

ERROR
-----------------------

logfile: l82577156.req


MSCINVSN: Create INV Snapshots

08-FEB 14:44:41 : Snapshot Log on MTL_ITEM_CATEGORIES already exists...
ORA-12000: a materialized view log already exists on table 'MTL_RELATED_ITEMS'

08-FEB 14:58:32 : Creating Snapshot for MTL_TXN_REQUEST_LINES ...
08-FEB 14:58:32 : ORA-00904: "MTRL"."OWNING_TP_TYPE": invalid identifier

Also seen in corresponding file o82577156.out:


ERROR:
ORA-06502: PL/SQL: numeric or value error: host bind array too small
ORA-06512: at line 1

 

 

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