Supplier Interface data is rejected (status=rejected), but no data is being displayed in the AP_SUPPLIER_INT_REJECTIONS (Doc ID 1577638.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

The Suppliers Open Interface Import program rejects suppliers but does not report these in the output.
For a specific run, 4 out of 11 suppliers were reported in the rejected section of the report.
No suppliers were imported, suggesting the other seven suppliers were rejected but the reasons are not provided.

Analysis suggests the problem occurs because values in the 'HOLD_BY' column are not valid when cross-checked against the data in per_all_people_f table.  Specifically, the data is not found in per_all_people_f table for the seven rows with this value.

The four suppliers that were reported as rejected did not have any value in the 'HOLD_BY' column.  The customer feels such records should be reported in the rejections report.

Expectations
If suppliers are rejected with invalid Hold By value, the program should explain the same.

Steps to reproduce
1. Run the 'Suppliers Open Interface Import' program with these parameters:
- P_WHAT_TO_IMPORT='REJECTED'
- P_COMMIT_SIZE='1000'
- P_PRINT_EXCEPTIONS='N'
- P_DEBUG_SWITCH='N'
- P_TRACE_SWITCH='N'

2. Make sure the supplier data is having an invalid employee Id.

3. Submit the request, it completes normally.

Review output: no suppliers were imported and four suppliers were rejected. That leaves seven suppliers unaccounted for.

Changes

 

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