Freight Terms Message from EBS Is Not Subscribed in RMS Due to Dates Being Null (Doc ID 2171492.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.7 and later
Information in this document applies to any platform.

Symptoms

The Freight Terms message from E-Business Suite (EBS) is not subscribed in Retail Merchandising System (RMS) due to dates being NULL.


Steps to Reproduce:

  1. Create a Freight Term by calling RMSUB_FTERM.CONSUME.
  2. Pass only Freight Term ID, Description, and enabled flag.
  3. Note the below error message:
INVALID_PARM_IN_FUNC@1I_record_variable@2NULL@3FTERMS_SQL.CHECK_NULLS

 

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