Item Import Program INCOIN Creating Four Unnecessary Error Records in MTL_INTERFACE_ERRORS For Successful Import (Doc ID 2287761.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Found that for successful item/catalog imports the disk space is filled with irrelevant log messages printed in MTL_INTERFACE_ERRORS while doing massive imports.
The following are the errors found in the concurrent request log and in the interface errors table:

ERRORS
INV_ITEM_CATEGORY_OI.process_Item_Category_records: Before missing inventory_item_id
INV_ITEM_CATEGORY_OI.process_Item_Category_records: Before checking for created_by
INV_ITEM_CATEGORY_OI.process_Item_Category_records: After checking for created_by
INV_ITEM_CATEGORY_OI.process_Item_Category_records: Value for p_upload_rec_flag is 1

EXPECTED BEHAVIOR
There should not be log messages when debug is not setup and concurrent request finish with success.

STEPS
The issue can be reproduced at will with the following steps:
1. Run INCOIN for items and category assignments
2. Request completes without error
3. Request log shows massive amount of messages - 4 messages for each item imported
4. Interface error table is also showing the irrelevant errors messages - 4 error records for each item imported

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