My Oracle Support Banner

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

Last updated on JUNE 04, 2018

Applies to:

Oracle Retail Invoice Matching - Version 16.0.1 and later
Information in this document applies to any platform.

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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.