My Oracle Support Banner

Not Able to Import Items Using Items Open Interface - Throws Error 'FLEXFIELDS SERVER-SIDE VALIDATION' (Doc ID 2921328.1)

Last updated on FEBRUARY 16, 2023

Applies to:

Oracle Inventory Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Not able to create any item  while importing through item open interface (IOI). Following error is thrown by the system on all the records.


Error

In MTL_INTERFACE_ERRORS, following can be seen.

MESSAGE_NAME: INV_IOI_ERR_SEG_FFK_CK_FAIL
Error Details: Please inform your support representative that:

FLEXFIELDS SERVER-SIDE VALIDATION package reports error:

SSV.validation_engine() exception: ORA-06508: PL/SQL: could not find program unit being called"


Steps

The issue can be reproduced at will with the following steps:

1. Insert records into MTL_SYSTEM_ITEM_INTERFACE table.
2. Run Item Import (INCOIN) program. (Navigation Inventory -> Items -> Import -> Import Items)
3. See the error in the log.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.