PRC:POZ: 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 NOVEMBER 09, 2021

Applies to:

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

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