Invoice Induction Requiring Optional Fields To Be Populated On The Template (Doc ID 2405984.1)

Last updated on NOVEMBER 30, 2021

Applies to:

Symptoms

ReIM induction is requiring all fields to be populated even if it can be optional.
Fields displayed on spreadsheet are not necessarily required.
This is also a different behavior from other RMS induction.

Steps to recreate the issue:
1)Make Comments column mandatory
     update S9T_TMPL_COLS_DEF set MANDATORY='Y' where template_key =
     'REIM_MRCHI_HDR' and wksht_key = 'DOC_HEADER' and column_name='Comment'
2)Login to the application
    Tasks>data loading >Download Template
    Template Type=MERCHANDISE
    Template=Merchandise Invoice Header Only-No Tax
    Download the template
3)Open the template and fill in all the required fields ...but do not fill in the COMMENT column
4)Tasks>data loading >Upload data
      Template Type=MERCHANDISE
      Template=Merchandise Invoice Header Only-No Tax
      Download the template
      Template Type=MERCHANDISE
      Template=Merchandise Invoice Header Only-No Tax
      Browse and upload the file modified in step above
      The Invoice gets uploaded.
5)Tasks>data loading >Manage Request and search for the document upload.We can observe that the status of the document is "SUCCESS_WITH_ERRORS"
6)View errors,you will see that the cause of the error is because of "Invalid comments"

There should not be errors since COMMENTS is a optional Field.

Cause

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