Supplier Site Import Returns Rejection Reason: HOLD_REASON Cannot Be Provided If All Of The Following Is N Or Null <Field Names>. Hold Reason In The Template Is Not Populated.

(Doc ID 2364416.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Fusion Supplier Model Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Supplier Model - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms


Supplier Sites Import

Supplier Sites Import ends in error and Supplier Sites Import Report shows an error:

Rejection Reason HOLD_REASON cannot be provided if all of the following is N or null.
HOLD_ALL_PAYMENTS_FLAG,
HOLD_UNMATCHED_INVOICES_FLAG,
HOLD_FUTURE_PAYMENTS_FLAG.

Hold Reason value in the template is not populated.


Steps to duplicate:

The issue can be reproduced at will with the following steps:
1. Edit Supplier > Supplier Site > Invoice tab is currently set up as follows:
Hold All Invoices = Yes
Payment Hold Reason = <Reason>
Hold Unmatched Invoices = Default from Payables Options
Hold Unvalidated Invoices = blanks

2. Update Supplier Site Import template is set up as follows:
Hold All Invoices = N
Hold Unmatched Invoices (HOLD_UNMATCHED_INVOICES_FLAG) = N
Hold Unvalidated Invoices (HOLD_FUTURE_PAYMENTS_FLAG.) = blanks
Payment Hold By (HOLD_BY) = blanks
Payment Hold Date (HOLD_DATE = blanks
Payment Hold Reason (HOLD_REASON) = blanks
Hold all new purchasing documents (HOLD_FLAG) = N
Hold Reason (PURCHASING_HOLD_REASON) = blanks

3. Execute Import Supplier Site process . Process ends in error.

4. Review Supplier Sites Import Report. Report shows Reject Reason;

HOLD_REASON cannot be provided if all of the following is N or null.
HOLD_ALL_PAYMENTS_FLAG,
HOLD_UNMATCHED_INVOICES_FLAG,
HOLD_FUTURE_PAYMENTS_FLAG.


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