My Oracle Support Banner

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 FEBRUARY 02, 2019

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.


The Suppliers Open Interface Import program rejects suppliers but does not report these in the output.
For a specific run, only few suppliers out of the list of full rejected 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.

The 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.

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_COMMIT_SIZE='1000'

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.


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
 Standard Patching Process
 Patch Wizard
 Have more questions?

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