R12: Supplier Sites Open Interface (APXSSIMP) Fails to Import Records: AP_VENDOR_ID_NULL Rejection Reason in AP_SUPPLIER_INT_REJECTIONS (Doc ID 1311279.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

The Supplier Sites Open Interface Import (APXSSIMP) program does not take the value ('All', 'New' or 'Rejected') for parameter 'Import Options' into account, when in interface table is populated with VENDOR_INTERFACE_ID instead of VENDOR_ID.

Request errors and the Rejection Code AP_VENDOR_ID_NULL is shown in the output.

If the VENDOR_ID is populated this no longer occurs, however, the documentation states that this program requires VENDOR_INTERFACE_ID or VENDOR_ID.

-- Steps to Reproduce
1) Loaded a new record in table AP_SUPPLIER_SITES_INT with STATUS column ='NEW'
2) Submitted Supplier Sites Open Interface Import concurrent program with Import Options parameter set to 'Rejected'.
3) Checked the output of the program; it says: '*** No Data Exists for this Report ***'
4) Checked interface table AP_SUPPLIER_SITES_INT; the STATUS column now shows
'REJECTED' (so, the table has been updated by the conc. prog.).
5) Checked interface table AP_SUPPLIER_INT_REJECTIONS; it shows a record (REJECT_LOOKUP_CODE = AP_VENDOR_ID_NULL with a reference PARENT_ID to
the record in table AP_SUPPLIER_SITES_INT (so, this record has been inserted by the conc. prog.).

Changes

Cause