RMS Fails to Subscribe the Freight Term (FrtTermCre) Message Fails When Start and End Active Date Are Null

(Doc ID 2171492.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.1.7 to 13.1.9 [Release 13.1]
Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

As per FREIGHT_TERMS table definition in RMS data model, the start_date_active and the end_date_active fields are optional, however,  when you try to create freight term through Retail Integration Bus (RIB) interface or through Oracle E-Business Suite (EBS), the message fails in RIB hospital with below error

Error
-----------------------
[E] Invalid input parameter I_record_variable, passed as NULL, in function FTERMS_SQL.CHECK_NULLS.
FTERMS_SQL package is not allowing blank value for active date fields and rejecting message.


Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish Freight term creation message from the external system without start_active_date and end_active_date.
1a. Message family:  FrtTerm
1b. Message type:    FrtTermCre
2. Notice the below error on RIB error hospital
"javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_FRTTERMCRE.CONSUME(?,?,?)}: [E] Invalid input parameter I_record_variable, passed as NULL, in function FTERMS_SQL.CHECK_NULLS.

Changes

 

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