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.
Last updated on FEBRUARY 22, 2018
Applies to:Oracle Fusion Supplier Model Cloud Service - Version 22.214.171.124.0 and later
Oracle Fusion Supplier Model - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms