Integrated Supplier Import Program Failing With Error For Products and Services records (Doc ID 1638877.1)

Last updated on MAY 05, 2016

Applies to:

Oracle Supplier Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Integrated Supplier Import Program is failing with error for Products and Services records

ERROR
-----------------------
Message: Inside PROCEDURE VALIDATE_VENDOR_PRODS_SERVICES Parameters: batch_id: 154000 party_id: 484235
 Output from pos_product_service_utl_pkg.get_product_meta_data: product_segment_definition: 1.2 product_segment_count: 2
 Invalid category id for: ps_interface_id: 2020004, concatenated_segments: 10.11
UIC***** No. of Messages: , Message: From import_vendor_prods_services API.
 Message: Inside PROCEDURE IMPORT_VENDOR_BUSS_CLASS Parameters: p_batch_id: 154000 request_id: 4846032
 Message: Inside PROCEDURE IMPORT_VENDOR_BUSS_CLASS Not imported(marked REMOVED) : 0 records. Reason interface_status in hz_imp_parties_int = R
 Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS Parameters: p_batch_id: 154000 request_id: 4846032
 Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS Not imported(marked REMOVED) : 0 records from table pos_party_tax_profile_int. Reason interface_status in hz_imp_parties_int = R



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate POS_PRODUCT_SERVICE_INT record in interface table.
2. Generate Batch.
3. Define Import.
4. Complete Import.

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